ORACLE 11203 RAC FOR REHL63(64BIT)安裝文檔

1、oracle rac for rehl6.3(64bit)安裝文檔作者：魔心之淚1、安裝環(huán)境22、安裝前系統(tǒng)配置22.1存儲規(guī)劃22.2 ip地址規(guī)劃32.3創(chuàng)建用戶、組(所有節(jié)點)32.4配置各節(jié)點環(huán)境變量42.5關(guān)閉所有節(jié)點防火墻42.6配置ntp服務(wù)(所有節(jié)點)52.7系統(tǒng)參數(shù)設(shè)置52.8存儲分區(qū)52.9 udev綁定裸設(shè)備63、安裝grid74、創(chuàng)建asm磁盤組225、安裝數(shù)據(jù)庫246、建庫291、安裝環(huán)境 rootdb1 # uname -a linux db1 2.6.32-279.el6.x86_64 #1 smp wed jun 13 18:24:36 edt

2、 2012 x86_64 x86_64 x86_64 gnu/linuxrootdb1 # lsb_releaselsbversion: :core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch2、安裝前系統(tǒng)配置2.1存儲規(guī)劃名稱映射裸設(shè)備大小ocr_voting/dev/sdb1/dev/raw/raw11g/dev/sdb2/dev/raw/raw21g/dev/sdb3/dev/raw/raw31gflash_recovery/

3、dev/sdb5/dev/raw/raw45g/dev/sdb6/dev/raw/raw55g/dev/sdb7/dev/raw/raw65gdata/dev/sdc1/dev/raw/raw9536.9g/dev/sdd1/dev/raw/raw10536.9g/dev/sde1/dev/raw/raw11536.9g/dev/sdf1/dev/raw/raw12536.9g/dev/sdg1/dev/raw/raw13536.9g/dev/sdh1/dev/raw/raw14536.9g/dev/sdi1/dev/raw/raw15536.9g/dev/sdj1/dev/raw/raw16

4、536.9g2.2 ip地址規(guī)劃主機名稱db1db2eth0 ip(public)45eth0 ip(vip)01eth1(priv)scan ip2sidpartner1partner2oracle 版本修改所有節(jié)點hosts文件rootdb1 # cat /etc/hosts localhost localhost.localdomain localhost4 localhost4.localdomain

5、435 websv4 db5 db0 db1-vip1 db2-vip db1-priv db2-priv2 rac-scan2.3創(chuàng)建用戶、組(所有節(jié)點)groupadd -g 1000 oinstallgroupadd -g 1200 asmadmingroupadd -g 1201 asmdbagroupadd -g 1202 asmopergroupadd -g 1300 dbagroupadd -g 13

6、01 operuseradd -m -u 1100 -g oinstall -g asmadmin,asmdba,asmoper griduseradd -m -u 1101 -g oinstall -g dba,oper,asmdba oraclemkdir -p /oracle/gridchown -r grid:oinstall /oracle/gridchown -r grid:oinstall /oracle/grid/mkdir -p /oracle/dbchown -r oracle:oinstall /oracle/dbchmod -r 775 /oraclep

7、asswd gridpasswd oracle2.4配置各節(jié)點環(huán)境變量修改grid用戶.bash_profileexport oracle_sid=+asm1#節(jié)點2為+asm2export oracle_base=/oracle/oracle11gexport oracle_home=/oracle/grid/export path=$oracle_home/bin:$path:/usr/local/bin/:.export temp=/tmpexport tmp=/tmpexport tmpdir=/tmpumask 022修改oracle用戶.bash_profileex

8、port oracle_sid=partner1#節(jié)點2為partner2export oracle_unqname=partnerexport oracle_base=/oracle/dbexport oracle_home=/oracle/db/export path=$oracle_home/bin:$path:$ora_crs_home/binexport temp=/tmpexport tmpdir=/tmpumask 0222.5關(guān)閉所有節(jié)點防火墻service iptables status service iptables stop chkconfig ipta

9、bles off chkconfig iptables list設(shè)置/etc/selinux/config 文件，將 selinux 設(shè)置為 disabledrootdb1 # cat /etc/selinux/config# this file controls the state of selinux on the system.# selinux= can take one of these three values:# enforcing - selinux security policy is enforced.# permissive - selinux prints warnin

