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