DB스토리

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