hpux卸载oracle11,在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、附加软件需求： 【Linux公社 http://www.linuxidc.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.