[10g] CentOS에서 오라클 자동시작 만들기

/********************************************************************************************
-- Title : [10g] CentOS에서 오라클 자동시작 만들기
-- Reference : http://www.gigatera.co.kr/tt/349#recentTrackbacks
-- Key word : oracle autostart auto start cent os
********************************************************************************************/

1. /etc/oratab
orcl:/usr/local/oracle/product/11.1.0/db_1:N
위 문장에서 N을 Y로 변경 후 저장

2. 스크립트 작성
 1) 위치 : /etc/rc.d/init.d
 2) 권한 : chmod 755
 3) 내용 : vi /etc/rc.d/init.d/oracle에서 아래 내용 입력

#!/bin/sh

ORACLE_HOME=/usr/local/oracle/product/11.1.0/db_1
ORACLE_OWNER=oracle

case "$1" in
    start)
        echo -n "Starting ORACLE ..."
        su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbstart" >> /var/log/oracle
        su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl start"  >> /var/log/oracle
        echo -n "ORACLE open ..."
        touch /var/lock/subsys/oracle
        ;;
    stop)
        echo -n "Stopping ORACLE ..."
        touch /var/lock/subsys/oracle
        su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbstart" >> /var/log/oracle
        su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl stop"  >> /var/log/oracle
        echo -n "ORACLE close ..."
        ;;
    *)
        echo "Usage: $0 {start|stop}"
        exit 1
        ;;
esac

 4) ln 설정
    (1) ln -s /etc/rc.d/init.d/oracle /etc/rc.d/rc3.d/S97Oracle
    (2) ln -s /etc/rc.d/init.d/oracle /etc/rc.d/rc5.d/S97Oracle
    (3) ln -s /etc/rc.d/init.d/oracle /etc/rc.d/rc0.d/K07Oracle
    (4) ln -s /etc/rc.d/init.d/oracle /etc/rc.d/rc6.d/K07Oracle