10、gs instead of enforcing.# disabled - no selinux policy is loaded.selinux=disabled# selinuxtype= can take one of these two values:# targeted - targeted processes are protected,# mls - multi level security protection.selinuxtype=targeted2.6配置ntp服務(wù)(所有節(jié)點)linux客戶端使用ntpdate 14來向ntp服務(wù)器同步自己的時間其它

11、linux如果僅作為只客戶端的話,則不能啟動ntpd服務(wù)!否則無法運行ntpdata 服務(wù)器地址 來同步時間之后可以使用cron或修改crontab文件定期向ntp服務(wù)器更新時間,并用# hwclock -systohc將系統(tǒng)時間設(shè)置為硬件時間rootdb2 # crontab -l*/15 * * * * ntpdate 142.7系統(tǒng)參數(shù)設(shè)置/etc/security/limits.conf文件添加如下內(nèi)容：grid soft nproc 2047 grid hard nproc 16384 grid soft nofile 1024 grid hard nofil

12、e 65536 oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536/etc/pam.d/login添加：session required pam_limits.so2.8存儲分區(qū)所有規(guī)劃的設(shè)備進行分區(qū)，例如在節(jié)點1執(zhí)行：rootdb1 # fdisk /dev/sdewarning: dos-compatible mode is deprecated. its strongly recommended to switch off the mode (com

13、mand c) and change display units to sectors (command u).command (m for help): pdisk /dev/sde: 536.9 gb, 536870912000 bytes255 heads, 63 sectors/track, 65270 cylindersunits = cylinders of 16065 * 512 = 8225280 bytessector size (logical/physical): 512 bytes / 512 bytesi/o size (minimum/optimal): 512 b

14、ytes / 512 bytesdisk identifier: 0x000d60dc device boot start end blocks id systemcommand (m for help): ncommand action e extended p primary partition (1-4)ppartition number (1-4): 1first cylinder (1-65270, default 1): using default value 1last cylinder, +cylinders or +sizek,m,g (1-65270, default 65

15、270): using default value 65270command (m for help): wthe partition table has been altered!calling ioctl() to re-read partition table.syncing disks.所有節(jié)點同步分區(qū)partprobe2.9 udev綁定裸設(shè)備vi /etc/udev/rules.d/60-raw.rules# enter raw device bindings here.# an example would be:# action=add, kernel=sda, run+=/bi

16、n/raw /dev/raw/raw1 %n# to bind /dev/raw/raw1 to /dev/sda, or# action=add, envmajor=8, envminor=1, run+=/bin/raw /dev/raw/raw2 %m %m# to bind /dev/raw/raw2 to the device with major 8, minor 1.#for ocr_votingaction=add,kernel=sdb1,run+=/bin/raw /dev/raw/raw1 %naction=add,kernel=sdb2,run+=/bin/raw /de

17、v/raw/raw2 %naction=add,kernel=sdb3,run+=/bin/raw /dev/raw/raw3 %n#for flash_recoveryaction=add,kernel=sdb5,run+=/bin/raw /dev/raw/raw4 %naction=add,kernel=sdb6,run+=/bin/raw /dev/raw/raw5 %naction=add,kernel=sdb7,run+=/bin/raw /dev/raw/raw6 %n#for dataaction=add,kernel=sdc1,run+=/bin/raw /dev/raw/r

18、aw7 %naction=add,kernel=sdd1,run+=/bin/raw /dev/raw/raw8 %naction=add,kernel=sde1,run+=/bin/raw /dev/raw/raw9 %naction=add,kernel=sdf1,run+=/bin/raw /dev/raw/raw10 %naction=add,kernel=sdg1,run+=/bin/raw /dev/raw/raw11 %naction=add,kernel=sdh1,run+=/bin/raw /dev/raw/raw12 %naction=add,kernel=sdi1,run

19、+=/bin/raw /dev/raw/raw13 %naction=add,kernel=sdj1,run+=/bin/raw /dev/raw/raw14 %nkernel=raw1-9*, owner=grid, group=asmadmin, mode=660重啟 udev： # /sbin/start_udev以上內(nèi)容需要在所有節(jié)點執(zhí)行驗證：rootdb1 rules.d# ll /dev/rawtotal 0crw-rw- 1 grid asmadmin 162, 1 jul 11 15:19 raw1crw-rw- 1 grid asmadmin 162, 10 jul 11 1

