在HP-UX11iv3上安装Oracle11gR2步骤

一、检查硬件需求： 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空

一、检查硬件需求：

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、附加软件需求：

三、创建用户和组：

# /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.