1、 环境: Oracle Linux CentOS 6. 4 两台Oracle 11g R2 1、IP规划127.0.0.1 localhost, localdomain localhost #public ip 192. 168. 10.211 racl192. 168. 10. 212 rac2 #priv ip10. 10. 10. 211 raclprv 10. 10. 10. 212 rac2prv #vip ip168. 10.213 raclvip 192.168. 10. 214 rac2vip#scan ip 192. 168. 10. 215 racscan2
2、磁盘规划 +CRS三个2G的盘+DGDATA三个10G的盘 +DGRECOVERY 两个 5G 的盘/usr/sbin/groupadd /usr/sbin/groupadd /usr/sbin/groupadd /usr/sbin/groupadd /usr/sbin/groupadd /usr/sbin/groupadd /usr/sbin/groupadd /usr/sbin/groupadd /usr/sbin/groupadd /usr/sbin/groupadd /usr/sbin/groupadd /usr/sbin/groupadd -g -g 一g -g
3、 -g 501 502 503 504 505 506 oinstall dba oper asmadmin asmoper asmdba /usr/sbin/useradd -g oinstall -G dba, asmdba, oper oracle /usr/sbin/useradd -g oinstall -G asmadmin, asmdba, asmoper, oper,dba grid 使用CVU验证是否满足Oracle集群件要求记住要作为grid用户在将要执行Oracle安装的节点(racnodel)上运行。此 外,必须为grid用户配置通过用户等效性实现
4、的SSH连通性。 在grid软件目录里运行以下命令: ./runcluvfy. sh stage -pre crsinst -n racl, rac2 -fixup -verbose[grid@racl grid]$ . /runcluvfy. sh stage -pre crsinst -n racl, rac2 -fixup -verbose Performing pre-chccks for cluster services setupChecking node reachability... 检查过程省略... 使用CVU验证硬件和操作系统设置./runcluvfy. sh
5、stage -post hwos -n racl, rac2 -verbose [grid@racl grid]S . /runcluvfy. sh stage -post hwos -n racl,rac2 -verbose Performing post-checks for hardware and operating system setup Checking node reachability... 检查过程省略... 6、su - grid ./runinstallerscan配置: cluster scan: sanclustersscanname:racscan s
6、canport:1521/oracle/app/oralnventory/orainstRoot.sh [root@racl soft]# /oracle/app/oralnventory/orainstRoot. shChanging permissions of /oracle/app/oralnventory. Adding read,write permissions for group. Removing read, write, execute permissions for world. Changing groupname of /orac1e/app/ora1nven
7、tory to oinstall. The execution of the script, is complete. [root@rac2 soft]# /orac1e/app/oralnventory/orainstRoot. shChanging permissions of /oracle/app/oralnventory. Adding read, write permissions for group. Removing read, write, execute permissions for world. Changing groupname of /orac1e/ap
8、p/oraInventory to oinstall. The execution of the script, is complete. /oracle/app/grid/product/11. 2. 0/root. sh[root@racl soft]# /oracle/app/oralnventory/orainstRoot.sh Changing permissions of /oracle/app/oralnventory. Adding read,write permissions for group. Removing read, wri te, execute per
9、missions for world. Changing groupname of /oracle/app/oraTnventory to oinstal1. The execution of the script, is complete. [root@racl soft]# /oracle/app/grid/product/11. 2. 0/root. shRunning Oracle 11g root.sh script... The following environment variables are set as: ORACLE.OWNER二 gridORACLEJ1OM
10、E= /oracle/app/grid/product/11. 2. 0 Enter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin Copying oraenv to /usr/local/bin Copying coraenv to /usr/local/binCreating /etc/oratab file... Entries will be added to the /etc/oratab file as needed by D
11、atabase Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. 2010-07-28 16:19:03: Parsing the host name2010-07-28 16:19:03: Checking for super user privileges 2010-07-28 16:19:03: User has super us
12、er privilegesUsing configuration parameter file: /orac1e/app/grid/product/11. 2. 0/crs/instal1/crsconf ig_params Creating trace directory LOCAL ADD MODECreating OCR keys for user 'root', privgrp 'root'.. Operation successful. root wallet root wallet cert root cert export peer wallet profile reader
13、wallet pa wallet peer wallet keys pa wallet keys peer cert request pa cert request peer cert pa cert peer root cert TP profi1e reader root cert TP pa root cert TP peer pa cert TP pa peer cert TP profile reader pa cert TP profile reader peer cert TP peer user cert pa user cert Adding daemon to initt
14、abCRS-4123: Oracle High Availability Services has been started, ohasd is starting CRS-4123: Oracle High Availability Services has been started, ohasd is startingCRS-2672: Attempting to start * ora. gipcd, on 1 racT CRS-2672: Attempting to start ' ora. mdnsd' on 'racl' CRS-2676: Start of ' ora. gipc
15、d' on ,racT succeeded CRS-2676: Start of ' ora. mdnsd' on , racT succeeded CRS-2672: Attempting to start , ora. gpnpd, on 'racl' CRS-2676: Start of ' ora. gpnpd' on , racf succeeded CRS-2672: Attempting to start ' ora. cssdmonitor' on 'racl' CRS-2676: Start of ' ora. cssdmonitor' on , rac1* succeede
16、d CRS-2672: Attempting to start ' ora. cssd' on J racT CRS-2672: Attempting to start J ora. diskmon, on ,racT CRS-2676: Start of * ora.diskmon, on , rac11 succeeded CRS-2676: Start of 'ora.cssd' on 'racl' succeeded CRS-2672: Attempting to start ' ora. ctssd' on 1 racT CRS-2676: Start of 'ora.ctssd'
17、 on 'racl' succeededASM created and started successfully. DiskGroup CRS created successfully. clscfg: -install mode specifiedSuccessfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. CRS-2672: Attempting to start J ora. crsd, on J rac
18、1 ,CRS-2676: Start of J ora.crsd, on 5 rac1J succeeded CRS-4256: Updating the profileSuccessful addition of voting disk a81aaf52b2b74ff5bf7a773e7966ea7c. Successfully replaced voting disk group with +CRS. CRS-4256: Updating the profileCRS-4266: Voting file(s) successfully replaced ## STATE File
19、Universal IdFileName Disk group 1. ONLINE a81aaf52b2b74ff5bf7a773e7966ea7c (ORCL:CRS1) [CRS] Located 1 voting disk(s). CRS-2673: Attempting to stop ' ora. ersd' on 'racl'CRS-2677: Stop of ' ora. ersd' on 'racl' succeeded CRS-2673: Attempting to stop ' ora. asm' on 'racl'CRS-2677: Stop of ' ora. a
20、sm' on 'racl' succeeded CRS-2673: Attempting to stop 1 ora. ctssd* on * racl>CRS-2677: Stop of ' ora. ctssd' on 'racl' succeeded CRS-2673: Attempting to stop J ora. cssdmonitor, on , rac11CRS-2677: Stop of J ora. cssdmonitor5 on 'racl' succeeded CRS-2673: Attempting to stop 'ora. cssd' on 'racl'C
21、RS-2677: Stop of 'ora. cssd' on 'racl' succeeded CRS-2673: Attempting to stop 'ora. gpnpd' on 'racl'CRS-2677: Stop of 'ora. gpnpd' on * rac1 * succeeded CRS-2673: Attempting to stop 'ora. giped' on 'racl'CRS-2677: Stop of ' ora. giped' on 'racl' succeeded CRS-2673: Attempting to stop ' ora. mdnsd
22、' on 'racl'CRS-2677: Stop of ' ora. mdnsd' on , rac1 , succeeded CRS-2672: Attempting to start 'ora. mdnsd' on 'racl'CRS-2676: Start of 'ora.mdnsd' on 'racl' succeeded CRS-2672: Attempting to start J ora. giped* on 'racl'CRS-2676: Start of 'ora. giped' on 'racl' succeeded CRS-2672: Attempting to
23、start * ora. gpnpd, on 'racl'CRS-2676: Start of ' ora. gpnpd' on 'racl' succeeded CRS-2672: Attempting to start , ora. cssdmonitor, on 'racl'CRS-2676: Start of J ora. cssdmonitor, on 'racl' succeeded CRS-2672: Attempting to start ' ora. cssd' on 'racl'CRS-2672: Attempting to start , ora. diskmon,
24、on 'racl' CRS-2676: Start of J ora. diskmon, on * rac1 * succeededCRS-2676: Start of ,ora.cssd, on 'racl' succeeded CRS-2672: Attempting to start * ora. ctssd, on ) rac1* CRS-2676: Start of ' ora. ctssd' on 5 rac11 succeeded CRS-2672: Attempting to start , ora. asm on 'racl' CRS-2676: Start of ' o
25、ra. asm' on 'racl' succeededAttempting to start Start of ' ora. crsdJ Attempting to start Start of ' ora. evmd, Attempting to start Start of ' ora. asm, Attempting to start Start of ' ora. crsdJ Attempting to start Start of ' ora. evmd, Attempting to start Start of ' ora. asm, CRS-2672: CRS-267
26、6: CRS-2672: CRS-2676: CRS-2672: CRS-2676: CRS-2672: CRS-2676: CRS-2672: CRS-2676: , ora. ersd, on 'racl' on 'racl' succeeded , ora. evmd, on 'racl' on 'racl' succeeded 'ora. asm' on 'racl' on * rac1* succeededAttempting to start ' ora. CRS. dg' on 'racl' Start of ' ora. CRS. dg' on * rac1
27、 succeeded Attempting to start * ora. registry, acfs5 on 'racl' Start of ? ora. registry, acfs, on 'racl' succeededracl2010/07/28 16:31:27/oracle/app/grid/product/11.2. 0/cdata/racl/backup 20100728_163127. olr Configure Oracle Grid Infrastructure for a Cluster … succeeded Updating inventory prope
28、rties for clusterware Starting Oracle Universal Installer... Checking swap space: must be greater than 500 MB. Actual 971MB Passed The inventory pointer is located at /etc/oralnst. locThe inventory is located at /orac1e/app/oralnventory J UpdateNodeList, was successful. [root@rac2 soft]# /oracle/
29、app/grid/product/11. 2. 0/root. shRunning Oracle 11g root.sh script... The following environment variables are set as: ORACLE_OWNER= gridORACLE_HOME= /oracle/app/grid/product/11. 2. 0 Enter the full pathname of the local bin directory: [/usr/local/bin]: The file 〃dbhome〃 already exists in /usr/lo
30、cal/bin. Overwrite it? (y/n) [n]: y Copying dbhome to /usr/local/binThe file ,oraenv“ already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying oraenv to /usr/local/binThe file "coracnv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying coraenv to /usr/local/binEntr
31、ies will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is createdFinished running generic part of root, sh script. Now product-specific root actions wi11 be performed. 2010-08-02 14:32:28: Parsing the host name2010-08-02 14:32:28: Checking for supe
32、r user privileges 2010-08-02 14:32:28: User has super user privilegesUsing configuration parameter file: /oracle/app/grid/product/11. 2. 0/crs/instai1/crsconf i g paramsCreating trace directory I.OCAL ADD MODECreating OCR keys for user 'root', privgrp ' root'.. Operation successful. Adding daem
33、on to inittabCRS-4123: Oracle High Availability Services has been started, ohasd is starting CRS-4402: The CSS daemon was started in exclusive mode but found an activeCSS daemon on node racl, number 1, and is terminating An active cluster was found during exclusive startup, restarting to join the
34、clusterCRS-2672: Attempting to start 'ora. mdnsd' on 'rac2' CRS-2676: Start of ' ora. mdnsd' on * rac2, succeededCRS-2672: Attempting to start 'ora. giped' on 'rac2' CRS-2676: Start of ' ora. giped' on 'rac2' succeededCRS-2672: Attempting to start 'ora. gpnpd' on ' rac2' CRS-2676: Start of ' ora.
35、 gpnpd' on 'rac2' succeededCRS-2672: Attempting to start * ora. cssdmonitor, on ' rac2' CRS-2676: Start of J ora. cssdmonitor, on ' rac2' succeededCRS-2672: Attempting to start J ora. cssd, on ' rac2' CRS-2672: Attempting to start J ora. diskmon, on ' rac2'CRS-2676: Start of 'ora. diskmon' on 'rac
36、2' succeeded CRS-2676: Start of ,ora.cssd, on ' rac2' succeededCRS-2672: Attempting to start * ora. ctssd, on ' rac2' CRS-2676: Start of 'ora.ctssd' on 'rac2' succeededCRS-2672: Attempting to start * ora. drivers. acfs, on ,rac2, CRS-2676: Start of , ora. drivers. acfs, on ' rac2' succeededCRS-26
37、72: Attempting to start ' ora. asm' on 'rac2' CRS-2676: Start of ' ora. asm' on ' rac2' succeededCRS-2672: Attempting to start 'ora. crsd' on * rac2* CRS-2676: Start of 'ora.crsd' on 'rac2' succeededCRS-2672: Attempting to start ' ora. evmd' on 'rac2' CRS-2676: Start of * ora. evmd, on * rac2, su
38、cceededrac22010/08/02 14:37:51/oracle/app/grid/product/11. 2. 0/cdata/rac2/backup_20100802 143751.olr Configure Oracle Grid Infrastructure for a Cluster … succeeded Updating inventory properties for clusterware Starting Oracle Universal Installer... Checking swap space: must be greater than 500 M
39、B. Actual 1202MB Passed The inventory pointer is located at /etc/oralnst. loc The inventory is located at /oracle/app/oralnventory 'UpdatcNodcList' was successful. [grid@rac2 ]$ srvctl enable oc4jPRKO-2116 : 0C4J is already enabled [grid@rac2 ~]$ srvctl start oc4j[grid@rac2 [$ srvctl enable nodea
40、pps PRKO-2415 : VIP is already enabled on node(s): racl, rac2PRKO-2416 : Network resource is already enabled. PRKO-2417 : ONS is already enabled on node (s): racl, rac2PRKO-2418 : eONS is already enabled [grid@rac2 、]$ crs_stat -t NameType Host PRKO-2418 : eONS is already enabled [grid@rac2
41、 、]$ crs_stat -t NameType Host on node(s): racl, rac2 Target State ora. CRS. dgora.... up. type ONLINEONLINEracl ora.... ER. Isnr ora.... er. type ONLINEONLINEracl ora.... Nl. Isnr ora.... er. type ONLINEONLINEracl ora. asmora. asm. type ora. cons ora. cons, type ora. gsd ora. gsd. type
42、 ora. CRS. dgora.... up. type ONLINEONLINEracl ora.... ER. Isnr ora.... er. type ONLINEONLINEracl ora.... Nl. Isnr ora.... er. type ONLINEONLINEracl ora. asmora. asm. type ora. cons ora. cons, type ora. gsd ora. gsd. type ora.... network ora.... rk. type ONLINEONLINEracl ONLINE ONL
43、INE racl ONLINEONLINEracl ONLINE ONLINE racl ora. oc4jora. oc4j. type ONLINE ONLINE rac2ora. onsora. ons. type ONLINE ONLINE racl ora.... SMI. asm application ONLINE ONLINE racl ora.... Cl. Isnr application ONLINE ONLINE racl ora. racl. gsd application ONLINE ONLINE rac
44、l ora. racl. ons application ONLINE ONLINE racl ora. racl. vip ora.... tl. type ONLINE ONLINE racl ora.... SM2, asm application ora.... C2. Isnr application ora. rac2. gsd ONLINE ONLINE application ONLINE ONLINE ONLINE rac2 rac2 ONLINE rac2 ora. rac2. ons application ONLINE ONLI
45、NE rac2 ora. rac2. vipora.... tl. type ONLINEONLINErac2 ora.... ry. acfs ora….fs. type ONLINEONLINEracl ora. scanl. vip ora.... ip. type ONLINE ONLINE racl 6、su - grid ./runinstaller scan配置: cluster scan: sanclustersscanname:racscan scanport:1521/oracle/app/oralnventory/orainstRoot. sh [
46、root@racl soft]# /oracle/app/oralnventory/orainstRoot.sh Changing permissions of /oracle/app/oralnventory. Adding read, write permissions for group. Removing read, write, execute permissions for world. Changing groupname of /oracle/app/oralnventory to oinstall. The execution of the script, is co
47、mplete. [root@rac2 soft]# /oracle/app/oralnventory/orainstRoot. shChanging permissions of /oracle/app/oralnventory. Adding read,write permissions for group. Removing read, write, execute permissions for world. Changing groupname of /orac1e/app/oraInventory to oinstall. The execution of the scri
48、pt, is complete. /orac1e/app/gri d/product/11. 2.0/root.sh[root@racl soft]# /oracle/app/oraTnventory/orainstRoot. sh Changing permissions of /oracle/app/oralnventory. Adding read,write permissions for group. Removing read, write, execute permissions for world. Changing groupname of /orac1e/app/
49、ora1nventory to oinstall. The execution of the script, is complete. [root@racl soft]# /oracle/app/grid/product/11. 2. 0/root. shRunning Oracle 11g root, sh script... The following environment variables are set as: ORACLE_OWNER= gridORACLE HOME=/oracle/app/grid/product/11. 2. 0 Enter the full pa
50、thname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin Copying oraenv to /usr/local/bin Copying coraenv to /usr/local/binCreating /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is crea






