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'<

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"<    lsnrctl start
    sqlplus /nolog<    connect / as sysdba
    startup
EOS

EOO
    ;;

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

EOO
    ;;

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

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

ITPub博客

ORACLE随Linux开机启动

最新文章