oracle 12c release2如何安装

这篇文章主要介绍了oracle 12c release2如何安装，具有一定借鉴价值，感兴趣的朋友可以参考下，希望大家阅读完这篇文章之后大有收获，下面让小编带着大家一起了解一下。0.需要添加如下文件几内容备注：/etc/oraInst.loc的内容为inventory_loc=/home/oracle/oraInventoryinst_group=oinstall1.
下载Oracle 12c
的压缩包，只有一个zip文件2.
添加用户组以及创建目录：groupadd oinstallgroupadd dbauseradd -g oinstall -G dba oraclepasswd oraclemkdir /u01; mkdir /u02; mkdir /u03;mkdir -p/u01/app/oracle/product/12.2.0.1/db_1chown -R oracle:oinstall /u01chown -R oracle:oinstall /u02chown -R oracle:oinstall /u033.
修改/etc/hosts文件127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4192.168.6.128 dbserver4.
修改/etc/sysctl.conffs.file-max = 6815744kernel.sem = 250 32000 100 128kernel.shmmni = 4096kernel.shmall = 1073741824kernel.shmmax = 4398046511104kernel.panic_on_oops = 1net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576net.ipv4.conf.all.rp_filter = 2net.ipv4.conf.default.rp_filter = 2fs.aio-max-nr = 1048576net.ipv4.ip_local_port_range = 9000 65500使参数生效 sysctl -p 5.
配置/etc/security/limits.d/oracle-rdbms-server-12cR2-preinstall.conforacle soft nofile 1024oracle hard nofile 65536oracle soft nproc 16384oracle hard nproc 16384oracle soft stack 10240oracle hard stack 32768oracle hard memlock 134217728oracle soft memlock 134217728 6.
修改/etc/pam.d/login session required pam_limits.so 7.
安装oracle需要的缺少的
包yum install binutils -yyum install compat-libcap1 -yyum install compat-libstdc++-33 -yyum install compat-libstdc++-33.i686 -yyum install glibc -yyum install glibc.i686 -yyum install glibc-devel -yyum install glibc-devel.i686 -yyum install ksh -yyum install libaio -yyum install libaio.i686 -yyum install libaio-devel -yyum install libaio-devel.i686 -yyum install libX11 -yyum install libX11.i686 -yyum install libXau -yyum install libXau.i686 -yyum install libXi -yyum install libXi.i686 -yyum install libXtst -yyum install libXtst.i686 -yyum install libgcc -yyum install libgcc.i686 -yyum install libstdc++ -yyum install libstdc++.i686 -yyum install libstdc++-devel -yyum in免费云主机域名stall libstdc++-devel.i686 -yyum install libxcb -yyum install libxcb.i686 -yyum install make -yyum install nfs-utils -yyum install net-tools -yyum install smartmontools -yyum install sysstat -yyum install unixODBC -yyum install unixODBC-devel -yyum install gcc -yyum install gcc-c++ -yyum install libXext -yyum install libXext.i686 -yyum install zlib-devel -yyum install zlib-devel.i686 -yyum install e2fsprogs -yyum install e2fsprogs-libs -yyum install libs -yyum install libxcb.i686 -yyum install libxcb -y 8.
修改/etc/selinux/config SELINUX=permissive 修改完后保存执行如下 # setenforce Permissive9.
关闭防火墙# systemctl stop firewalld# systemctl disable firewalld10.添加环境变量 #touch /etc/profile.d/setora.sh该文件添加如下内容：# Oracle Settingsexport TMP=/tmpexport TMPDIR=$TMP#export oracle.install.db.config.starterdb.globalDBName=oracle.sunyardexport ORACLE_HOSTNAME=dbserverexport GLOBAL_NAME=odbexport ORACLE_UNQNAME=hgsexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/db_1export ORACLE_SID=hgsexport PATH=/usr/sbin:/usr/local/bin:$PATHexport PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib11.将linuxx64_12201_database.zip上传服务器，并解压，解压后目录为 以静默方式安装需要配置responseFile
配置目录下的database/response/db_install.rsp，关键修改一下配置，否则安装时会报错，按照自己着真实配置 INVENTORY_LOCATION=/home/oracle/oraInventoryORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1ORACLE_BASE=/u01/app/oracleoracle.install.db.OSDBA_GROUP=oinstalloracle.install.db.OSOPER_GROUP=oinstalloracle.install.db.OSBACKUPDBA_GROUP=oinstalloracle.install.db.OSDGDBA_GROUP=oinstalloracle.install.db.OSKMDBA_GROUP=oinstalloracle.install.db.OSRACDBA_GROUP=oinstalloracle.install.db.config.starterdb.globalDBName=orcle12coracle.install.db.config.starterdb.SID=hgsoracle.install.db.config.starterdb.characterSet=AL32UTF8oracle.install.db.config.starterdb.memoryLimit=1024oracle.install.db.config.starterdb.password.SYS=HGShgs912122_oracle.install.db.config.starterdb.password.SYSTEM=HGShgs912122_oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/u02 保存文件12.
安装 图中标识的就是要运行的文件 可以
./runInstaller –help
查看帮助 运行如下安装 ./runInstaller -silent -responseFile /u03/database/response/db_install.rsp -showProgress会有进度提示13.创建数据库cd $ORACLE_HOME/dbs cp init.orainithgs.orachown oracle:oinstallinithgs.ora
将inithgs.ora
修改如下
内存大小根据真实情况调整*.audit_file_dest=’/u01/app/oracle/admin/orcl/adump’*.audit_trail=’db’*.compatible=’11.2.0’*.control_files=’/u01/app/oracle/controls/ora_control1′,’/u01/app/oracle/controls/ora_control2’*.db_block_size=8192*.db_domain=”*.db_name=’hgs’*.db_recovery_file_dest=’/u01/app/oracle/fast_recovery_area’*.db_recovery_file_dest_size=2G*.diagnostic_dest=’‘*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)’*.memory_target=3G*.open_cursors=300*.processes=150*.remote_login_passwordfile=’EXCLUSIVE’#*.undo_tablespace=’UNDOTBS1′ 切换到oracle用户 su – oraclesqlplus / as sysdba startup nomountCREATE DATABASE hgs USER SYS IDENTIFIED BY sys_password USER SYSTEM IDENTIFIED BY system_password LOGFILE GROUP 1 (‘/u01/app/oracle/oradata/hgs/redo01.log’) SIZE 1000M, GROUP 2 (‘/u01/app/oracle/oradata/hgs/redo02.log’) SIZE 1000M, GROUP 3 (‘/u01/app/oracle/oradata/hgs/redo03.log’) SIZE 1000M MAXLOGFILES 16 MAXLOGMEMBERS 2 MAXLOGHISTORY 1 MAXDATAFILES 100 CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16 EXTENT MANAGEMENT LOCAL DATAFILE ‘/u01/app/oracle/oradata/hgs/system01.dbf’ SIZE 1024M REUSE SYSAUX DATAFILE ‘/u01/app/oracle/oradata/hgs/sysaux01.dbf’ SIZE 1024M REUSE DEFAULT TABLESPACE users DATAFILE ‘/u01/app/oracle/oradata/hgs/users01.dbf’ SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE ‘/u01/app/oracle/oradata/hgs/temp01.dbf’ SIZE 500M REUSE UNDO TABLESPACE undotbs DATAFILE ‘/u01/app/oracle/oradata/hgs/undotbs01.dbf’ SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;创建完成后需要执行几个sql脚本 sys用户@?/rdbms/admin/catalog.sql@?/rdbms/admin/catproc.sql system 用户@?/sqlplus/admin/pupbld.sql至此，安装oracle以及创建数据库完毕感谢你能够认真阅读完这篇文章，希望小编分享的“oracle 12c release2如何安装”这篇文章对大家有帮助，同时也希望大家多多支持百云，关注百云行业资讯频道，更多相关知识等着你来学习!

相关推荐: sql server中怎么实现类型转换

sql server中怎么实现类型转换，相信很多没有经验的人对此束手无策，为此本文总结了问题出现的原因和解决方法，通过这篇文章希望你能解决这个问题。记录下 ：DECLARE @i INT;DECLARE @x INT;SET @i=3;SET @x=5;DEC…