[計(jì)算機(jī)軟件及應(yīng)用]installer-oracle-11gr2-rac-for-HP-unix

1、.oracle rac for hpnuix電信集成安裝配置手冊(cè)1. 安裝前介紹：平臺(tái)：兩臺(tái) HP RX9800型號(hào)小機(jī)，系統(tǒng)：HP-UX B.11.31 系統(tǒng)，24個(gè)1.6GHz CPU， 256GB內(nèi)存磁盤陣列: HP P6500 安裝數(shù)據(jù)庫軟件：2. 環(huán)境規(guī)劃：服務(wù)器IP主機(jī)名屬性型號(hào)ORA-RAC11ora-rac1PublicHPUX 11.313ora-rac1-vipVip1ora-rac1-privPrivateORA-RAC22ora-rac2PublicHPUX 11.311

2、4ora-rac2-vipVip2ora-rac2-privPrivate5scan-clusterScan3. 存儲(chǔ)規(guī)劃數(shù)據(jù)庫磁盤陣列劃分ASM磁盤組名稱對(duì)應(yīng)的vDisk名Size冗余方式SIZE說明OCRVD01_OCR5GB外部5GBOracle RAC OCR盤DATAVD02_DBFVD03_DBFVD04_DBFVD05_DBFVD06_DBF500GB500GB500GB500GB500GB外部2.5TB建立應(yīng)用數(shù)據(jù)表空間數(shù)據(jù)文件Redo日志文件控制文件FRAVD07_DBFVD08_DBFVD09_DBFVD010_DB

3、FVD011_DBF500GB500GB500GB500GB500GB外部2.5TB建立備份數(shù)據(jù)文件Redo日志文件控制文件歸檔日志文件4. 安裝前的準(zhǔn)備工作4.1 補(bǔ)丁和軟件列表如下： PHCO_40381 11.31 Disk Owner PatchPHKL_38038 vm cumulative patchPHKL_38938 11.31 SCSI cumulative I/O patchPHKL_39351 Scheduler patch : post wait hangPHSS_36354 11.31 assembler patchPHSS_37042 11.31 hppac (pa

4、cked decimal)PHSS_37959 Libcl patch for alternate stack issue fix (QXCR1000818011)PHSS_39094 11.31 linker + fdp cumulative patchPHSS_39100 11.31 Math Library Cumulative PatchPHSS_39102 11.31 Integrity Unwind LibraryPHSS_38141 11.31 aC+ Runtime還有一個(gè) ssh 包 和 bash 包 最好都能打上。4.2內(nèi)核參數(shù)設(shè)置kctune -h -B maxssiz=

5、"134217728" kctune -h -B maxssiz_64bit="1073741824" kctune -h -B maxuprc="3688" kctune -h -B msgmni="4096" kctune -h -B msgtql="4096" kctune -h -B ncsize="35840" kctune -h -B ninode="34816" kctune -h -B semmni="4096" kct

6、une -h -B semmns="16384" kctune -h -B semmnu="4092" kctune -h -B shmmax="34359738368" kctune -h -B shmmni="512" kctune -h -B vps_ceiling="64" kctune -h -B nproc="4096" kctune -h -B maxfiles_lim="63488" kctune -h -B shmmni="40

7、96" kctune -h -B shmseg="512"kctune -h -B tcp_smallest_anon_port="9000"kctune -h -B tcp_largest_anon_port="65500"kctune -h -B udp_smallest_anon_port="9000"kctune -h -B udp_largest_anon_port="65500"執(zhí)行完上述命令后一定要重啟，不要和更新補(bǔ)丁后在重啟。4.3連接lib 文件cd /usr/lib

8、 ls libX*.sl ln -s libX11.3 libX11.sl ln -s libXIE.2 libXIE.sl ln -s libXext.3 libXext.sl ln -s libXhp11.3 libXhp11.sl ln -s libXi.3 libXi.sl ln -s libXm.4 libXm.sl ln -s libXp.2 libXp.sl ln -s libXt.3 libXt.sl ln -s libXtst.2 libXtst.sl4.4禁用ntp (前提是沒有NTP 服務(wù)的情況下)# mv /etc/ntp.conf/etc/ntp.conf.bak4.

9、4.1調(diào)整兩個(gè)服務(wù)器時(shí)間一致# date 032620131533004.5設(shè)置/etc/hosts文件 文件內(nèi)容與2節(jié)內(nèi)容匹配 localhost loopback# for oracle# public1 ora-rac12 ora-rac2# vip3 ora-rac1-vip4 ora-rac2-vip# private1 ora-rac1-priv2 ora-rac2-priv# scan5 scan-cluster4.6初