20、5:19 raw10crw-rw- 1 grid asmadmin 162, 11 jul 11 15:19 raw11crw-rw- 1 grid asmadmin 162, 12 jul 11 15:19 raw12crw-rw- 1 grid asmadmin 162, 13 jul 11 15:19 raw13crw-rw- 1 grid asmadmin 162, 14 jul 11 15:19 raw14crw-rw- 1 grid asmadmin 162, 2 jul 11 15:19 raw2crw-rw- 1 grid asmadmin 162, 3 jul 11 15:1

21、9 raw3crw-rw- 1 grid asmadmin 162, 4 jul 11 15:19 raw4crw-rw- 1 grid asmadmin 162, 5 jul 11 15:19 raw5crw-rw- 1 grid asmadmin 162, 6 jul 11 15:19 raw6crw-rw- 1 grid asmadmin 162, 7 jul 11 15:19 raw7crw-rw- 1 grid asmadmin 162, 8 jul 11 15:19 raw8crw-rw- 1 grid asmadmin 162, 9 jul 11 15:19 raw9crw-rw

22、- 1 root disk 162, 0 jul 11 15:19 rawctl3、安裝grid節(jié)點1用grid用執(zhí)行：griddb1 grid$ export display=44:0.0griddb1 grid$ export lang=en_us.utf-8griddb1 grid$ ./runi*這里沒有配置dns,使用/etc/hosts文件來解析scan這里可以使用自動配置節(jié)點直接ssh互信，也可手動配置用grid、oracle用戶在所有節(jié)點執(zhí)行ssh-keygen -t dsassh-keygen -t rsacd .sshtouch authorized_

23、keyscat id_rsa.pub authorized_keyscat id_dsa.pub authorized_keys#grid用戶執(zhí)行db1執(zhí)行ssh db2 cat /home/grid/.ssh/id_rsa.pub authorized_keysssh db2 cat /home/grid/.ssh/id_dsa.pub authorized_keysdb2執(zhí)行ssh db1 cat /home/grid/.ssh/id_rsa.pub authorized_keysssh db1 cat /home/grid/.ssh/id_dsa.pub authorized_keys#

24、oracle執(zhí)行db1執(zhí)行ssh db2 cat /home/oracle/.ssh/id_rsa.pub authorized_keysssh db2 cat /home/oracle/.ssh/id_dsa.pub authorized_keysdb2執(zhí)行ssh db1 cat /home/oracle/.ssh/id_rsa.pub authorized_keysssh db1 cat /home/oracle/.ssh/id_dsa.pub authorized_keysgrid、oracle用戶驗證ssh db1 datessh db2 datessh db1-priv datess

25、h db2-priv date如果仍然需要輸入密碼，需檢查相關(guān)目錄權(quán)限chmod 644 authorized_keyschmod 755 /oracle/gridchmod 700 /oracle/grid/.ssh小提示：如果有的設(shè)備沒有顯示，則該設(shè)備可能被使用過，使用dd命令清除：dd if=/dev/zero of=/dev/raw/raw1 bs=10m count=10 grid安裝包中找到cvuqdisk-1.0.9-1.rpm后運行(所有節(jié)點)：rootdb2 rpm# rpm -ivh cvuqdisk-1.0.9-1.rpm preparing. # 100%using d

26、efault group oinstall to install package 1:cvuqdisk # 100%安裝oracleasm,可在官網(wǎng)下載rootdb2 rpm# rpm -ivh oracleasm-support-2.1.8-1.el6.x86_64.rpmwarning: oracleasm-support-2.1.8-1.el6.x86_64.rpm: header v3 rsa/sha256 signature, key id ec551f03: nokeypreparing. # 100% package oracleasm-support-2.1.8-1.el6.x

27、86_64 is already installed使用/etc/hosts解析scan可忽略此錯誤先在節(jié)點1和節(jié)點2執(zhí)行：/oracle/orainventory/orainstroot.sh其次：/oracle/grid//root.sh執(zhí)行結(jié)果：rootdb1 oracle# /oracle/grid//root.shperforming root user operation for oracle 11g the following environment variables are set as: oracle_owner= grid oracle_h

28、ome= /oracle/grid/enter the full pathname of the local bin directory: /usr/local/bin: the contents of dbhome have not changed. no need to overwrite.the contents of oraenv have not changed. no need to overwrite.the contents of coraenv have not changed. no need to overwrite.creating /etc/orata

