[计算机软件及应用]installer-oracle-11gr2-rac-for-HP-unix.doc

oracle rac for hpnuix电信集成安装配置手册1. 安装前介绍：平台：两台 HP RX9800型号小机，系统：HP-UX B.11.31 系统，24个1.6GHz CPU， 256GB内存磁盘阵列: HP P6500 安装数据库软件：2. 环境规划：服务器IP主机名属性型号ORA-RAC11ora-rac1PublicHPUX 11.313ora-rac1-vipVip1ora-rac1-privPrivateORA-RAC22ora-rac2PublicHPUX 11.314ora-rac2-vipVip2ora-rac2-privPrivate5scan-clusterScan3. 存储规划数据库磁盘阵列划分ASM磁盘组名称对应的vDisk名Size冗余方式SIZE说明OCRVD01_OCR5GB外部5GBOracle RAC OCR盘DATAVD02_DBFVD03_DBFVD04_DBFVD05_DBFVD06_DBF500GB500GB500GB500GB500GB外部2.5TB建立应用数据表空间数据文件Redo日志文件控制文件FRAVD07_DBFVD08_DBFVD09_DBFVD010_DBFVD011_DBF500GB500GB500GB500GB500GB外部2.5TB建立备份数据文件Redo日志文件控制文件归档日志文件4. 安装前的准备工作4.1 补丁和软件列表如下： 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 (packed 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还有一个 ssh 包 和 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 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_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.3 libXt.sl ln -s libXtst.2 libXtst.sl4.4禁用ntp (前提是没有NTP 服务的情况下)# mv /etc/ntp.conf/etc/ntp.conf.bak4.4.1调整两个服务器时间一致# date 032620131533004.5设置/etc/hosts文件 文件内容与2节内容匹配 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初始化用户以及组#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 oracleNew 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共享磁盘检查在节点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 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 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 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: vendor: HP product id: HSV360 type: direct access size: 5242880 Kbytes bytes per sector: 512ora-rac1#/dev/rdisk确定这个磁盘是 5G 的 , 这个磁盘做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 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 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/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: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-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/rdisk/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#/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 13 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 0x00001fora-rac2#/dev/rdiskmknod /dev/rdisk/VD011_DBF c 13 0x00001e4.8检查异步IO两个节点都需要设置，不然检查过不去。#/ll /dev/async crw-rw-rw- 1 bin bin 101 0x000000 Aug 28 10: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/async4.9设置环境变量：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 - oracle$ 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 互信关系：1).在主节点ora-rac1上以grid用户身份生成用户的公匙和私匙# ping ora-rac2# ping ora-rac2-priv# su grid$ mkdir /.ssh$ ssh-keygen -t rsa$ ssh-keygen -t dsa2).在副节点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 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 -verbosePerforming 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 ora-rac2 Name IP Address Subnet Gateway Def. Gateway HW Address MTU - - - - - - - lan901 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 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 passed 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 subnet 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? - - - 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 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 .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 group passed.Checking subnet for multicast communication with multicast group .Check of subnet for multicast communication with multicast group passed.Check of multicast communication passed.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 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.8936972E8KB) 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/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