linux 下oracle 开机自启动命令（二）

在/etc/init.d/  下新建oracle10g文件，在文件内编辑以下内容

#!/bin/sh

case "$1" in
start)

        # start tsnlisnter
        echo "start tsnlisnter"
                su - oracle -c "lsnrctl start" 

        # start database
        echo "Start Oracle database instance"
        su - oracle -c "echo \"
                        CONN / AS SYSDBA
                        STARTUP
                        exit \"|sqlplus /NOLOG" 

        # start enterprise manager
        echo " Start Emterprise Manager"
        su - oracle -c "emctl start dbconsole" 

        # start isqlplus
        echo "Start isqlplus"
        su - oracle -c "isqlplusctl start" 

        ;;
stop)
        # shutdown database
        echo "Shutdown Oracle database instance"
        su - oracle -c "echo \"
                        CONN / AS SYSDBA
                        SHUTDOWN immediate
                        exit \"|sqlplus /NOLOG" 

        # stop tsnlisnter
        echo "Stop tsnlisnter"
                su - oracle -c "lsnrctl stop" 

        # stop enterprise manager
        echo " Stop Emterprise Manager"
        su - oracle -c "emctl stop dbconsole" 

        # stop isqlplus
        echo "Stop isqlplus"
        su - oracle -c "isqlplusctl stop" 

        ;;
*)
        echo "Usage: $0 { start | stop }"
        exit 1
        ;;
esac
exit 0

在/etc/rc.d/ 的rc.local文件内容中加入以下内容：

/etc/init.d/oracle10g start