29、b file.entries will be added to the /etc/oratab file as needed bydatabase configuration assistant when a database is createdfinished running generic part of root script.now product-specific root actions will be performed.using configuration parameter file: /oracle/grid//crs/install/crsconfig

30、_paramscreating trace directoryuser ignored prerequisites during installationolr initialization - successful root wallet root wallet cert root cert export peer wallet profile reader wallet pa wallet peer wallet keys pa wallet keys peer cert request pa cert request peer cert pa cert peer root cert tp

31、 profile 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 certadding clusterware entries to upstartcrs-2672: attempting to start ora.mdnsd on db1crs-2676: start of ora.mdnsd on db1 succeededcrs-2672: atte

32、mpting to start ora.gpnpd on db1crs-2676: start of ora.gpnpd on db1 succeededcrs-2672: attempting to start ora.cssdmonitor on db1crs-2672: attempting to start ora.gipcd on db1crs-2676: start of ora.cssdmonitor on db1 succeededcrs-2676: start of ora.gipcd on db1 succeededcrs-2672: attempting to start

33、 ora.cssd on db1crs-2672: attempting to start ora.diskmon on db1crs-2676: start of ora.diskmon on db1 succeededcrs-2676: start of ora.cssd on db1 succeededasm created and started successfully.disk group ocrvoting created successfully.clscfg: -install mode specifiedsuccessfully accumulated necessary

34、ocr keys.creating ocr keys for user root, privgrp root.operation successful.crs-4256: updating the profilesuccessful addition of voting disk 14bd8fb4dff14f05bf40fca499a9a11f.successful addition of voting disk 25c05e68002f4f6bbf722c09f8c7b068.successful addition of voting disk 0231b788ad924fb3bf7eab8

35、4fd1de9ac.successfully replaced voting disk group with +ocrvoting.crs-4256: updating the profilecrs-4266: voting file(s) successfully replaced# state file universal id file name disk group- - - - - 1. online 14bd8fb4dff14f05bf40fca499a9a11f (/dev/raw/raw1) ocrvoting 2. online 25c05e68002f4f6bbf722c0

36、9f8c7b068 (/dev/raw/raw2) ocrvoting 3. online 0231b788ad924fb3bf7eab84fd1de9ac (/dev/raw/raw3) ocrvotinglocated 3 voting disk(s).crs-2672: attempting to start ora.asm on db1crs-2676: start of ora.asm on db1 succeededcrs-2672: attempting to start ora.ocrvoting.dg on db1crs-2676: start of ora.ocrvotin

37、g.dg on db1 succeededconfigure oracle grid infrastructure for a cluster . succeededrootdb2 rpm# /oracle/orainventory/orainstroot.shchanging permissions of /oracle/orainventory.adding read,write permissions for group.removing read,write,execute permissions for world.changing groupname of /oracle/orai

38、nventory to oinstall.the execution of the script is complete.you have new mail in /var/spool/mail/rootrootdb2 rpm# /oracle/grid//root.shperforming root user operation for oracle 11g the following environment variables are set as: oracle_owner= grid oracle_home= /oracle/grid/enter the

39、 full pathname of the local bin directory: /usr/local/bin: the contents of dbhome have not changed. no need to overwrite.the contents of oraenv have not changed. no need to overwrite.the contents of coraenv have not changed. no need to overwrite.creating /etc/oratab file.entries will be added to the

40、 /etc/oratab file as needed bydatabase configuration assistant when a database is createdfinished running generic part of root script.now product-specific root actions will be performed.using configuration parameter file: /oracle/grid//crs/install/crsconfig_paramscreating trace directoryuser

41、 ignored prerequisites during installationolr initialization - successfuladding clusterware entries to upstartcrs-4402: the css daemon was started in exclusive mode but found an active css daemon on node db1, number 1, and is terminatingan active cluster was found during exclusive startup, restarting to join the clusterconfigure oracle grid infrastructure for a cluster . succeededyou have new mail in /var/spool/mail/root驗證：4、創(chuàng)建asm磁盤組用gird用戶登錄$asmca5、安裝數(shù)據(jù)庫用/etc/hosts解析scan可忽略此錯誤安裝完成后所有節(jié)點執(zhí)行rootdb2 db2# /oracle