installeroracle11gr2racforHPunix.docx

1、installeroracle11gr2racforHPunixoracle 11.2.0.3 rac for hpnuix电信集成安装配置手册1. 安装前介绍： 平台：两台 HP RX9800型号小机，系统：HP-UX B.11.31 系统，24个1.6GHz CPU， 256GB内存 磁盘阵列: HP P6500 安装数据库软件： 2. 环境规划：服务器IP主机名属性型号ORA-RAC1192.168.1.11ora-rac1PublicHPUX 11.31192.168.1.13ora-rac1-vipVip10.0.0.11ora-rac1-privPrivateORA-RAC2192

2、.168.1.12ora-rac2PublicHPUX 11.31192.168.1.14ora-rac2-vipVip10.0.0.22ora-rac2-privPrivate192.168.1.15scan-clusterScan3. 存储规划数据库磁盘阵列划分ASM磁盘组名称对应的vDisk名Size冗余方式SIZE说明OCRVD01_OCR5GB外部5GBOracle RAC OCR盘DATAVD02_DBFVD03_DBFVD04_DBFVD05_DBFVD06_DBF500GB500GB500GB500GB500GB外部2.5TB建立应用数据表空间数据文件Redo日志文件控制文件F

3、RAVD07_DBFVD08_DBFVD09_DBFVD010_DBFVD011_DBF500GB500GB500GB500GB500GB外部2.5TB建立备份数据文件Redo日志文件控制文件归档日志文件4. 安装前的准备工作 4.1 补丁和软件列表如下： PHCO_40381 11.31 Disk Owner Patch PHKL_38038 vm cumulative patch PHKL_38938 11.31 SCSI cumulative I/O patch PHKL_39351 Scheduler patch : post wait hang PHSS_36354 11.31 as

4、sembler patch PHSS_37042 11.31 hppac (packed decimal) PHSS_37959 Libcl patch for alternate stack issue fix (QXCR1000818011) PHSS_39094 11.31 linker + fdp cumulative patch PHSS_39100 11.31 Math Library Cumulative Patch PHSS_39102 11.31 Integrity Unwind Library PHSS_38141 11.31 aC+ Runtime 还有一个 ssh 包

5、和 bash 包 最好都能打上。 4.2 内核参数设置 kctune -h -B maxssiz=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 kctune -h -B semmns=16384 kctune -h -B semmnu=4092

6、 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=4096 kctune -h -B shmseg=512kctune -h -B tcp_smallest_anon_port=9000kctune -h -B tcp_largest_anon_port=65500kctune -h -B udp_smallest_anon_

7、port=9000kctune -h -B udp_largest_anon_port=65500 执行完上述命令后一定要重启，不要和更新补丁后在重启。 4.3 连接lib 文件 cd /usr/lib 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

8、.3 libXt.sl ln -s libXtst.2 libXtst.sl 4.4 禁用ntp (前提是没有NTP 服务的情况下) # mv /etc/ntp.conf /etc/ntp.conf.bak 4.4.1 调整两个服务器时间一致 # date 03262013153300 4.5 设置/etc/hosts文件 文件内容与2节内容匹配 127.0.0.1 localhost loopback # for oracle # public 192.168.1.11 ora-rac1 192.168.1.12 ora-rac2 # vip 192.168.1.13 ora-rac1-vi

9、p 192.168.1.14 ora-rac2-vip # private 10.0.0.11 ora-rac1-priv 10.0.0.22 ora-rac2-priv # scan 192.168.1.15 scan-cluster 4.6 初始化用户以及组 #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 oracle Changing passwor

10、d for oracle New password: (oracle) Re-enter new password: (oracle) Passwd successfully changed #passwd grid Changing password for oracle New password: (grid) Re-enter new password: (grid) Passwd successfully changed mkdir -p /u01/app/grid chmod -R 777 /u01/app/grid chown -R grid:oinstall /u01/app/g

11、rid mkdir -p /u01/app/oracle chmod -R 777 /u01/app/oracle chown -R oracle:oinstall /u01/app/oracle4.7 共享磁盘检查 在节点1:ora-rac1#/u01/oracle_11gr2cd /dev/rdiskora-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

12、 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 0x00001a 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 M

13、ar 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 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

14、disk58crw-r- 1 bin sys 13 0x000004 Mar 25 17:23 disk1_p2 确定给oracle 使用的磁盘分别是: disk24 - disk34 ora-rac1#/dev/rdiskdiskinfo disk29SCSI describe of disk29: vendor: HP product id: HSV360 type: direct access size: 5242880 Kbytes bytes per sector: 512ora-rac1#/dev/rdisk确定这个磁盘是 5G 的 , 这个磁盘做OCR 磁盘组ora-rac1#/

