Oracle RAC环境部署文档.docx

1、Oracle RAC环境部署文档中国日报Oracle RAC环境部署文档方正 李守亮 2006-09-15概要：oracle 10g for Sun Solaris 9，采用ASM方式的部署过程。目录一、硬件二、操作系统三、网络配置四、配置系统内核五、配置oracle环境六、共享磁盘分区七、安装oracle cluster八、安装配置ASM+九、配置vipca十、配置ASM（如果增加ASM设备也从该处配置）十一、建库十二、最后检查十三、客户端管理十四、参考一、硬件Sun V490X2，共享阵列，每台2块以上网卡（rac需要两块），接同一交换机二、操作系统1、基本环境SunOS 5.9 + 推荐

2、补丁2、必需包# pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibC SUNWlibm SUNWlibms SUNWsprot SUNWsprox SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfnt3、必需补丁All installations Patches for Solaris 9 (SPARC): Patches for Solaris 9 (SPARC): 112233-11, SunOS 5.9: Kernel Patch 111722-04, SunOS 5.9: Math Library (libm

3、) 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 S1S8CC C compiler 112763-06, Compiler Commo

4、n 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 Linker三、网络配置1、列出系统网卡信息和已经激活的网卡信息 1）列出系统网卡信息# grep network /etc/path_inst 2）激活的网卡信息 # ifconfig a2、激活

5、尚未活动的第二块网卡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.1 db1_pri10.10.10.2 db2_pri192.16

6、8.11.58 db1_vip192.168.11.59 db2_vip# cat /etc/hostname.ce1db1_pri=db2:# cat /etc/hosts#127.0.0.1 localhost192.168.11.61 db2 192.168.11.60 db1 10.10.10.1 db1_pri10.10.10.2 db2_pri192.168.11.58 db1_vip192.168.11.59 db2_vip# cat /etc/hostname.ce1db2_pri注意：1）ce0为公用网卡，ce1为私有网卡，私有网卡不能和公用网卡在同一网段，vip是oracl

7、e rac自动分配，必须和公用网卡在同一网段。2）oracle 的一个bug。如果设置的外网的ip地址是10开始或者172.16-172.31或者192.168开始, oracle将会提示这个错误。解决办法：运行完毕root.sh脚本后，手工运行vipca(需要图形界面)四、配置系统内核db1:# cat /etc/systemset noexec_user_stack=1set semsys:seminfo_semmni=100set semsys:seminfo_semmns=1024set semsys:seminfo_semmsl=256set semsys:seminfo_semvm

8、x=32767set shmsys:shminfo_shmmax=4294967295set shmsys:shminfo_shmmin=1set shmsys:shminfo_shmmni=100set shmsys:shminfo_shmseg=10# sync;sync;reboot=db2:做以上同样的操作。五、配置oracle环境db1:1、创建dba组，oracle用户# groupadd g 100 dba# useradd u 1000 g dba d /oracle m oracle# passwd oracle# su - oracle$ id -auid=1000(ora

9、cle) 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_HOME/bin:/usr/sbin:/usr/bin:/usr/ccs/bin:/usr/openwin/bin:

10、/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 rac通过rcp rsh等进行同步，设置后需测试r操作是否正常。=db2:做以上同样的操作。六、共享磁

11、盘分区说明：由于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 2. c4t50060E80004450A1d0 /p

12、seudo/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 - select (define) a partition ta

13、ble 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 save - save new disk/partition

14、 definitions inquiry - show vendor, product and revision volname - set 8-character volume name ! - execute , then return quitformat pPARTITION MENU: 0 - change 0 partition 1 - change 1 partition 2 - change 2 partition 3 - change 3 partition 4 - change 4 partition 5 - change 5 partition 6 - change 6

15、partition 7 - change 7 partition select - select a predefined table modify - modify a predefined partition table name - name the current table print - display the current table label - write partition map and label to the disk ! - execute , then return quitpartition pCurrent partition table (origina

16、l):Total disk cylinders available: 10920 + 2 (reserved cylinders)Part Tag Flag Cylinders Size Blocks 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 una

