티스토리 뷰

DataBase/Oracle

oracle service 등록

디비자 2012. 10. 17. 11:41

root에서 아래 부분 복사해서 붙이면 됨

 

rm -f /etc/init.d/oracle
cat >> /etc/init.d/oracle<<EOF
#!/bin/bash
#/etc/rc.d/init.d/oracle
       # chkconfig: 2345 20 80
       # description: Oracle10g Service Starting
       #              isqlplus,oracleInstance,emctl,lsnr.
       # made by nowage@gmail.com

start() {
        echo -n "Starting Oracle 10g services"
        su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/lsnrctl start">>/u01/app/oracle/product/10.2.0/db_1/log/Log.oracleStartAll.log
        su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/sqlplus / as sysdba<<EOF
            startup
            quit
            EOF
            exit">>/u01/app/oracle/product/10.2.0/db_1/log/Log.oracleStartAll.log
        su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/emctl start dbconsole">>/u01/app/oracle/product/10.2.0/db_1/log/Log.oracleStartAll.log
        su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/isqlplusctl start">>/u01/app/oracle/product/10.2.0/db_1/log/Log.oracleStartAll.log
        echo "done"
}
stop() {
        echo -n "Stopping Oracle 10g services"
        su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/lsnrctl stop">>/u01/app/oracle/product/10.2.0/db_1/log/Log.oracleStopAll.log
        su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/sqlplus / as sysdba<<EOF
            shutdown immediate
            quit
            EOF
            exit">>/u01/app/oracle/product/10.2.0/db_1/log/Log.oracleStopAll.log
        su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/emctl stop dbconsole">>/u01/app/oracle/product/10.2.0/db_1/log/Log.oracleStopAll.log
        su - oracle -c "/u01/app/oracle/product/10.2.0/db_1/bin/isqlplusctl stop" >>/u01/app/oracle/product/10.2.0/db_1/log/Log.oracleStopAll.log
        echo "done"
}
   
case "$1" in
    start)
        start
    ;;
    stop)
        stop
    ;;
    restart|reload)
        stop
        start
    ;;
    *)
        echo "Usage: oracle {start|stop|restart}"
        exit 1
    ;;
esac
exit $?
EOF

chmod 755 /etc/init.d/oracle
/usr/bin/system-config-services

반응형

'DataBase > Oracle' 카테고리의 다른 글

스크립트파일  (0) 2012.10.17
oracle user 생성  (0) 2012.10.17
오라클 스크립트 oracle.sh  (0) 2012.10.17
Archive mode 끄고 켜기  (0) 2012.10.17
잡다한 쿼리구문- 쉬운데 자주 깜박하는 것들 검색용  (0) 2012.07.23
공지사항
최근에 올라온 글
최근에 달린 댓글
Total
Today
Yesterday
링크
«   2024/05   »
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
글 보관함