Oracle 启动脚本

最新推荐文章于 2022-01-27 17:24:07 发布

转载最新推荐文章于 2022-01-27 17:24:07 发布 · 1.1k 阅读

文章标签：

#oracle #database #manager #脚本 #oracle10g #system

其他专栏收录该内容

91 篇文章

订阅专栏

本文提供了一个用于Oracle数据库自动启动的Shell脚本示例。该脚本能够在系统启动时自动开启Oracle服务，包括监听器、数据库实例、企业管理器及iSQL*Plus服务，并详细展示了如何配置脚本以实现这一功能。

大家都注意到用Oracle自带的dbstart脚本无法在系统启动时自动启动Oracle数据库，下面介绍oracle启动脚本的编写和设置！

最简单的脚本示例：

#!/bin/sh
sqlplus / as sysdba<<EOF
startup
EOF

$ ./mydbstart

SQL*Plus: Release 10.1.0.3.0 - Production on Sat Apr 19 13:12:46 2008

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance started.

Total System Global Area  281018368 bytes
Fixed Size                778756 bytes
Variable Size             95165948 bytes
Database Buffers       184549376 bytes
Redo Buffers                524288 bytes
Database mounted.
Database opened.
SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
$

下边是完整的脚本示例

#!/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 /"

connect /  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 /"

connect / 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/init.d/oracle10g
设置脚本连接！

#ln [-s] /etc/init.d/oracle10g /etc/rc2.d/S99oracle10g
#ln [-s] /etc/init.d/oracle10g /etc/rc0.d/K00oracle10g