10、始化用戶以及組#groupadd oinstall#groupadd dba#useradd -g oinstall -G dba -d /home/oracle -m oracle#useradd -g oinstall -G dba -d /home/grid -m grid#passwd oracleChanging password for oracleNew password:(oracle)Re-enter new password:(oracle)Passwd successfully changed#passwd gridChanging password for oracle

11、New password:(grid)Re-enter new password:(grid)Passwd successfully changedmkdir -p /u01/app/gridchmod -R 777 /u01/app/gridchown -R grid:oinstall /u01/app/gridmkdir -p /u01/app/oraclechmod -R 777 /u01/app/oraclechown -R oracle:oinstall /u01/app/oracle4.7共享磁盤檢查在節(jié)點(diǎn)1:ora-rac1#/u01/oracle_11gr2cd /dev/rd

12、iskora-rac1#/dev/rdiskls -lrttotal 0crw-r- 1 bin sys 13 0x000001 Feb 6 13:26 disk1crw-r- 1 bin sys 13 0x000003 Feb 6 13:26 disk1_p1crw-r- 1 bin sys 13 0x000005 Feb 6 13:26 disk1_p3crw-r- 1 bin sys 13 0x00001d Mar 22 16:12 disk29crw-r- 1 bin sys 13 0x00001c Mar 22 16:12 disk28crw-r- 1 bin sys 13 0x00

13、001a Mar 22 16:12 disk26crw-r- 1 bin sys 13 0x00001b Mar 22 16:12 disk27crw-r- 1 bin sys 13 0x000019 Mar 22 16:12 disk25crw-r- 1 bin sys 13 0x000018 Mar 22 16:12 disk24crw-r- 1 bin sys 13 0x000022 Mar 22 16:12 disk34crw-r- 1 bin sys 13 0x000021 Mar 22 16:12 disk33crw-r- 1 bin sys 13 0x000020 Mar 22

14、16:12 disk32crw-r- 1 bin sys 13 0x00001f Mar 22 16:12 disk31crw-r- 1 bin sys 13 0x00001e Mar 22 16:12 disk30crw-r- 1 bin sys 13 0x000023 Mar 25 16:52 disk58crw-r- 1 bin sys 13 0x000004 Mar 25 17:23 disk1_p2確定給oracle 使用的磁盤分別是: disk24 - disk34ora-rac1#/dev/rdiskdiskinfo disk29SCSI describe of disk29:

15、vendor: HP product id: HSV360 type: direct access size: 5242880 Kbytes bytes per sector: 512ora-rac1#/dev/rdisk確定這個(gè)磁盤是 5G 的 , 這個(gè)磁盤做OCR 磁盤組ora-rac1#/dev/rdiskmknod /dev/rdisk/VD01_OCR c 13 0x00001dora-rac1#/dev/rdiskmknod /dev/rdisk/VD02_DBF c 13 0x00001cora-rac1#/dev/rdiskmknod /dev/rdisk/VD03_DBF c

16、 13 0x00001aora-rac1#/dev/rdiskmknod /dev/rdisk/VD04_DBF c 13 0x00001bora-rac1#/dev/rdiskmknod /dev/rdisk/VD05_DBF c 13 0x000019ora-rac1#/dev/rdiskmknod /dev/rdisk/VD06_DBF c 13 0x000018ora-rac1#/dev/rdiskmknod /dev/rdisk/VD07_DBF c 13 0x000022ora-rac1#/dev/rdiskmknod /dev/rdisk/VD08_DBF c 13 0x0000

17、21ora-rac1#/dev/rdiskmknod /dev/rdisk/VD09_DBF c 13 0x000020ora-rac1#/dev/rdiskmknod /dev/rdisk/VD010_DBF c 13 0x00001fora-rac1#/dev/rdiskmknod /dev/rdisk/VD011_DBF c 13 0x00001e在節(jié)點(diǎn)2:ora-rac2#/dev/rdiskls -lrttotal 0crw-r- 1 bin sys 13 0x000001 Feb 7 14:15 disk1crw-r- 1 bin sys 13 0x000003 Feb 7 14:

18、15 disk1_p1crw-r- 1 bin sys 13 0x000005 Feb 7 14:15 disk1_p3crw-r- 1 bin sys 13 0x000022 Mar 22 16:15 disk56crw-r- 1 bin sys 13 0x000021 Mar 22 16:15 disk55crw-r- 1 bin sys 13 0x000020 Mar 22 16:15 disk54crw-r- 1 bin sys 13 0x00001f Mar 22 16:15 disk53crw-r- 1 bin sys 13 0x00001e Mar 22 16:15 disk52

