Oracle Study 之--AIX5.3安装Oracle 11gR2

系统环境：

操作系统： AIX5300-09

Oracle： Oracle 10gR2（64）

对于AIX5.3的版本，如果安装Oracle 11g需要将系统升级到AIX 5300-09的版本，具体升级方法见我的另一博文：

http://tiany.blog.51cto.com/513694/1368026

一、安装前准备

1、查看操作系统的版本

[root@aix211 /]#oslevel -r

5300-09

2、查看系统硬件信息

[root@aix211 /]#prtconf |grep -i mem

Memory Size: 4096 MB

Good Memory Size: 4096 MB

+ mem0 Memory

[root@aix211 /]#lsattr -El mem0

goodsize 4096 Amount of usable physical memory in Mbytes False

size 4096 Total amount of physical memory in Mbytes False

[root@aix211 /]#prtconf |more

SystemModel:IBM,7028-6C4MachineSerialNumber:1040F8AProcessorType:PowerPC_POWER4ProcessorImplementationMode:POWER4ProcessorVersion:PV_4_2NumberOfProcessors:2ProcessorClockSpeed:1453MHzCPUType:64-bitKernelType:64-bitLPARInfo:1NULLMemorySize:4096MBGoodMemorySize:4096MBPlatformFirmwarelevel:3R061030FirmwareVersion:IBM,RG061030_d79e19_rConsoleLogin:enableAutoRestart:trueFullCore:false

3、查看系统内核版本

[root@aix211 /]# bootinfo -K

64

如果内核版本非64位，可以将内核版本升级到64位

-----32位内核升级到64位#ln-sf/usr/lib/boot/unix_64/unix#ln-sf/usr/lib/boot/unix_64/usr/lib/boot/unix#bosboot-ad/dev/ipldevice#shutdown-Fr从64位降级到32位#ln-sf/usr/lib/boot/unix_mp/unix#ln-sf/usr/lib/boot/unix_mp/usr/lib/boot/unix#bosboot-ad/dev/ipldevice#shutdown-Fr

4、查看文件系统空间

注：保证有足够的系统空间安装Oracle（最少在7G以上的空间）

[root@aix211 /]#df -m

FilesystemMBblocksFree%UsedIused%IusedMountedon/dev/hd411648.007924.9032%70051%//dev/hd22560.00640.4675%453347%/usr/dev/hd9var640.00269.0758%11981%/var/dev/hd31152.001007.0913%1791%/tmp/dev/hd1128.00123.804%851%/home/proc-----/proc/dev/hd10opt384.00107.3073%48295%/opt/dev/lv00128.00123.944%181%/var/adm/csd/dev/u0120480.008254.3560%420631%/u01/dev/lv_data12048.001983.674%171%/data1/dev/fslv002112.002111.361%41%/dsk1192.168.8.212:/ware20480.009504.8054%58241%/ware

-----注意：

1、 /tmp 必须保证最少需要400M空间

2、如果/u01 放在 ‘ / ’下，最少需要7g以上空间

3、其余/usr,/var 也要保证足够的空间

5、查看页面交换空间

[root@aix211/]#lsps-aPageSpacePhysicalVolumeVolumeGroupSize%UsedActiveAutoTypepaging01hdisk2oravg1024MB1yesyeslvlv_pg01hdisk1oravg1024MB1yesyeslvhd6hdisk0rootvg2048MB1yesyeslv[root@aix211/]#lsps-sTotalPagingSpacePercentUsed4096MB1%

注：

Page space 可以设置为Physical Memory的2 倍或和内存大小一致


6、查看系统需要的软件和补丁

------查看软件包的安装和补丁

[root@aix211 /]#lslpp -l |grep bos.adt

