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