1.切换到root用戶
su -
2.产生服务配置文件
touch /etc/rc.d/init.d/ora_SID   #SID为oracle sid
3.修改配置文件权限
chmod 775 /etc/rc.d/init.d/ora_SID   #SID为oracle sid
4.vi /etc/rc.d/init.d/ora_SID    #SID为oracle sid
加入以下
#!/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/product/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=SID #SID为oracle sid
export DISPLAY=localhost:0
export ORACLE_USER=oracle

case $1 in
    start)
    su - "$ORACLE_USER"<     ORACLE_SID=SID #SID为oracle sid
    lsnrctl start
    sqlplus /nolog<     connect / as sysdba
    startup force;
EOS
EOO
    ;;
    stop)
    su - "$ORACLE_USER"<     ORACLE_SID=SID #SID为oracle sid
    lsnrctl stop
    sqlplus /nolog<     connect / as sysdba
    shutdown immediate
EOS
EOO
    ;;
    status)
    su - "$ORACLE_USER"<     ORACLE_SID=SID #SID为oracle sid
    lsnrctl status
    emctl status dbconsole
EOO
    ;;
    *)
    echo "Usage: $0 {start|stop}"
    ;;
esac
5.加入到linux系统服务中
chkconfig --add ora_SID #SID为oracle sid
6.设置此服务开机自动启动
setup->System services->ora_SID #SID为oracle sid

--下面的方法更加简单常用:
1.修改 $ORACLE_HOME/bin/dbstart 和 $ORACLE_HOME/bin/dbshut
ORACLE_HOME_LISNER=$ORACLE_HOME的实际路径

2.修改 /etc/oratab 最的 N 改为 Y

3.启动脚本
cat /etc/init.d/oracle

#!/bin/sh

# chkconfig: 35 90 90

# description: Oracle 11gR2

# /etc/init.d/oracle

#

# Run-level Stratup script for the Oracle Instance, Listener, and Web Interface

export LANG=zh_CN.UTF-8

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

#export ORACLE_HOME_LISTNER=$ORACLE_HOME

export ORACLE_SID=fzuat

export PATH=$PATH:$ORACLE_HOME/bin

ORA_OWNR="oracle"

case "$1" in
start)

        su $ORA_OWNR -lc $ORACLE_HOME/bin/dbstart

        echo "Oracle Start Successful!"

        ;;

stop)

        su $ORA_OWNR -lc $ORACLE_HOME/bin/dbshut

        echo "Oracle Stop Successful!"

        ;;

reload|restart)

        $0 stop

        $0 start

        ;;

*)

        echo $"Usage: `basename $0` {start|stop|reload|restart}"

        exit 1
esac

exit 0

4.添加到服务
chmod 755 /etc/init.d/oracle
chkconfig --add oracle
chkconfig --list oracle

ITPub博客

oracle for linux 自动启动

最新文章