bos.adt.base5.3.8.0COMMITTEDBaseApplicationDevelopmentbos.adt.debug5.3.8.0COMMITTEDBaseApplicationDevelopmentbos.adt.graphics5.3.7.0COMMITTEDBaseApplicationDevelopmentbos.adt.include5.3.8.0COMMITTEDBaseApplicationDevelopmentbos.adt.insttools5.3.8.0COMMITTEDTooltoCreateinstallpbos.adt.lib5.3.8.0COMMITTEDBaseApplicationDevelopmentbos.adt.libm5.3.8.0COMMITTEDBaseApplicationDevelopmentbos.adt.libmio5.3.8.0COMMITTEDModularIOLibrarybos.adt.prof5.3.8.1COMMITTEDBaseProfilingSupportbos.adt.prt_tools5.3.0.0COMMITTEDPrinterSupportDevelopmentbos.adt.samples5.3.7.0COMMITTEDBaseOperatingSystemSamplesbos.adt.sccs5.3.8.0COMMITTEDSCCSApplicationDevelopmentbos.adt.syscalls5.3.7.0COMMITTEDSystemCallsApplicationbos.adt.utils5.3.8.0COMMITTEDBaseApplicationDevelopmentbos.adt.data5.3.0.0COMMITTEDBaseApplicationDevelopment

[root@aix211 /]#lslpp -l |grep -i xlc.rte

xlC.rte9.0.0.1COMMITTEDXLC/C++Runtime

[root@aix211 /]#lslpp -l |grep -i xlc

xlC.aix50.rte9.0.0.1COMMITTEDXLC/C++RuntimeforAIX5.2xlC.cpp9.0.0.0COMMITTEDCforAIXPreprocessorxlC.rte9.0.0.1COMMITTEDXLC/C++Runtime

[root@aix211 /]#lslpp -l |grep -i bos.perf

bos.perf.diag_tool5.3.0.50COMMITTEDPerformanceDiagnosticToolbos.perf.libperfstat5.3.8.0COMMITTEDPerformanceStatisticsLibrarybos.perf.perfstat5.3.8.1COMMITTEDPerformanceStatisticsbos.perf.proctools5.3.8.0COMMITTEDProcFilesystemToolsbos.perf.tools5.3.8.0COMMITTEDBasePerformanceToolsbos.perf.tune5.3.8.0COMMITTEDPerformanceTuningSupportbos.perf.diag_tool5.3.0.50COMMITTEDPerformanceDiagnosticToolbos.perf.libperfstat5.3.8.0COMMITTEDPerformanceStatisticsLibrarybos.perf.perfstat5.3.8.1COMMITTEDPerformanceStatisticsbos.perf.tools5.3.8.0COMMITTEDBasePerformanceToolsbos.perf.tune5.3.8.0COMMITTEDPerformanceTuningSupport

查看所需补丁

[root@aix211/]#instfix-ikIY58143AllfilesetsforIY58143werefound.[root@aix211/]#instfix-ikIY59386AllfilesetsforIY59386werefound.[root@aix211/]#instfix-ikIY60930AllfilesetsforIY60930werefound.[root@aix211/]#instfix-ikIY66513AllfilesetsforIY66513werefound.[root@aix211/]#instfix-ikIY70159AllfilesetsforIY70159werefound.[root@aix211/]#instfix-ikIY68989AllfilesetsforIY68989werefound.

7、修改系统内核参数和启动ASYNC I/O

-----修改系统内核参数

[root@aix211 /]# smit system

Change/ShowCharacteristicsofOperatingSystem=>MaximumnumberofPROCESSESallowedperuser[2048]

----开启系统异步I/O

[root@aix211 /]#smit chaio

MINIMUMnumberofservers[1]MAXIMUMnumberofserverspercpu[10]maximumnumberofREQUESTS[4096]serverPRIORITY[39]STATEtobeconfiguredatsystemrestartavailableStateoffastpathenable

8、建立Oracle用户和组及环境变量

------建立用户和组：

groups：oinstall、dbausers：oracle[root@aix211/]#smitchuser（修改oracle用户读取内存页面的限制）SoftFILEsize[-1]SoftCPUtime[-1]SoftDATAsegment[-1]SoftSTACKsize[-1]SoftCOREfilesize[-1][root@aix211database]#cat/etc/security/limitsoracle:fsize=-1data=-1stack=-1core=-1[oracle@aix211~]$cat.profilePATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.exportPATHif[-s"$MAIL"]#ThisisatShellstartup.Innormalthenecho"$MAILMSG"#operation,theShellchecksfi#periodically.ORACLE_BASE=/u01/app/oracleORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1ORACLE_SID=prodPATH=$PATH:$ORACLE_HOME/binexportORACLE_BASEORACLE_HOMEORACLE_SIDPATH[oracle@aix211~]$

二、安装Oracle 软件

-----安装oracle 11g软件

安装完成：