AIX下安装11GR2

1.检查硬件情况# /usr/sbin/lsattr -E -l sys0 -a realmemrealmem 2031616 Amount of usable physical memory in Kbytes False查看swap space# lsps -aPage Space Physical V olume V olume Group Size %Used Active Auto Typehd6 hdisk0 rootvg 512MB 1 yes yes lv查看系统结构,安装ORACLE需要是64位的系统# getconf HARDWARE_BITMODE64# bootinfo -K64检查OS版本,11GR2需要5300-09以上的版本# oslevel -s5300-10-00-0000检查如下包是否已经安装,没有的话需要smit install进行安装lslpp -l bos.adt.baselslpp -l bos.adt.liblslpp -l bos.adt.libmlslpp -l bos.perf.perfstatlslpp -l bos.perf.libperfstatlslpp -l bos.perf.proctools调整maxuproc(系统最大进程数)Smitty chgsys# chdev -l sys0 -a maxuproc=16384sys0 changed调整ncargs(系统块大小)# chdev -l sys0 -a ncargs=128sys0 changed解压缩zip文件jar xvf aix.ppc64_11gR2_grid.zipunzip aix.ppc64_11gR2_database_1of2.zip unzip aix.ppc64_11gR2_database_2of2.zip创建文件系统/u01,用于安装oracle软件Smitty crfsMount /u01创建用户和组Smitty mkgroup Dba组Oinstall组创建用户修改oracle用户密码# passwd oracleChanging password for "oracle"oracle's New password:Enter the new password again:将oracle软件存放的目录和安装目录的属主修改为oralce# chown -R oracle:oinstall /soft# chown -R oracle:oinstall /u01修改环境变量Cd ~Vi .profile添加如下内容export PS1=[`hostname`/`whoami`]$export EDITOR=viexport ORACLE_SID=oraclexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/libexport PATH=$ORACLE_HOME/bin:/usr/bin:/usr/sbin:/usr/X11R6/bin:/bin:/sbinexport NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"export TMPDIR=/tmp小插曲,以上变量定义好后,发现使用xmanager登陆后,环境变量并没有生效,但通过telnet登陆是生效的,原因是CDC登陆的的时候是使用的.dtprofile文件,修改该文件将最后一行的注释去掉.#DTSOURCEPROFILE=true修改为DTSOURCEPROFILE=true这样重新使用xmanager登陆后,环境变量即可生效.创建环境变量里定义的文件目录[hxl/oracle]$echo $ORACLE_BASE/u01/app/oracle[hxl/oracle]$mkdir -p $ORACLE_BASE[hxl/oracle]$mkdir -p $ORACLE_BASE/product/11.2.0/db_1开始安装数据库软件进入到安装文件存放目录,首先在root用户下执行rootpre.sh[hxl/oracle]$./rootpre.sh./rootpre.sh output will be logged in /tmp/rootpre.out_12-08-20.21:18:00Saving the original files in /etc/ora_save_12-08-20.21:18:00....Copying new kernel extension to /etc....Loading the kernel extension from /etcOracle Kernel Extension Loader for AIXCopyright (c) 1998,1999 Oracle CorporationSuccessfully loaded /etc/pw-syscall.64bit_kernel with kmid: 0x3fa3700 Successfully configured /etc/pw-syscall.64bit_kernel with kmid: 0x3fa3700The kernel extension was successfuly loaded.Configuring Asynchronous I/O....Configuring POSIX Asynchronous I/O....Checking if group services should be configured....Nothing to configure.测试图形界面是否正常[hxl/oracle]$suroot's Password:[hxl/oracle]$xhost +access control disabled, clients can connect from any host[hxl/oracle]$xclock[hxl/oracle]$没有问题的话,就可以按照图形界面安装了[hxl/oracle]$./runInstaller********************************************************************* ***********Your platform requires the root user to perform certain pre-installationOS preparation. The root user should run the shell script 'rootpre.sh' beforeyou proceed with Oracle installation. rootpre.sh can be found at the top levelof the CD or the stage area.Answer 'y' if root has run 'rootpre.sh' so you can proceed with Oracleinstallation.Answer 'n' to abort installation and then ask root to run 'rootpre.sh'.********************************************************************* ***********Has 'rootpre.sh' been run by root? [y/n] (n)yStarting Oracle Universal Installer...Checking temp space: 124 MB available, 190 MB required. Failed <<<< Checking swap space: must be greater than 150 MB. Actual 512 MB Passed Checking monitor: must be configured to display at least 256 colors. Actual 16777216 PassedSome requirement checks failed. You must fulfill these requirements before continuing with the installation,Continue? (y/n) [n] n这里提示/tmp目录太小导致检查无法通过Smitty chfs 添加空间到200m重新执行./runInstaller 1.2.这里只安装软件3.选择单实例安装4.选择语言5.选择企业版安装6.制定安装目录Chown –R oracle:oinstall7.指定安装目录8.选择系统组9.安装前准备问题1:交换空间太小解决办法:查看当前交换空间大小[hxl/oracle]$lsps -aPage Space Physical V olume V olume Group Size %Used Active Auto Typehd6 hdisk0 rootvg 512MB 1 yes yes lv[hxl/oracle]$添加交换空间Smitty chps问题2./tmp 空间太小解决办法Smitty chfs问题3提示没有安装rsct.basic.rteSmitty install 将该包安装即可,该包在光盘介质中可以找得到.问题4 没有打如下补丁If you are using the minimum operating system TL level for AIX 5L listed above, then install all AIX 5L 5.3 Authorized Problem Analysis Reports (APARs) for AIX 5L v. 5.3 ML06, and the following AIX fixes: IZ42940IZ49516IZ52331[hxl/oracle]$instfix -i -kIZ42940There was no data for IZ42940 in the fix database.[hxl/oracle]$instfix -i -kIZ49516There was no data for IZ49516 in the fix database.[hxl/oracle]$instfix -i -kIZ52331There was no data for IZ52331 in the fix database.10.选择忽略如上三个包Invalid entry size(expected 44283015 but got 44282932 bytes)----------------------------------no done-------------------------------------调整虚拟内存管理vmo -p -o minperm%=3vmo -p -o maxperm%=90vmo -p -o maxclient%=90vmo -p -o lru_file_repage=0vmo -p -o strict_maxclient=1vmo -p -o strict_maxperm=0调整网络调试参数no -r -o ipqmaxlen=521no -p -o rfc1323=1no -p -o sb_max=4194304no -p -o tcp_recvspace=65536no -p -o tcp_sendspace=65536no -p -o udp_recvspace=655360no -p -o udp_sendspace=65536创建组和用户mkgroup -A id=506 oinstallmkgroup -A id=505 dbamkgroup -A id=507 asmadminmkgroup -A id=508 asmdbamkgroup -A id=509 asmopermkuser -a id=503 pgrp=oinstall groups=dba,asmadmin,asmdba,asmoper shell=/bin/bash home=/home/grid fsize=-1 cpu=-1 data=-1 core=-1 rss=-1 stack=-1 stack_hard=-1capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGA TE gridpasswd gridmkuser -a id=502 pgrp=oinstall groups=dba,asmdba,asmadmin shell=/bin/bash home=/home/oracle fsize=-1 cpu=-1 data=-1 rss=-1 stack=-1 stack_hard=-1 capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGA TE oraclepasswd oraclemkdir -p /u01/gridmkdir -p /u01/app/oraclechown -R grid:oinstall /u01chmod -R 775 /u01/chown oracle:oinstall /u01/app/oracle调整shell限制/etc/security/limitsfsize = -1core = 2097151cpu = -1data = -1rss = -1stack = -1nofiles = -1环境变量grid用户export ORACLE_BASE=/u01/app/oracleexport GRID_HOM=/u01/gridexport PATH=$GRID_HOME/bin:$PATHoracle用户:export ORACLE_SID=oraclexport ORACLE_BASE=/u01/app/oracleexport GRID_HOME=/u01/gridexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbexport PATH=$ORACLE_HOME/bin:$GRID_HOME/bin:$PATHexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:/lib:/us r/libexportCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/ rdbms/jlib:$ORACLE_HOME/network/jlibexport NLS_LANG=american_america.ZHS16GBKexport ORACLE_OWNER=oracle。