ABOUT ME

-

Today
-
Yesterday
-
Total
-
  • [Linux] Centos 6.8 - 서버 부팅 시에 Oracle 자동 실행
    운영체제 2019. 3. 4. 09:11
    반응형

    1.임시파일 생성(Oracle 자동실행 스크립트)

    # vi /etc/rc.d/init.d/oracle


    2.파일내용 추가

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    #!/bin/bash
    #chkconfig: 2345 95 20
    #description: oracle service
    #processname: oracle
     
    # /etc/rc.d/init.d/oracle
    #
    # Run-level Startup script for the Oracle Listener and Instances
    # It relies on the information on /etc/oratab
     
    export ORACLE_BASE=/oracle
    export ORACLE_HOME=$ORACLE_BASE/product/11g
    export ORACLE_OWNR=oracle
    export PATH=$PATH:$ORACLE_HOME/bin
     
    if [ ! -f $ORACLE_HOME/bin/dbstart -! -d $ORACLE_HOME ]
     
    then
        echo "Oracle startup: cannot start"
        exit 1
    fi 
     
    case "$1" in
        start)
            # Oracle listener and instance startup
            echo -"Starting Oracle: "
            su $ORACLE_OWNR -"$ORACLE_HOME/bin/lsnrctl start"
            su $ORACLE_OWNR -"$ORACLE_HOME/bin/dbstart $ORACLE_HOME"
            sudo touch /var/lock/oracle
            echo "OK"
            ;;        
     
        stop)
            # Oracle listener and instance shutdown
            echo -"Shutdown Oracle: "
            su $ORACLE_OWNR -"$ORACLE_HOME/bin/lsnrctl stop"
            su $ORACLE_OWNR -"$ORACLE_HOME/bin/dbshut $ORACLE_HOME"
            sudo rm -/var/lock/oracle
            echo "OK"
            ;;      
     
        reload|restart)
            $0 stop
            $0 start
            ;;       
     
        *)
            echo "Usage: `basename $0` start|stop|restart|reload"
            exit 1\
    esac
    exit 0
    cs


    3.Permission 설정

    # chmod 750 /etc/init.d/oracle


    4.Symbolic link 설정

    # ln -s /etc/init.d/oracle /etc/rc5.d/S92oracle

    # ln -s /etc/init.d/oracle /etc/rc5.d/K92oracle

    반응형

    댓글

Designed by Tistory.