15、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 13 0x00001aora-rac1#/dev/rdiskmknod /dev/rdisk/VD04_DBF c 13 0x00001bora-rac1#/dev/rdiskmknod /dev/rdisk/VD05_DBF c 13 0x000019ora-rac1#/dev/rdiskm

16、knod /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 0x000021ora-rac1#/dev/rdiskmknod /dev/rdisk/VD09_DBF c 13 0x000020ora-rac1#/dev/rdiskmknod /dev/rdisk/VD010_DBF c 13 0x00001fora-rac1#/dev/rdiskmknod /dev

17、/rdisk/VD011_DBF c 13 0x00001e 在节点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: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:

18、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 disk52crw-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

19、-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 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/rdis

20、k/disk51SCSI describe of /dev/rdisk/disk51: vendor: HP product id: HSV360 type: direct access size: 5242880 Kbytes bytes per sector: 512ora-rac2#/确定这个磁盘是 5G 的 , 这个磁盘做OCR 磁盘组ora-rac2#/dev/rdiskmknod /dev/rdisk/VD01_OCR c 13 0x00001dora-rac2#/dev/rdiskmknod /dev/rdisk/VD02_DBF c 13 0x00001cora-rac2#/d

21、ev/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 13 0x000019ora-rac2#/dev/rdiskmknod /dev/rdisk/VD06_DBF c 13 0x000018ora-rac2#/dev/rdiskmknod /dev/rdisk/VD07_DBF c 13 0x000022ora-rac2#/dev/rdiskmk

22、nod /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 0x00001fora-rac2#/dev/rdiskmknod /dev/rdisk/VD011_DBF c 13 0x00001e 4.8 检查异步IO两个节点都需要设置，不然检查过不去。#/ll /dev/async crw-rw-rw- 1 bin bin 101 0x000000 Aug 28 1

23、0:42 /dev/async需要设置 #/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:14 /dev/async 4.9 设置环境变量： su - grid $ vi .profile 添加如下行: export ORACLE_BASE=/u01/app/grid/baseexport ORACLE_HOME=/u01/app/grid/11.2.0export ORAC

24、LE_SID=+ASM1export ORACLE_UNQNAME=orclexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport ORACLE_HOSTNAME=ora-rac1export PATH=$ORACLE_HOME/bin:.:$PATHumask 022 su - oracle $ vi.profile 添加如下行： export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1export ORACLE_SID= o

25、rcl1export ORACLE_UNQNAME=orclexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport ORACLE_HOSTNAME=ora-rac1export PATH=$ORACLE_HOME/bin:.:$PATHumask 022 4.10 配置ssh 互信关系： 1).在主节点ora-rac1上以grid用户身份生成用户的公匙和私匙# ping ora-rac2# ping ora-rac2-priv# su grid$ mkdir /.ssh$ ssh-keygen -t rsa$ ssh-keygen -t dsa2).在副

26、节点ora-rac2上执行相同的操作，确保通信无阻# ping ora-rac1# ping ora-rac1-pri# su grid$ mkdir /.ssh$ ssh-keygen -t rsa$ ssh-keygen -t dsa3).在主节点ora-rac1上grid用户执行以下操作$ cat /.ssh/id_rsa.pub ./.ssh/authorized_keys$ cat /.ssh/id_dsa.pub ./.ssh/authorized_keys$ ssh ora-rac2 cat /.ssh/id_rsa.pub /.ssh/authorized_keys$ ssh

27、ora-rac2 cat /.ssh/id_dsa.pub /.ssh/authorized_keys$ scp /.ssh/authorized_keys ora-rac2:/.ssh/authorized_keys5. 安装前的检查：$ cd /soft/oracle/grid$ lsdoc install readme.html response rpm runInstaller runcluvfy.sh sshsetup stage welcome.html$ ./runcluvfy.sh stage -pre crsinst -n ora-rac1,ora-rac2 -verbose

28、Performing pre-checks for cluster services setup Checking node reachability.Check: Node reachability from node ora-rac1 Destination Node Reachable? - - ora-rac1 yes ora-rac2 yes Result: Node reachability check passed from node ora-rac1Checking user equivalence.Check: User equivalence for user grid Node Name Status - - ora-rac2 passed ora-rac1 passed Result: User equivalence check passed for user gridChecking 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 o