Oracle 10g 自启动脚本

最新推荐文章于 2023-03-20 14:14:23 发布

squll_0_0

最新推荐文章于 2023-03-20 14:14:23 发布

阅读量90

点赞数

分类专栏：服务器配置文章标签： Oracle

本文链接：https://blog.csdn.net/squll_0_0/article/details/83970596

版权

服务器配置专栏收录该内容

7 篇文章 0 订阅

订阅专栏

linux下Oracle自启动脚本, 记录如下：

#!/bin/bash
#
#name:/etc/init.d/oracle10ginit
#chkconfig:2345 99 91
#description:Start and Stop ORACLE 10g
start(){
        #Start TNS
 echo "Starting TNS......"
 su - oracle -c "lsnrctl start"
        sleep 5
 echo "TNS started successfully" 

        #Start Oracle Instance
 echo "Starting Oracle Instance......"
 su - oracle -c "echo \"
   CONN SYS/password AS SYSDBA
   STARTUP
   exit \"|sqlplus /NOLOG"
 sleep 5
 echo "Oracle Instance started successfully"

 #start enterprise manager
        echo "Starting Enterprise Manager"
 su - oracle -c "emctl start dbconsole"
 sleep 5
 echo "Enterprise Manager started successfully"

 #Start isqlplus
 echo "Starting isqlplus"
 su - oracle -c "isqlplusctl start"
 sleep 5
        echo "isqlplus started successfully"
}

stop(){
 #shutdown DB Instance
 echo "Shutdown Oracle DB Instance"
 su - oracle -c "echo \"
   CONN SYS/password AS SYSDBA
   SHUTDOWN immediate
   exit \"|sqlplus /NOLOG"
 sleep 5
 echo "DB Instance shutdown successfully"

 #stop TNS
 echo "STOP TNS"
 su - oracle -c "lsnrctl stop"
 sleep 5
 echo "TNS stop successfully"

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

 #stop isqlplus
 echo "Stop isqlplus"
 su - oracle -c "isqlplusctl stop"
 sleep 5
 echo "isqlplus stop successfully"
}

case "$1" in
start)
 start
 ;;
stop)
 stop
 ;;
*)
 echo "Usage:oracle10ginit[start|stop]" 
 ;;

esac