oracle 11.2.0.3 rac for hpnuix
电信集成安装配置手册
1. 安装前介绍：
平台：两台 HP RX9800型号小机，系统：HP-UX B.11.31 系统，24个1.6GHz CPU， 256GB内存
磁盘阵列: HP P6500 安装数据库软件：
2. 环境规划：
服务器 ORA-RAC1 IP 192.168.1.11 192.168.1.13 10.0.0.11 192.168.1.12 192.168.1.14 10.0.0.22 192.168.1.15 主机名 ora-rac1 ora-rac1-vip ora-rac1-priv ora-rac2 ora-rac2-vip ora-rac2-priv scan-cluster 属性 Public Vip Private Public Vip Private Scan 型号 HPUX 11.31 HPUX 11.31 ORA-RAC2
3. 存储规划
数据库磁盘阵列划分 ASM磁盘组名称 OCR 对应的vDisk名 VD01_OCR Size 5GB 冗余方式 外部 SIZE 5GB 说明 Oracle RAC OCR盘 DATA VD02_DBF VD03_DBF VD04_DBF VD05_DBF VD06_DBF VD07_DBF VD08_DBF VD09_DBF VD010_DBF VD011_DBF 500GB 外部 500GB 500GB 500GB 500GB 500GB 外部 500GB 500GB 500GB 500GB 2.5TB 建立应用数据表空间数据文件 Redo日志文件 控制文件 FRA 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 assembler 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 包 和 bash 包 最好都能打上。
4.2 内核参数设置
kctune -h -B maxssiz=\
kctune -h -B maxssiz_64bit=\ kctune -h -B maxuprc=\ kctune -h -B msgmni=\ kctune -h -B msgtql=\ kctune -h -B ncsize=\ kctune -h -B ninode=\ kctune -h -B semmni=\
kctune -h -B semmns=\ kctune -h -B semmnu=\
kctune -h -B shmmax=\ kctune -h -B shmmni=\ kctune -h -B vps_ceiling=\ kctune -h -B nproc=\
kctune -h -B maxfiles_lim=\ kctune -h -B shmmni=\ kctune -h -B shmseg=\
kctune -h -B tcp_smallest_anon_port=\ kctune -h -B tcp_largest_anon_port=\kctune -h -B udp_smallest_anon_port=\kctune -h -B udp_largest_anon_port=\
执行完上述命令后一定要重启，不要和更新补丁后在重启。
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.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-vip 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 password 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/grid mkdir -p /u01/app/oracle
chmod -R 777 /u01/app/oracle
chown -R oracle:oinstall /u01/app/oracle
4.7 共享磁盘检查
在节点1:
ora-rac1#[/u01/oracle_11gr2]cd /dev/rdisk ora-rac1#[/dev/rdisk]ls -lrt total 0
crw-r----- 1 bin sys 13 0x000001 Feb 6 13:26 disk1 crw-r----- 1 bin sys 13 0x000003 Feb 6 13:26 disk1_p1 crw-r----- 1 bin sys 13 0x000005 Feb 6 13:26 disk1_p3 crw-r----- 1 bin sys 13 0x00001d Mar 22 16:12 disk29 crw-r----- 1 bin sys 13 0x00001c Mar 22 16:12 disk28 crw-r----- 1 bin sys 13 0x00001a Mar 22 16:12 disk26 crw-r----- 1 bin sys 13 0x00001b Mar 22 16:12 disk27 crw-r----- 1 bin sys 13 0x000019 Mar 22 16:12 disk25 crw-r----- 1 bin sys 13 0x000018 Mar 22 16:12 disk24 crw-r----- 1 bin sys 13 0x000022 Mar 22 16:12 disk34 crw-r----- 1 bin sys 13 0x000021 Mar 22 16:12 disk33 crw-r----- 1 bin sys 13 0x000020 Mar 22 16:12 disk32 crw-r----- 1 bin sys 13 0x00001f Mar 22 16:12 disk31 crw-r----- 1 bin sys 13 0x00001e Mar 22 16:12 disk30 crw-r----- 1 bin sys 13 0x000023 Mar 25 16:52 disk58 crw-r----- 1 bin sys 13 0x000004 Mar 25 17:23 disk1_p2
确定给oracle 使用的磁盘分别是: disk24 ---- disk34 ora-rac1#[/dev/rdisk]diskinfo disk29 SCSI describe of disk29:
vendor: HP
product id: HSV360 type: direct access size: 5242880 Kbytes bytes per sector: 512 ora-rac1#[/dev/rdisk]
确定这个磁盘是 5G 的 , 这个磁盘做OCR 磁盘组
ora-rac1#[/dev/rdisk]mknod /dev/rdisk/VD01_OCR c 13 0x00001d ora-rac1#[/dev/rdisk]mknod /dev/rdisk/VD02_DBF c 13 0x00001c ora-rac1#[/dev/rdisk]mknod /dev/rdisk/VD03_DBF c 13 0x00001a ora-rac1#[/dev/rdisk]mknod /dev/rdisk/VD04_DBF c 13 0x00001b