Oracle10GHPUX 1131安装前检查.docx

oracle10G数据库安装安装前检查2012年02月目 录1.内存：32.交换区：33.文件系统：34.操作系统位数：35.系统信息：46.aio配置47.CC版本48.网络配置49.查看补丁510.Oracle 产品认证详细资料511.核心参数调整查看612.host文件信息713.查看存储814.磁盘信息1215.磁盘大小1316.2台机器的存储磁盘对应关系131. 内存：jzlndb1#/dmesg|grep Physical:Physical: 16601680 Kbytes, lockable: 10504912 Kbytes, available: 12151452 Kbytes2. 交换区：jzlndb1#/swapinfo -a Kb Kb Kb PCT START/ KbTYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAMEdev 17432576 0 17432576 0% 0 - 1 /dev/vg00/lvol2reserve - 845912 -845912memory 15788080 3839876 11948204 24%3. 文件系统：jzlndb1#/bdf Filesystem kbytes used avail %used Mounted on/dev/vg00/lvol3 15400960 231672 15050864 2% /dev/vg00/lvol1 2818048 487080 2312832 17% /stand/dev/vg00/lvol8 15400960 1669960 13623848 11% /var/dev/vg00/lvol7 10485760 3015648 7411784 29% /usr/dev/vg00/lvol4 5242880 337152 4867536 6% /tmp/dev/vg00/lv_ora10g 104857600 92344 98217435 0% /ora10g/dev/vg00/lvol6 15400960 5524576 9799280 36% /opt/dev/vg00/lvnettape 15400960 21267 14418470 0% /nettape/dev/vg00/lvol5 2097152 20904 2060032 1% /home4. 操作系统位数：jzlndb1#/getconf KERNEL_BITS645. 系统信息：jzlndb1#/uname -aHP-UX jzlndb1 B.11.31 U ia64 2927773805 unlimited-user license6. aio配置jzlndb1#/ll /dev/asynccrw-rw-rw- 1 bin bin 101 0x000000 Dec 21 22:31 /dev/asyncjzlndb1#/kctune |grep asyncfs_async 0 Default max_async_ports 4096 Default Immedjzlndb1#/kctune|grep aio_maxaio_max_ops 2048 Default Immed7. CC版本jzlndb1#/cc -V(Bundled) cc: HP C/aC+ B3910B A.06.12 Oct 11 20068. 网络配置jzlndb1#/usr/liblanscanHardware Station Crd Hdw Net-Interface NM MAC HP-DLPI DLPIPath Address In# State NamePPA ID Type Support Mjr#1/0/0/3/0/0/0 0xEC9A746ACD2E 4 UP lan4 snap4 5 ETHER Yes 1191/0/0/3/0/0/1 0xEC9A746ACD32 5 UP lan5 snap5 6 ETHER Yes 1191/0/0/4/0/0/0 0xEC9A746ACD36 6 UP lan6 snap6 7 ETHER Yes 1191/0/0/4/0/0/1 0xEC9A746ACD3A 7 UP lan7 snap7 8 ETHER Yes 119LinkAgg0 0xEC9A746ACBB8 900 UP lan900 snap900 10 ETHER Yes 119LinkAgg1 0xEC9A746ACBBC 901 UP lan901 snap901 11 ETHER Yes 119LinkAgg2 0x000000000000 902 DOWN lan902 snap902 12 ETHER Yes 119LinkAgg3 0x000000000000 903 DOWN lan903 snap903 13 ETHER Yes 119LinkAgg4 0x000000000000 904 DOWN lan904 snap904 14 ETHER Yes 119jzlndb1#/usr/libnetstat -inName Mtu Network Address Ipkts Ierrs Opkts Oerrs Colllo0 32808 127.0.0.0 127.0.0.1 7837 0 7837 0 0 lan901 1500 10.0.5.0 10.0.5.5 5325 0 10233 0 0 lan900 1500 192.168.111.0 192.168.111.111 163 0 0 0 0 9. 查看补丁swlist l patch 或者swlist l bundle根据oracle文档Certification Information for Oracle Database on HP-UX Itanium ID 1307025.1的要求Itanium Information 64-bit Oracle database software only supports 64-bit for Itanium. Oracle does not support running the 32-bit database on Itanium. For HP-UX Itanium Servers based onMontecito chipor later Itanium 2 processors:o HP-UX 11.31 is certified with no OS or Oracle patches required.The following HP-UX 11.23 patches are required: HP-UX 11.23 Hardware Enablement Patches for HP-UX 11i v2, September 2006 Feature Enablement Patches for HP-UX 11i v2, September 2006 No Oracle patches are required. Please follow the IntelMontecitorelated instructions when installing and running Oracle Database releases 10gR2 (10.2.0.2), 10gR1 (10.1.0.5) and 9iR2 (9.2.0.8) on systems based on IntelMontvaleor later Itanium 2 processor based systems.10. Oracle 产品认证详细资料Oracle Database 10.2.0.5.0 已在 HP-UX Itanium 11.31 上通过认证注释Oracle Database 10.2.0.5.0 (针对 HP-UX Itanium 11.31)Product:For general information relating to certification for the Oracle Database product, including virtualization, interoperability, binary compatibiliy, general release and patch set information, seeCore Database Certification Information (Doc ID 1306539.1).Platform:For details about certification of all Oracle Database releases on HP-UX Itanium,click here.Certification:For details specific to the certification of Oracle Database Release 10.2 on HP-UX Itanium,click here.支持信息Oracle Database10.2.0.5.0标准支持的终止日期错误更正的终止日期延长支持的终止日期持续支持的终止日期31-Jul-201131-Jul-201331-Jul-2013无期限在大约 17 个月后, 将不再生成新的Oracle Database 10.2.0.5.0补丁程序。需要有关技术支持策略的说明?了解详细信息.11. 核心参数调整查看jzlndb1#/ kctune|grep -E ckksi_alloc_max|max_thread_proc|maxdsiz|maxdsiz_64bit|maxssiz|maxssiz_64bit|swchunk|maxuprc|msgtql|msgmap|msgmni|msgseg|ncsize|nfile|nflocks|ninode|nproc|nkthread|semmni|semmap|semmns|semmnu|semvmx|shmmax|shmmni|shmsegmax_thread_proc 1200 1200 Immedmaxdsiz 1073741824 Default Immedmaxdsiz_64bit 4294967296 Default Immedmaxssiz 134217728 134217728 Immedmaxssiz_64bit 1073741824 1073741824 Immedmaxuprc 3687 3687 Immedmsgmni 4200 4200 Immedmsgtql 4200 4200 Immedncsize 36672 36672 nflocks 4200 4200 Imm (auto disabled)ninode 35648 35648 nkthread 8416 Default Immednproc 4200 Default Immedpa_maxssiz_32bit 83648512 Default Immedpa_maxssiz_64bit 536870912 Default Immedsemmni 8400 8400 semmns 16800 16800 semmnu 4196 4196 semvmx 32767 Default shmmax 1073741824 Default Immedshmmni 512 512 Immedshmseg 300 Default Immedswchunk 4096 4096 vx_ninode 0 Default Immedjzlndb1#/jzlndb1#/kctune |grep vps_ceilingvps_ceiling 64 64 Immedjzlndb1#/12. host文件信息jzlndb1#/cat /etc/hosts# Configured using SAM by root on Thu Feb 23 14:21:50 2012# Configured using SAM by root on Mon Feb 27 11:24:03 2012# (#)B.11.31_LRhosts $Revision: 1.9.214.1 $ $Date: 96/10/08 13:20:01 $# The form for each entry is:# # For example:# 192.1.2.34 hpfcrm loghost# See the hosts(4) manual page for more information.# Note: The entries cannot be preceded by a space.# The format described in this file is the correct format.# The original Berkeley manual page contains an error in# the format description.#10.0.5.5 jzlndb1192.168.111.111 jzlndb1 #Link_Aggregation10.0.5.6 jzlndb2127.0.0.1 localhost loopbackfstab信息jzlndb1#/cat /etc/fstab# System /etc/fstab file. Static information about the file systems# See fstab(4) and sam(1M) for further details on configuring devices./dev/vg00/lvol3 / vxfs delaylog 0 1/dev/vg00/lvol1 /stand vxfs tranflush 0 1/dev/vg00/lvol4 /tmp vxfs delaylog 0 2/dev/vg00/lvol5 /home vxfs delaylog 0 2/dev/vg00/lvol6 /opt vxfs delaylog 0 2/dev/vg00/lvol7 /usr vxfs delaylog 0 2/dev/vg00/lvol8 /var vxfs delaylog 0 2/dev/vg00/lvnettape /nettape vxfs delaylog 0 2/dev/vg00/lv_ora10g /ora10g vxfs delaylog 0 213. 查看存储jzlndb1#/ioscan -funCdiskClass I H/W Path Driver S/W State H/W Type Description=disk 0 0/0/0/2/0/0/0.0.0 sdisk CLAIMED DEVICE HP LOGICAL VOLUME /dev/dsk/c0t0d0 /dev/dsk/c0t0d0s3 /dev/rdsk/c0t0d0s2 /dev/dsk/c0t0d0s1 /dev/rdsk/c0t0d0 /dev/rdsk/c0t0d0s3 /dev/dsk/c0t0d0s2 /dev/rdsk/c0t0d0s1disk 2 0/0/0/5/0/0/0.98.2.0.0.0.1 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c6t0d1 /dev/rdsk/c6t0d1disk 3 0/0/0/5/0/0/0.98.2.0.0.0.2 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c6t0d2 /dev/rdsk/c6t0d2disk 4 0/0/0/5/0/0/0.98.2.0.0.0.3 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c6t0d3 /dev/rdsk/c6t0d3disk 5 0/0/0/5/0/0/0.98.2.0.0.0.4 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c6t0d4 /dev/rdsk/c6t0d4disk 6 0/0/0/5/0/0/0.98.2.0.0.0.5 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c6t0d5 /dev/rdsk/c6t0d5disk 7 0/0/0/5/0/0/0.98.2.0.0.0.6 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c6t0d6 /dev/rdsk/c6t0d6disk 8 0/0/0/5/0/0/0.98.2.0.0.0.7 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c6t0d7 /dev/rdsk/c6t0d7disk 9 0/0/0/5/0/0/0.98.2.0.0.1.0 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c6t1d0 /dev/rdsk/c6t1d0disk 10 0/0/0/5/0/0/0.98.2.0.0.1.1 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c6t1d1 /dev/rdsk/c6t1d1disk 11 0/0/0/5/0/0/0.98.2.0.0.1.2 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c6t1d2 /dev/rdsk/c6t1d2disk 12 0/0/0/5/0/0/0.98.2.0.0.1.3 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c6t1d3 /dev/rdsk/c6t1d3disk 13 0/0/0/5/0/0/0.98.2.0.0.1.4 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c6t1d4 /dev/rdsk/c6t1d4disk 14 0/0/0/5/0/0/0.98.2.0.0.1.5 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c6t1d5 /dev/rdsk/c6t1d5disk 15 1/0/0/5/0/0/1.98.2.0.0.0.1 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c4t0d1 /dev/rdsk/c4t0d1disk 16 1/0/0/5/0/0/1.98.2.0.0.0.2 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c4t0d2 /dev/rdsk/c4t0d2disk 17 1/0/0/5/0/0/1.98.2.0.0.0.3 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c4t0d3 /dev/rdsk/c4t0d3disk 18 1/0/0/5/0/0/1.98.2.0.0.0.4 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c4t0d4 /dev/rdsk/c4t0d4disk 19 1/0/0/5/0/0/1.98.2.0.0.0.5 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c4t0d5 /dev/rdsk/c4t0d5disk 20 1/0/0/5/0/0/1.98.2.0.0.0.6 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c4t0d6 /dev/rdsk/c4t0d6disk 21 1/0/0/5/0/0/1.98.2.0.0.0.7 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c4t0d7 /dev/rdsk/c4t0d7disk 22 1/0/0/5/0/0/1.98.2.0.0.1.0 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c4t1d0 /dev/rdsk/c4t1d0disk 23 1/0/0/5/0/0/1.98.2.0.0.1.1 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c4t1d1 /dev/rdsk/c4t1d1disk 24 1/0/0/5/0/0/1.98.2.0.0.1.2 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c4t1d2 /dev/rdsk/c4t1d2disk 25 1/0/0/5/0/0/1.98.2.0.0.1.3 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c4t1d3 /dev/rdsk/c4t1d3disk 26 1/0/0/5/0/0/1.98.2.0.0.1.4 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c4t1d4 /dev/rdsk/c4t1d4disk 27 1/0/0/5/0/0/1.98.2.0.0.1.5 sdisk CLAIMED DEVICE HP OPEN-V /dev/dsk/c4t1d5 /dev/rdsk/c4t1d5jzlndb1#/jzlndb1#/ioscan -m lunClass I Lun H/W Path Driver S/W State H/W Type Health Description=ctl 0 64000/0xfa00/0x0 esctl CLAIMED DEVICE online HP P410i 0/0/0/2/0/0/0.0x0.0x0 /dev/pt/pt0disk 1 64000/0xfa00/0x1 esdisk CLAIMED DEVICE online HP LOGICAL VOLUME 0/0/0/2/0/0/0.0x0.0x4000000000000000 /dev/disk/disk1 /dev/rdisk/disk1 /dev/disk/disk1_p1 /dev/rdisk/disk1_p1 /dev/disk/disk1_p2 /dev/rdisk/disk1_p2 /dev/disk/disk1_p3 /dev/rdisk/disk1_p3ctl 1 64000/0xfa00/0x2 esctl CLAIMED DEVICE online HP P410i 1/0/0/2/0/0/0.0x0.0x0 /dev/pt/pt1ctl 4 64000/0xfa00/0x6 esctl CLAIMED DEVICE online HP OPEN-XP12000 0/0/0/5/0/0/0.0x50060e8014459e40.0x0 1/0/0/5/0/0/1.0x50060e8014459e50.0x0 /dev/pt/pt4disk 28 64000/0xfa00/0x7 esdisk CLAIMED DEVICE online HP OPEN-V 0/0/0/5/0/0/0.0x50060e8014459e40.0x4001000000000000 1/0/0/5/0/0/1.0x50060e8014459e50.0x4001000000000000 /dev/disk/disk28 /dev/rdisk/disk28disk 29 64000/0xfa00/0x8 esdisk CLAIMED DEVICE online HP OPEN-V 0/0/0/5/0/0/0.0x50060e8014459e40.0x4002000000000000 1/0/0/5/0/0/1.0x50060e8014459e50.0x4002000000000000 /dev/disk/disk29 /dev/rdisk/disk29disk 30 64000/0xfa00/0x9 esdisk CLAIMED DEVICE online HP OPEN-V 0/0/0/5/0/0/0.0x50060e8014459e40.0x4003000000000000 1/0/0/5/0/0/1.0x50060e8014459e50.0x4003000000000000 /dev/disk/disk30 /dev/rdisk/disk30disk 31 64000/0xfa00/0xa esdisk CLAIMED DEVICE online HP OPEN-V 0/0/0/5/0/0/0.0x50060e8014459e40.0x4004000000000000 1/0/0/5/0/0/1.0x50060e8014459e50.0x4004000000000000 /dev/disk/disk31 /dev/rdisk/disk31disk 32 64000/0xfa00/0xb esdisk CLAIMED DEVICE online HP OPEN-V 0/0/0/5/0/0/0.0x50060e8014459e40.0x4005000000000000 1/0/0/5/0/0/1.0x50060e8014459e50.0x4005000000000000 /dev/disk/disk32 /dev/rdisk/disk32disk 33 64000/0xfa00/0xc esdisk CLAIMED DEVICE online HP OPEN-V 0/0/0/5/0/0/0.0x50060e8014459e40.0x4006000000000000 1/0/0/5/0/0/1.0x50060e8014459e50.0x4006000000000000 /dev/disk/disk33 /dev/rdisk/disk33disk 34 64000/0xfa00/0xd esdisk CLAIMED DEVICE online HP OPEN-V 0/0/0/5/0/0/0.0x50060e8014459e40.0x4007000000000000 1/0/0/5/0/0/1.0x50060e8014459e50.0x4007000000000000 /dev/disk/disk34 /dev/rdisk/disk34disk 35 64000/0xfa00/0xe esdisk CLAIMED DEVICE online HP OPEN-V 0/0/0/5/0/0/0.0x50060e8014459e40.0x4008000000000000 1/0/0/5/0/0/1.0x50060e8014459e50.0x4008000000000000 /dev/disk/disk35 /dev/rdisk/disk35disk 36 64000/0xfa00/0xf esdisk CLAIMED DEVICE online HP OPEN-V 0/0/0/5/0/0/0.0x50060e8014459e40.0x4009000000000000 1/0/0/5/0/0/1.0x50060e8014459e50.0x4009000000000000 /dev/disk/disk36 /dev/rdisk/disk36disk 37 64000/0xfa00/0x10 esdisk CLAIMED DEVICE online HP OPEN-V 0/0/0/5/0/0/0.0x50060e8014459e40.0x400a000000000000 1/0/0/5/0/0/1.0x50060e8014459e50.0x400a000000000000 /dev/disk/disk37 /dev/rdisk/disk37disk 38 64000/0xfa00/0x11 esdisk CLAIMED DEVICE online HP OPEN-V 0/0/0/5/0/0/0.0x50060e8014459e40.0x400b000000000000 1/0/0/5/0/0/1.0x50060e8014459e50.0x400b000000000000 /dev/disk/disk38 /dev/rdisk/disk38disk 39 64000/0xfa00/0x12 esdisk CLAIMED DEVICE online HP OPEN-V 0/0/0/5/0/0/0.0x50060e8014459e40.0x400c000000000000 1/0/0/5/0/0/1.0x50060e8014459e50.0x400c000000000000 /dev/disk/disk39 /dev/rdisk/disk39disk 40 64000/0xfa00/0x13 esdisk CLAIMED DEVICE online HP OPEN-V 0/0/0/5/0/0/0.0x50060e8014459e40.0x400d000000000000 1/0/0/5/0/0/1.0x50060e8014459e50.0x400d000000000000 /dev/disk/disk40 /dev/rdisk/disk40jzlndb1#/14. 磁盘信息jzlndb1#/diskinfo /dev/rdisk/disk40SCSI describe of /dev/rdisk/disk40: vendor: HP product id: OPEN-V type: direct access size: 1049280 Kbytes bytes per sector: 51215. 磁盘大小jzlndb1#/for i in ioscan -m lun|grep rdisk|grep rdisk|awk print $2; do mysize=diskinfo $i|grep size echo $i $mysize donediskinfo: Character device required/dev/disk/disk1_p3 /dev/rdisk/disk1 size: 2929292