在HP-UX 11iv3上安装Oracle 11gR2步骤

在HP-UX 11iv3上安装Oracle 11gR2步骤

一、检查硬件需求：
1、内存：
# /usr/contrib/bin/machinfo | grep -i Memory
swap：
1GB-2GB            1.5 times the size of the RAM
2GB-16GB           Equal to the size of the RAM
More than 16 GB    16 GB
查看swap大小：
# /usr/sbin/swapinfo -a
2、磁盘空间：
/tmp空间至少需要1GB：
# bdf /tmp
Oracle软件所占空间：
Enterprise Edition    7.10GB
Standard Edition      6.10GB
数据文件所占空间：
Enterprise Edition    2.20GB
Standard Edition      1.51GB

二、软件需求：
1、操作系统需求：
# uname -a
检查操作系统版本，要安装oracle 11gR2，必须是HP-UX 11i V3 patch Bundle Sep/ 2008 (B.11.31.0809.326a) or higher
# /usr/sbin/swlist -l bundle |grep QPK
  QPKAPPS               B.11.31.1009.353a Applications Patches for HP-UX 11i v3, September 2010
  QPKBASE               B.11.31.1009.353a Base Quality Pack Bundle for HP-UX 11i v3, September 2010
官方文档：
The QPK (Quality Pack) bundles have version numbers of the form. B.11.31.0809.326a (for the September 2008 release), B.11.31.0903.334a (for the March 2009 release), and

so on.
If a required bundle, product, or fileset is not installed, then you must install it. Refer to your operating system or software documentation for information about

installing products.
2、Compiler Requirements
The following are the compiler requirements for HP-UX systems Pro*C/C++, Oracle Call Interface, Oracle C++ Call Interface, and Oracle XML Developer’s Kit (XDK) with
Oracle Database 11g Release 2 (11.2):
A.06.20 (HP C/aC++ Swlist Bundle - C.11.31.04) - Sep 2008
3、补丁需求：
补丁下载网站：http://itrc.hp.com/

For HP-UX 11i V3 (11.31):
PHCO_41479 11.31 Disk Owner Patch
PHKL_38038 VM patch - hot patching/Core file creation directory
PHKL_38938 11.31 SCSI cumulative I/O patch
PHKL_40941 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
PHSS_39824 - 11.31 HP C/aC++ Compiler (A.06.23) patch

For HP-UX 11i V3 (11.31) VERITAS File System:
PHKL_39773: 11.31 VRTS 5.0 GARP6 VRTSvxfs Kernel Patch

检查命令：
# /usr/sbin/swlist -l patch | grep PHSS_37959

安装补丁命令：
# tar xvf hpux_11.31_08230142.tar
# sh create_depot_hpux.11.31
# swinstall -s /tmp/patches/depot

4、附加软件需求： 【帮客之家 http://www.bkjia.com 】

三、创建用户和组：
# /usr/sbin/groupadd -g 501 oinstall
# /usr/sbin/groupadd -g 502 dba
# /usr/sbin/groupadd -g 503 oper
# /usr/sbin/useradd -u 501 -m -d /home/oracle -g oinstall -G dba,oper oracle
# passwd oracle
# id oracle

四、配置内核参数：
# /usr/sbin/kcweb -F
或者
kctune -h 参数名="值"
不想一个个检查的话，可以再安装时检查的时候针对具体不合格参数进行调整

eg：kctune -h ksi_alloc_max="32768"

ksi_alloc_max            32768
executable_stack         0
max_thread_proc          1024
maxdsiz                  1073741824 (1 GB)
maxdsiz_64bit            2147483648 (2 GB)
maxssiz                  134217728 (128 MB)
maxssiz_64bit            1073741824 (1 GB)
maxuprc                  3686
msgmni                   4096
msgtql                   4096
ncsize                   35840
maxfiles_lim             63488
maxfiles                 1024
nflocks                  4096
ninode                   34816
nkthread                 7184
nproc                    4096
semmni                   4096
semmns                   8192
semmnu                   4092
semvmx                   32767
shmmax                   1073741824
shmmni                   4096
shmseg                   512
tcp_smallest_anon_port   9000
tcp_largest_anon_port    65500
udp_smallest_anon_port   9000
udp_largest_anon_port    65500

修改完后需要重启。

检查UDP和TCP内核参数：
# /usr/bin/ndd /dev/tcp tcp_smallest_anon_port tcp_largest_anon_port
# /usr/bin/ndd /dev/udp udp_smallest_anon_port udp_largest_anon_port
# cp /etc/rc.config.d/nddconf /etc/rc.config.d/nddconf.bak
# vi /etc/rc.config.d/nddconf
添加如下内容（按照顺序排列）：
TRANSPORT_NAME[5]=tcp
NDD_NAME[5]=tcp_largest_anon_port
NDD_VALUE[5]=65500

TRANSPORT_NAME[6]=tcp
NDD_NAME[6]=tcp_smallest_anon_port
NDD_VALUE[6]=9000

TRANSPORT_NAME[7]=udp
NDD_NAME[7]=udp_largest_anon_port
NDD_VALUE[7]=65500

TRANSPORT_NAME[8]=udp
NDD_NAME[8]=udp_smallest_anon_port
NDD_VALUE[8]=9000

修改完需要重启

官方文档：
Ensure that the entries are numbered in proper order. For example, if there are three entries present for TCP ports in nddconf, then they are numbered 0 through 3:

TRANSPORT_NAME[0]=tcp, TRANSPORT_NAME[1]=tcp, and TRANSPORT_NAME[2]=tcp. The entries you add are then TRANSPORT_NAME[3]=tcp and TRANSPORT_NAME[4]=tcp.