Oracle RAC环境部署文档Word文档下载推荐.docx

1、111722-04, SunOS 5.9: Math Library （libm） patch 4、特殊补丁（不必需）PL/SQL native compilation, Pro*C/C+, Oracle Call Interface, Oracle C+ Call Interface, Oracle XML Developers Kit （XDK） :Patches for Solaris 8 and Solaris 9 （SPARC）:112758-02, dbx 7.1: Patch for S1S8CC Debugger 112760-05, C 5.5: Patch for S1S8

2、CC C compiler 112763-06, Compiler Common S1S8CC: Patch for S1S8CC C C+ F77 F95 113817-03, C+ 5.5: Patch for S1S8CC C+ compiler 113820-02, Compiler Common 7.1: Patch for S1S8CC Math Libraries 113823-03, ILD 4.1: Patch for S1S8CC Incremental Linker1、列出系统网卡信息和已经激活的网卡信息 1）列出系统网卡信息# grep network /etc/pat

3、h_inst 2）激活的网卡信息 # ifconfig a2、激活尚未活动的第二块网卡db1: # ifconfig ce1 plumb # ifconfig ce1 inet 10.10.10.1 netmask 255.255.255.0 up=db2:# ifconfig ce1 plumb # ifconfig ce1 inet 10.10.10.2 netmask 255.255.255.0 up3、配置网络参数文件db1：# cat /etc/hosts#127.0.0.1 localhost192.168.11.61 db2 192.168.11.60 db1 10.10.10.

4、1 db1_pri10.10.10.2 db2_pri192.168.11.58 db1_vip192.168.11.59 db2_vip# cat /etc/hostname.ce1db1_pri=db2_pri注意：1）ce0为公用网卡，ce1为私有网卡，私有网卡不能和公用网卡在同一网段，vip是oracle rac自动分配，必须和公用网卡在同一网段。2）oracle 的一个bug。如果设置的外网的ip地址是10开始或者172.16-172.31或者192.168开始, oracle将会提示这个错误。解决办法：运行完毕root.sh脚本后，手工运行vipca（需要图形界面）# cat /e

5、tc/systemset noexec_user_stack=1set semsys:seminfo_semmni=100seminfo_semmns=1024seminfo_semmsl=256seminfo_semvmx=32767set shmsys:shminfo_shmmax=4294967295shminfo_shmmin=1shminfo_shmmni=100shminfo_shmseg=10# sync;sync;reboot做以上同样的操作。1、创建dba组，oracle用户# groupadd g 100 dba# useradd u 1000 g dba d /oracl

6、e m oracle# passwd oracle# su - oracle$ id -auid=1000（oracle） gid=100（dba） groups=100（dba）说明：因为做rac，两台机器需指定同样的uid和gid2、配置环境参数$ cat .profileumask 022ORACLE_BASE=/oracleexport ORACLE_BASEORACLE_HOME=$ORACLE_BASE/app/oracle/product/10.2.0export ORACLE_HOMEORACLE_SID=cddb1export ORACLE_SIDPATH=$ORACLE_H

7、OME/bin:/usr/sbin:/usr/bin:/usr/ccs/bin:/usr/openwin/bin:/usr/dt/bin:/usr/platform/SUNW,Sun-Fire-V490/sbin:/opt/sun/bin:/opt/SUNWexplo/bin:/opt/SUNWsneep/bin:/opt/CTEact/binexport PATH公用的ORACLE_SID为cddb，而rac的每一台的单独ORACLE_SID分别为cddb1和cddb2，后面的数字在dbca建库时程序自动加上，而配置文件里需手工添加。$ cat .rhosts+用于安装和运行中oracle

8、rac通过rcp rsh等进行同步，设置后需测试r操作是否正常。=由于c4t50060E80004450A1d0, c4t50060E80004450A1d1是共享磁盘，所以只在一台上做就可，做完重启，同步磁盘初始化。Db1:1、分区# formatSearching for disks.doneAVAILABLE DISK SELECTIONS: 0. c1t0d0 /pci9,600000/SUNW,qlc2/fp0,0/ssdw21000000878f8ed4,0 1. c1t1d0 /pci9,600000/SUNW,qlc2/fp0,0/ssdw21000000878fc6db,0

9、2. c4t50060E80004450A1d0 /pseudo/dlmndrv1/dlmfdrvw50060e80004450a1,0 3. c4t50060E80004450A1d1 /pseudo/dlmndrv1/dlmfdrvw50060e80004450a1,1Specify disk （enter its number）: 2selecting c4t50060E80004450A1d0disk formattedFORMAT MENU: disk - select a disk type - select （define） a disk type partition - sel

