Oracle 10g 自启动脚本

最新推荐文章于 2021-04-08 07:47:44 发布

原创最新推荐文章于 2021-04-08 07:47:44 发布 · 122 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle

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

7 篇文章

订阅专栏

本文提供了一段用于Linux环境下Oracle 10g数据库服务自启动的bash脚本示例。该脚本详细展示了如何实现Oracle实例、监听器、企业管理器及isqlplus的启动与停止流程。

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