19、crw-r- 1 bin sys 13 0x00001b Mar 22 16:15 disk49crw-r- 1 bin sys 13 0x00001d Mar 22 16:15 disk51crw-r- 1 bin sys 13 0x00001c Mar 22 16:15 disk50crw-r- 1 bin sys 13 0x00001a Mar 22 16:15 disk48crw-r- 1 bin sys 13 0x000019 Mar 22 16:15 disk47crw-r- 1 bin sys 13 0x000018 Mar 22 16:15 disk46crw-r- 1 bin

20、 sys 13 0x000023 Mar 25 16:08 disk58crw-r- 1 bin sys 13 0x000004 Mar 25 16:08 disk1_p2確定給 oracle 使用的磁盤是：disk46 - disk56ora-rac2#/diskinfo /dev/rdisk/disk51SCSI describe of /dev/rdisk/disk51: vendor: HP product id: HSV360 type: direct access size: 5242880 Kbytes bytes per sector: 512ora-rac2#/確定這個(gè)磁盤是

21、 5G 的 , 這個(gè)磁盤做OCR 磁盤組ora-rac2#/dev/rdiskmknod /dev/rdisk/VD01_OCR c 13 0x00001dora-rac2#/dev/rdiskmknod /dev/rdisk/VD02_DBF c 13 0x00001cora-rac2#/dev/rdiskmknod /dev/rdisk/VD03_DBF c 13 0x00001aora-rac2#/dev/rdiskmknod /dev/rdisk/VD04_DBF c 13 0x00001bora-rac2#/dev/rdiskmknod /dev/rdisk/VD05_DBF c 1

22、3 0x000019ora-rac2#/dev/rdiskmknod /dev/rdisk/VD06_DBF c 13 0x000018ora-rac2#/dev/rdiskmknod /dev/rdisk/VD07_DBF c 13 0x000022ora-rac2#/dev/rdiskmknod /dev/rdisk/VD08_DBF c 13 0x000021ora-rac2#/dev/rdiskmknod /dev/rdisk/VD09_DBF c 13 0x000020ora-rac2#/dev/rdiskmknod /dev/rdisk/VD010_DBF c 13 0x00001

23、fora-rac2#/dev/rdiskmknod /dev/rdisk/VD011_DBF c 13 0x00001e4.8檢查異步IO兩個(gè)節(jié)點(diǎn)都需要設(shè)置，不然檢查過不去。#/ll /dev/async crw-rw-rw- 1 bin bin 101 0x000000 Aug 28 10:42 /dev/async需要設(shè)置 #/rm /dev/async #/ /sbin/mknod /dev/async c 101 0x4 #/chmod 666 /dev/async #/ll /dev/async crw-rw-rw- 1 root sys 101 0x000004 Aug 28 14

24、:14 /dev/async4.9設(shè)置環(huán)境變量：su - grid$ vi .profile添加如下行:export ORACLE_BASE=/u01/app/grid/baseexport ORACLE_HOME=/u01/app/grid/11.2.0export ORACLE_SID=+ASM1export ORACLE_UNQNAME=orclexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport ORACLE_HOSTNAME=ora-rac1export PATH=$ORACLE_HOME/bin:.:$PATHumask 022su - o

25、racle$ file添加如下行：export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1export ORACLE_SID= orcl1export ORACLE_UNQNAME=orclexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport ORACLE_HOSTNAME=ora-rac1export PATH=$ORACLE_HOME/bin:.:$PATHumask 0224.10配置ssh 互信關(guān)系：1).

26、在主節(jié)點(diǎn)ora-rac1上以grid用戶身份生成用戶的公匙和私匙# ping ora-rac2# ping ora-rac2-priv# su grid$ mkdir /.ssh$ ssh-keygen -t rsa$ ssh-keygen -t dsa2).在副節(jié)點(diǎn)ora-rac2上執(zhí)行相同的操作，確保通信無阻# ping ora-rac1# ping ora-rac1-pri# su grid$ mkdir /.ssh$ ssh-keygen -t rsa$ ssh-keygen -t dsa3).在主節(jié)點(diǎn)ora-rac1上grid用戶執(zhí)行以下操作$ cat /.ssh/id_rsa.pu

27、b >> ./.ssh/authorized_keys$ cat /.ssh/id_dsa.pub >> ./.ssh/authorized_keys$ ssh ora-rac2 cat /.ssh/id_rsa.pub >> /.ssh/authorized_keys$ ssh ora-rac2 cat /.ssh/id_dsa.pub >> /.ssh/authorized_keys$ scp /.ssh/authorized_keys ora-rac2:/.ssh/authorized_keys5.安裝前的檢查：$ cd /soft/ora

