[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) 완료

    댓글(0)

    Designed by JB FACTORY