数据库随linux启动关闭(待验证)-优快云博客

本文详细介绍了如何在Linux环境下让Oracle随系统开机自动启动，包括两种方法：修改rc.local文件和注册为服务。通过这两种方式，用户可以实现Oracle数据库在系统启动时自动运行，并在系统关闭时自动关闭。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ORACLE随Linux开机启动

第一种方法：

1.修改/etc/rc.local文件加上下的红色内容

####################################

location :/etc/rc.local

####################################

#!/bin/sh

# This script. will be executed *after* all the other init scripts.

# You can put your own initialization stuff in here if you don't

# want to do the full Sys V style. init stuff.

touch /var/lock/subsys/local

su - oracle -c "/bin/sh /home/oracle/dbstart.sh"

2. dbstart.sh的内容

export ORACLE_BASE=/u02/oracle

export ORACLE_HOME=/u02/oracle/ora

export ORACLE_SID=test

sqlplus '/as sysdba'<<eof

startup;

exit

eof

/u02/oracle/ora/bin/lsnrctl start

3.修改/etc/oratab内容

ORACLE_SID:/u01/app/oracle/product/10.2.0/db_1:N改为如下内容

ORACLE_SID:/u01/app/oracle/product/10.2.0/db_1:Y

第二种方法,注册为服务,开机时自动启动,关机自动关闭

/etc/init.d/ora_rpcbdb02内容如下：

#!/bin/bash
#
# chkconfig: 35 95 1
# description: init script. to start/stop oracle database 10g, TNS listener, EMS
# match these values to your environment:
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/10.2.0/db_1
export ORACLE_TERM=xterm
export PATH=/home/oracle/bin:$ORACLE_HOME/bin:$PATH:.
export NLS_LANG='croatian_croatia.ee8iso8859p2'
export ORACLE_SID=rpcbdb02
export DISPLAY=localhost:0
export ORACLE_USER=oracle

# see how we are called:
case $1 in
start)
su - "$ORACLE_USER"<<EOO
lsnrctl start
sqlplus /nolog<<EOS
connect / as sysdba
startup
EOS

EOO
;;

stop)
su - "$ORACLE_USER"<<EOO
lsnrctl stop
sqlplus /nolog<<EOS
connect / as sysdba
shutdown immediate
EOS

EOO
;;

status)
su - "$ORACLE_USER"<<EOO
lsnrctl status
emctl status dbconsole
EOO
;;

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