28、cle/grid$ lsdoc install readme.html response rpm runInstaller runcluvfy.sh sshsetup stage welcome.html$ ./runcluvfy.sh stage -pre crsinst -n ora-rac1,ora-rac2 -verbosePerforming pre-checks for cluster services setup Checking node reachability.Check: Node reachability from node "ora-rac1" D

29、estination Node Reachable? - - ora-rac1 yes ora-rac2 yes Result: Node reachability check passed from node "ora-rac1"Checking user equivalence.Check: User equivalence for user "grid" Node Name Status - - ora-rac2 passed ora-rac1 passed Result: User equivalence check passed for use

30、r "grid"Checking node connectivity.Checking hosts config file. Node Name Status - - ora-rac2 passed ora-rac1 passed Verification of the hosts config file successfulInterface information for node "ora-rac2" Name IP Address Subnet Gateway Def. Gateway HW Address MTU - - - - - - - l

31、an901 2 2 254 D8:9D:67:C5:1F:B8 1500 lan900 2 2 254 D8:9D:67:C5:1F:C0 1500 Interface information for node "ora-rac1" Name IP Address Subnet Gateway Def. Gateway HW Address MTU - - - - - - - lan901 1 10

32、.0.0.0 1 254 D8:9D:67:C5:24:80 1500 lan900 1 1 254 D8:9D:67:C5:24:88 1500 Check: Node connectivity of subnet "" Source Destination Connected? - - - ora-rac2 ora-rac1 yes Result: Node connectivity pass

33、ed for subnet "" with node(s) ora-rac2,ora-rac1Check: TCP connectivity of subnet "" Source Destination Connected? - - - ora-rac1:1 ora-rac2:2 passed Result: TCP connectivity check passed for subnet ""Check: Node connectivity of su

34、bnet "" Source Destination Connected? - - - ora-rac22 ora-rac11 yes Result: Node connectivity passed for subnet "" with node(s) ora-rac2,ora-rac1Check: TCP connectivity of subnet "" Source Destination Connected? - -

35、 - ora-rac1:1 ora-rac2:2 passed Result: TCP connectivity check passed for subnet ""Interfaces found on subnet "" that are likely candidates for VIP are:ora-rac2 lan900:2ora-rac1 lan900:1Interfaces found on subnet &

36、quot;" that are likely candidates for a private interconnect are:ora-rac2 lan901:2ora-rac1 lan901:1Checking subnet mask consistency.Subnet mask consistency check passed for subnet "".Subnet mask consistency check passed for subnet ""

37、;.Subnet mask consistency check passed.Result: Node connectivity check passedChecking multicast communication.Checking subnet "" for multicast communication with multicast group "".Check of subnet "" for multicast communication with multicast gr

38、oup "" passed.Checking subnet "" for multicast communication with multicast group "".Check of subnet "" for multicast communication with multicast group "" passed.Check of multicast communication passe

39、d.Check: Total memory Node Name Available Required Status - - - - ora-rac2 255.8266GB (2.68253592E8KB) 2GB (2097152.0KB) passed ora-rac1 255.8266GB (2.68253592E8KB) 2GB (2097152.0KB) passed Result: Total memory check passedCheck: Available memory Node Name Available Required Status - - - - ora-rac2

40、217.4978GB (2.28063E8KB) 50MB (51200.0KB) passed ora-rac1 216.1377GB (2.26636848E8KB) 50MB (51200.0KB) passed Result: Available memory check passedCheck: Swap space Node Name Available Required Status - - - - ora-rac2 371.3319GB (3.8936972E8KB) 2GB (2097152.0KB) passed ora-rac1 371.3319GB (3.8936972

41、E8KB) 2GB (2097152.0KB) passed Result: Swap space check passedCheck: Free disk space for "ora-rac2:/var/tmp/" Path Node Name Mount point Available Required Status - - - - - - /var/tmp/ ora-rac2 /var 17.232GB 1GB passed Result: Free disk space check passed for "ora-rac2:/var/tmp/"

42、Check: Free disk space for "ora-rac1:/var/tmp/" Path Node Name Mount point Available Required Status - - - - - - /var/tmp/ ora-rac1 /var 17.4348GB 1GB passed Result: Free disk space check passed for "ora-rac1:/var/tmp/"Check: User existence for "grid" Node Name Status Comment - - - ora-rac2 passed exists(502) ora-rac1 passed exists(502) Checking for multiple users with UID value 502Result: Check for multiple users with UID value 502 passed Result: User existence check passed for "grid"Check: Group existence for &quo