[DB] AIX 5.3 Oracle Database 11g 설치

1. 설치 전 준비 사항

Hardware 체크

    1) Memory(최소 1GB)

        # /usr/sbin/lsattr -E -l sys0 -a realmem

    2) RAM 과 SWAP Space        

        # /usr/sbin/lsps –a

RAM	Swap Space
Between 1024 MB and 2048 MB	1.5 times the size of RAM
Between 2049 MB and 8192 MB	Equal to the size of RAM
More than 8192 MB	0.75 times the size of RAM

 

    3) Kernel Bit확인(11g는 64bit 만 지원함)

        # /usr/bin/getconf HARDWARE_BITMODE

            

    4) Disk Space

        Temp(400MB이상)

        # df -k /tmp

        Engine 설치 공간

        # df –k

Installation Type	Requirement for Software Files (GB)
Enterprise Edition	6.45
Standard Edition	6.18
Custom (maximum)	6.45

        Data File 공간

Installation Type	Disk Space for Data Files (GB)
Enterprise Edition	1.6
Standard Edition	1.6
Custom (maximum)	1.81

 

    Software 체크

    1) OS Version

        # oslevel –r

AIX 5L version 5.3, TL 05, Service Pack 06

AIX 6L version 6.1, TL 00, Service Pack 04 or later

    2) Package 확인(AIX 5L)

        # lslpp -l bos.adt.base

bos.adt.base

bos.adt.lib

bos.adt.libm

bos.perf.libperfstat 5.3.9.0 or later

bos.perf.perfstat

bos.perf.proctools

rsct.basic.rte

rsct.compat.clients.rte

xlC.aix50.rte:10.1.0.0 or later

gpfs.base 3.2.1.8 or later (Clusterware 설치시 필요함)

    3) Compiler 확인

XL C/C++ Enterprise Edition V8.0 for AIX

또는

        gcc 3.4.5

    4) Patch

        # /usr/sbin/instfix -i -k ""IY89080 IY92037 IY94343"

        Authorized Problem Analysis Reports (APARs) for AIX 5L v5.3:

IY89080

IY92037

IY94343

IZ01060 or efix for IZ01060

IZ03260, or efix for IZ03260

    

    System Parameter 및 Shell 제한 설정 .profile설정

    1) Shell 제한 설정

Shell Limit (As Shown in smit)	Recommended Value
Soft FILE size	-1 (Unlimited)
Soft CPU time	-1 (Unlimited) Note: This is the default value.
Soft DATA segment	-1 (Unlimited)
Soft STACK size	-1 (Unlimited)
Soft Real Memory size	-1 (Unlimited)

 

    2) System Parameter 설정

        #smit chgsys

        Maximum number of PROCESSES >= 2048

        ARG/ENV list size in 4K byte blocks >= 128

    

    3) .profile 설정

#Set up the shell environment: umask 022 set -u set -o vi #Set up the shell variables: EDITOR=vi LANG=C PS1="[\$LOGNAME@`hostname`:\$ORACLE_SID:\$PWD$]" DISPLAY=localhost:0.0 export EDITOR LANG PS1 DISPLAY #Oracle Environment export ORACLE_BASE=/oracle/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/10g export ORACLE_SID=ORA10 export ORACLE_OWNER=oracle export ORACLE_TERM=vt100 export ORACLE_DOC=$ORACLE_BASE/doc export TMPDIR=$ORACLE_BASE/tmp export TNS_ADMIN=$ORACLE_HOME/network/admin export ORA_NLS10=$ORACLE_HOME/nls/data export NLS_LANG=American_america.KO16KSC5601 export PATH=$PATH:$ORACLE_HOME/bin:/bin:/usr/bin:/sbin:/usr/ccs/bin export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib:/usr/lib export LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib:/usr/lib export AIXTHREAD_SCOPE=S

 

    rootpre.sh Script 실행

    1) 설치 파일, 패치 파일 및 rootpre.sh 다운로드

    2) 설치 전에 다운 받은 rootpre.sh 실행

        # /directory_path/rootpre/rootpre.sh

    3) 설치파일 확인 및 압축풀기

        aix.ppc64_11gR1_database_1013_1of2.zip

        aix.ppc64_11gR1_database_1013_2of2.zip

        p6890831_111070_AIX5L_1of2.zip

p6890831_111070_AIX5L_2of2.zip

    4) GUI 모드로 실행

        $ ./runInstaller

    5) software만 설치

    6) Patch 설치 전 shared libarary clean

        # /usr/sbin/slibclean 여러 번 실행

    7) Patch 실행

        $ ./runInstaller

    8) netca로 Listener 생성

    9) dbca로 Database생성

    10) 완료