1、Oracle Linux 7.1 安装 Oracle 12C RACOS 环境：rootrac12c1 # uname -aLinux rac12c1 3.8.13-55.1.6.el7uek.x86_64 #2 SMP Wed Feb 11 14:18:22 PST 2015 x86_64 x86_64 x86_64 GNU/LinuxIP 规划：rootrac12c1 # cat /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4:1 localhost localho
2、st.localdomain localhost6 localhost6.localdomain6# Public IP for Oracle 12C RAC172.16.30.221 rac12c1.localdomain rac12c1172.16.30.222 rac12c2.localdomain rac12c2# Private IP for Oracle 12C RAC192.168.30.221 rac12c1pri.localdomain rac12c1pri192.168.30.222 rac12c1pri.localdomain rac12c2pri# Virtual IP
3、 for Oracle 12C RAC172.16.30.223 rac12c1vip.localdomain rac12c1vip172.16.30.224 rac12c2vip.localdomain rac12c2vip#SCAN172.16.30.225 rac12c-scan.localdomain rac12c-scan禁用 Selinux：rootrac12c1 # cat /etc/selinux/config# This file controls the state of SELinux on the system.# SELINUX= can take one of th
4、ese three values:# enforcing - SELinux security policy is enforced.# permissive - SELinux prints warnings instead of enforcing.# disabled - No SELinux policy is loaded.SELINUX=disabled# SELINUXTYPE= can take one of three two values:# targeted - Targeted processes are protected,# minimum - Modificati
5、on of targeted policy. Only selected processes are protected.# mls - Multi Level Security protection.SELINUXTYPE=targetedrootrac12c1 # setenforce 0修改/dev/shm 大小为 8Gtmpfs /dev/shm tmpfs rw,exec,size=2048M 0 0rootrac12c1 # mount -o remount /dev/shm/禁用防火墙：rootrac12c1 # systemctl start firewalld.service
6、rootrac12c1 # systemctl stop firewalld.servicerootrac12c1 # # systemctl disable firewalld.servicerm /etc/systemd/system/basic.target.wants/firewalld.servicerm /etc/systemd/system/dbus-org.Fedoraproject.FirewallD1.service重启各个节点操作系统，检查各个节点网络连通性：123rootrac12c1 # ping rac12c2prirootrac12c1 # ping rac12c
7、2，配置 YUM:rootrac12c1 # cat /etc/yum.repos.d/base.repool7_latestname=Oracle Linux $releasever Latest ($basearch)baseurl=file:/mntgpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-oraclegpgcheck=0enabled=1安装 oracle 相关的依赖包：rootrac12c1 # yum install oracle-rdbms-server-12cR1-preinstall y创建用户组和用户，上步操作依据创建了 oinsta
8、ll 54321 dba 54322 用户组）和用户oracle（ 54321），所以执行如下操作创建相关的用户组和用户添加组rootrac12c1 # groupadd -g 54323 operrootrac12c1 # groupadd -g 54325 asmdbarootrac12c1 # groupadd -g 54328 asmadminrootrac12c1 # groupadd -g 54329 asmoper添加 grid 用户rootrac12c1 # useradd -u 54322 -g oinstall -G dba,asmdba,asmadmin,asmoper
9、grid为 oracle 和 grid 用户设置密码12rootrac12c1 #passwd oraclerootrac12c1 # passwd grid确保 oracle 是 oper，asmdba 组成员1rootrac12c1 # usermod -g oinstall -G dba,oper,asmdba oracle修改用户资源限制:grid soft nofile 1024grid hard nofile 65536grid soft nproc 16384grid hard nproc 16384grid soft stack 10240grid hard stack 327
10、68grid hard memlock 134217728grid soft memlock 134217728# # Oracle useroracle soft nofile 1024oracle hard nofile 65536oracle soft nproc 16384oracle hard nproc 16384oracle soft stack 10240oracle hard stack 32768oracle hard memlock 13217728oracle soft memlock 134217728# End of file修改内核参数，fs.file-max =
11、 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 = 1048576fs.aio-max-nr = 1048576net.ipv4.ip_local_port_ran
12、ge = 9000 65500rootrac12c1 # /sbin/sysctl -p安装 oracleasm-support and oracleasmlib，配置共享磁盘。rootrac12c1 # rpm -qa | grep oracleasmkmod-oracleasm-2.0.8-8.el7.x86_64oracleasm-support-2.1.8-3.el7.x86_64oracleasmlib-2.0.8-2.el7.x86_64http:/ 下载ASMLIB 包。rootrac12c1 # /etc/init.d/oracleasm configure -iConfigu
13、ring the Oracle ASM library driver.This will configure the on-boot properties of the Oracle ASM librarydriver. The following questions will determine whether the driver isloaded on boot and what permissions it will have. The current valueswill be shown in brackets (). Hitting without typing ananswer
14、 will keep that current value. Ctrl-C will abort.Default user to own the driver interface grid: gridDefault group to own the driver interface asmadmin: asmadminScan for Oracle ASM disks on boot (y/n) y: yWriting Oracle ASM library driver configuration: doneInitializing the Oracle ASMLib driver: OK S
15、canning the system for Oracle ASMLib disks: OK rootrac12c1 # /usr/sbin/oracleasm configureORACLEASM_UID=gridORACLEASM_GID=asmadminORACLEASM_SCANBOOT=trueORACLEASM_SCANORDER=“ORACLEASM_SCANEXCLUDE=“ORACLEASM_USE_LOGICAL_BLOCK_SIZE=“false“rootrac12c1 # tail -2 /etc/pam.d/loginsession required /lib64/s
16、ecurity/pam_limits.sosession required pam_limits.so配置 DNS:rootrac12c1 # vim /etc/resolv.conf# Generated by NetworkManagersearch localdomain禁用 NTP 服务：1234rootrac12c1 #/sbin/service ntpd stoprootrac12c1 #chkconfig ntpd offrootrac12c1 #mv /etc/ntp.conf /etc/ntp.conf.orgrootrac12c1 #rm /var/run/ntpd.pid
17、建立安装目录：rootrac12c1 #mkdir -p /u01/app/12.1.0/gridrootrac12c1 #mkdir -p /u01/app/gridrootrac12c1 #mkdir -p /u01/app/oraclerootrac12c1 #mkdir -p /u01/app/oracle/product/12.1.0/db_1rootrac12c1 #chown -R grid:oinstall /u01rootrac12c1 #chown oracle:oinstall /u01/app/oraclerootrac12c1 # chmod -R 775 /u01/
18、分区，配置共享磁盘：12345678910111213141516171819202122oraclerac12c1 $ ls -l /dev/sd*brw-rw- 1 root disk 8, 0 Aug 21 18:33 /dev/sdabrw-rw- 1 root disk 8, 1 Aug 21 18:33 /dev/sda1brw-rw- 1 root disk 8, 2 Aug 21 18:33 /dev/sda2brw-rw- 1 root disk 8, 3 Aug 21 18:33 /dev/sda3brw-rw- 1 root disk 8, 16 Aug 22 20:27
19、 /dev/sdbbrw-rw- 1 root disk 8, 17 Aug 22 20:27 /dev/sdb1brw-rw- 1 root disk 8, 32 Aug 21 22:47 /dev/sdcbrw-rw- 1 root disk 8, 33 Aug 21 22:47 /dev/sdc1brw-rw- 1 root disk 8, 48 Aug 21 22:47 /dev/sddbrw-rw- 1 root disk 8, 49 Aug 21 22:47 /dev/sdd1brw-rw- 1 root disk 8, 64 Aug 21 22:47 /dev/sdebrw-rw
20、- 1 root disk 8, 65 Aug 21 22:47 /dev/sde1oraclerac12c1 $ /etc/init.d/oracleasm createdisk CRS /dev/sdc1oraclerac12c1 $ /etc/init.d/oracleasm createdisk DATA1 /dev/sd1oraclerac12c1 $ /etc/init.d/oracleasm createdisk DATA2 /dev/sde1rootrac12c1 # /etc/init.d/oracleasm scandisksScanning the system for
21、Oracle ASMLib disks: OK rootrac12c1 # /etc/init.d/oracleasm listdisksCRSDATA1DATA2另外一个节点，扫描共享磁盘。配置用户环境变量：rootrac12c1 # cat /home/grid/.bash_profile# .bash_profile# Get the aliases and functionsif -f /.bashrc ; then. /.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/.local/bi
22、n:$HOME/binexport PATHexport ORACLE_BASE=/u01/app/gridexport ORACLE_HOME=/u01/app/12.1.0/gridexport ORACLE_SID=+ASM1export PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibexport DISPLAY=:0.0uma
23、sk=022alias asmcmd=rlwrap asmcmdrootrac12c1 # cat /home/oracle/.bash_profile# .bash_profile# Get the aliases and functionsif -f /.bashrc ; then. /.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/.local/bin:$HOME/binexport PATHPATH=$PATH:$HOME/binexport ORACLE_BASE=/u01/app/o
24、racleexport ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1export ORACLE_SID=crmdb1export PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibexport DISPLAY=:0.0umask=022export PATHalias sqlplus=rl
25、wrap sqlplusalias rman=rlwrap rman安装 cvuqdisk 软件包rootrac12c1 # rpm -ivh cvuqdisk-1.0.9-1.rpm 开始安装 GRID=安装数据软件=安装数据库。gridrac12c1 rpm$ crsctl stat res -t-Name Target State Server State details -Local Resources-ora.CRS.dgONLINE ONLINE rac12c1 STABLEONLINE ONLINE rac12c2 STABLEora.DATA.dgONLINE ONLINE r
26、ac12c1 STABLEONLINE ONLINE rac12c2 STABLEora.LISTENER.lsnrONLINE ONLINE rac12c1 STABLEONLINE ONLINE rac12c2 STABLEora.asmONLINE ONLINE rac12c1 Started,STABLEONLINE ONLINE rac12c2 Started,STABLEworkONLINE ONLINE rac12c1 STABLEONLINE ONLINE rac12c2 STABLEora.onsONLINE ONLINE rac12c1 STABLEONLINE ONLIN
27、E rac12c2 STABLE-Cluster Resources-ora.LISTENER_SCAN1.lsnr1 ONLINE ONLINE rac12c1 STABLEora.MGMTLSNR1 ONLINE ONLINE rac12c1 169.254.109.218 192.168.30.221,STABLEora.crmdb.db1 ONLINE ONLINE rac12c2 Open,STABLE2 ONLINE ONLINE rac12c1 Open,STABLEora.cvu1 ONLINE ONLINE rac12c1 STABLEora.mgmtdb1 ONLINE O
28、NLINE rac12c1 Open,STABLEora.oc4j1 ONLINE ONLINE rac12c1 STABLEora.rac12c1.vip1 ONLINE ONLINE rac12c1 STABLEora.rac12c2.vip1 ONLINE ONLINE rac12c2 STABLEora.scan1.vip1 ONLINE ONLINE rac12c1 STABLE-oraclerac12c1 $ srvctl status database -d crmdbInstance crmdb1 is running on node rac12c1Instance crmdb
29、2 is running on node rac12c2SQL select a.name,a.open_mode,b.instance_name from gv$database a,gv$instance b where a.inst_id=b.inst_id;NAME OPEN_MODE INSTANCE_NAME- - -CRMDB READ WRITE crmdb1CRMDB READ WRITE crmdb2SQL select * from v$version where rownum=1;BANNER CON_ID- -Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0=end=