17、ssigned wm 12 - 17 112.50MB (6/0/0) 230400 6 usr wm 18 - 23 112.50MB (6/0/0) 230400 7 unassigned wm 24 - 10892 199.02GB (10869/0/0) 417369600db1# init 6db2#init 6注意：1）起始柱面0不要使用；2）slice 5给ocr用3）slice 5给vote用4）slice 7 分配给ASM用。2、设置权限db1:# ls lL /de/rdsk/ dev/rdsk/c4t50060E80004450A1d0*# chown oracle:db

18、a /dev/rdsk/c4t50060E80004450A1d0s5# chown oracle:dba /dev/rdsk/c4t50060E80004450A1d0s6# chown oracle:dba /dev/rdsk/c4t50060E80004450A1d0s7# ls lL /de/rdsk/ dev/rdsk/c4t50060E80004450A1d0*=db2:# ls lL /de/rdsk/ dev/rdsk/c4t50060E80004450A1d0*# chown oracle:dba /dev/rdsk/c4t50060E80004450A1d0s5# chow

19、n oracle:dba /dev/rdsk/c4t50060E80004450A1d0s6# chown oracle:dba /dev/rdsk/c4t50060E80004450A1d0s7# ls lL /de/rdsk/ dev/rdsk/c4t50060E80004450A1d0*七、安装oracle cluster说明：只在一台机器上做，系统会自动同步到另外一台机器上。假设在db1上。1、展开介质# cpio ivcd 10gr2_cluster_sol.cpio2、安装cluster通过xmanger和本地控制台，以oracle用户登陆，进入安装目录，运行$ ./runInst

20、aller1）安装程序欢迎界面:2）指定inventory目录和组:3）指定HOME路径：4）安装要求检查：5）指定Cluster配置：6）增加另一个节点：7）再次检查Cluster配置：8）指定网络接口的使用：9）指定OCR配置：10）指定VOTING配置：11）设定好了所有的信息，准备开始安装：14. 安装进行中：15）执行配置脚本：db1:# /oracle/oraInventory/orainstRoot.shChanging permissions of /oracle/oraInventory to 770.Changing groupname of /oracle/oraInve

21、ntory 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 permissions on OCR backup directorySetting up NS directoriesOracle Cluster Registry configuration upgraded successfullySuccessfully accumula

22、ted necessary OCR keys.Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.node : node 1: db1 db1-priv db1node 2: db1 db2-priv db2Creating OCR keys for user root, privgrp other.Operation successful.Now formatting voting device: /app/oracle/VOTE/c2t4d0s5Format of 1 voting devices complete.Star

23、tup will be queued to init within 30 seconds.Adding daemons to inittabExpecting the CRS daemons to be up within 600 seconds.CSS is active on these nodes. db1CSS is inactive on these nodes. db2Local node checking complete.Run root.sh on remaining nodes to start CRS daemons.=db2:# /oracle/oraInventory

24、/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 permissions on OCR backup directoryS

25、etting up NS directoriesOracle Cluster Registry configuration upgraded successfullyclscfg: EXISTING configuration version 3 detected.clscfg: version 3 is 10G Release 2.Successfully accumulated necessary OCR keys.Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.node : node 1: db1 db1-priv d

26、b1node 2: db2 db2-priv db2clscfg: Arguments check out successfully.NO KEYS WERE WRITTEN. Supply -force parameter to override.-force is destructive and will destroy any previous clusterconfiguration.Oracle Cluster Registry for cluster has already been initializedStartup will be queued to init within

27、30 seconds.Adding daemons to inittabExpecting the CRS daemons to be up within 600 seconds.CSS is active on these nodes. Db1 Db2CSS is active on all nodes.Waiting for the Oracle CRSD and EVMD to startWaiting for the Oracle CRSD and EVMD to startWaiting for the Oracle CRSD and EVMD to startWaiting for

28、 the Oracle CRSD and EVMD to startOracle CRS stack installed and running under init(1M)Running 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 r

29、esource 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