10、ect （define） a partition table current - describe the current disk format - format and analyze the disk repair - repair a defective sector label - write label to the disk analyze - surface analysis defect - defect list management backup - search for backup labels verify - read and display labels sav

11、e - save new disk/partition definitions inquiry - show vendor, product and revision volname - set 8-character volume name ! - execute pPARTITION MENU: 0 - change 0 partition 1 - change 1 2 - change 2 3 - change 3 4 - change 4 5 - change 5 6 - change 6 7 - change 7 select - select a predefined table

12、modify - modify a predefined partition table name - name the current table print - display the current table label - write partition map and label to the diskpartitionCurrent partition table （original）:Total disk cylinders available: 10920 + 2 （reserved cylinders）Part Tag Flag Cylinders Size Blocks

13、0 root wm 0 - 5 112.50MB （6/0/0） 230400 1 swap wu 6 - 11 112.50MB （6/0/0） 230400 2 backup wu 0 - 10919 199.95GB （10920/0/0） 419328000 3 unassigned wm 0 0 （0/0/0） 0 4 unassigned wm 0 0 （0/0/0） 0 5 unassigned wm 12 - 17 112.50MB （6/0/0） 230400 6 usr wm 18 - 23 112.50MB （6/0/0） 230400 7 unassigned wm 2

14、4 - 10892 199.02GB （10869/0/0） 417369600db1# init 6db2#init 61）起始柱面0不要使用；2）slice 5给ocr用3）slice 5给vote用4）slice 7 分配给ASM用。2、设置权限# ls lL /de/rdsk/ dev/rdsk/c4t50060E80004450A1d0*# chown oracle:dba /dev/rdsk/c4t50060E80004450A1d0s5dba /dev/rdsk/c4t50060E80004450A1d0s6dba /dev/rdsk/c4t50060E80004450A1d0s

15、7=只在一台机器上做，系统会自动同步到另外一台机器上。假设在db1上。1、展开介质# cpio ivcd 10gr2_cluster_sol.cpio2、安装cluster通过xmanger和本地控制台，以oracle用户登陆，进入安装目录，运行$ ./runInstaller1）安装程序欢迎界面:2）指定inventory目录和组:3）指定HOME路径：4）安装要求检查：5）指定Cluster配置：6）增加另一个节点：7）再次检查Cluster配置：8）指定网络接口的使用：9）指定OCR配置：10）指定VOTING配置：11）设定好了所有的信息，准备开始安装：14. 安装进行中：15）执行配

16、置脚本：# /oracle/oraInventory/orainstRoot.shChanging permissions of /oracle/oraInventory to 770.Changing groupname of /oracle/oraInventory to dba.The execution of the script is complete#/oracle/app/oracle/product/crs/root.shChecking to see if Oracle CRS stack is already configuredSetting the permission

17、s on OCR backup directorySetting up NS directoriesOracle Cluster Registry configuration upgraded successfullySuccessfully accumulated necessary OCR keys.Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.node : private interconnect namehostnamenode 1: db1 db1-priv db1node 2: db1 db2-priv db2

18、Creating OCR keys for user root, privgrp other.Operation successful.Now formatting voting device: /app/oracle/VOTE/c2t4d0s5Format of 1 voting devices complete.Startup will be queued to init within 30 seconds.Adding daemons to inittabExpecting the CRS daemons to be up within 600 seconds.CSS is active

19、 on these nodes. db1CSS is inactive on these nodes. db2Local node checking complete.Run root.sh on remaining nodes to start CRS daemons.=clscfg: EXISTING configuration version 3 detected. version 3 is 10G Release 2. db2 db2-priv db2 Arguments check out successfully.NO KEYS WERE WRITTEN. Supply -forc

20、e parameter to override.-force is destructive and will destroy any previous clusterconfiguration.Oracle Cluster Registry for cluster has already been initialized Db1 Db2CSS is active on all nodes.Waiting for the Oracle CRSD and EVMD to startOracle CRS stack installed and running under init（1M）Runnin

21、g vipca（silent） for configuring nodeappsCreating VIP application resource on （2） nodes.Creating GSD application resource on （2） nodes.Creating ONS application resource on （2） nodes.Starting VIP application resource on （2） nodes.Starting GSD application resource on （2） nodes.Starting ONS application resource on （2） nodes.如果不是第一次安装，将受到历史配置的影响。#mv /etc/init.d/init.c* /#mv /var/opt/oracle /var/opt/oracle.init#ps ef|grep css#ps ef|grep crs#kill 9 pid# ps -ef|grep crsoracle 17601 27479 0 15:43:38 pts/1 0:00 grep crsoracle 946 945 0 Sep 12 ? 1:08 /oracle/a