linux下oracle自动关闭,llinux 下oracle自动重启,关闭

使用root用户

在/etc/rc.d/init.d/ 下创建文件ora9i, 环境变量跟据自己实际情况修改

ora9i文件内容

#!/bin/bash

# name: /etc/rc.d/init.d/ora9i

# description: starts and stops oracle 9i database, TNS

listener

# 启动和关闭oracle9i数据库，TNS监听

#oracle environment(设置环境)

export ORACLE_BASE=/win/oracle

export ORACLE_HOME=/win/oracle/product/9.2

export ORACLE_SID=edm

export PATH=$ORACLE_HOME/bin:$PATH

export ORACLE_OWNER=oracle

export NLS_LANG=American_America.ZHS16GBK

export LANG='zh_CN.GB18030'

# see how we're called

case $1 in

start)

# start listener,and database

su - "$ORACLE_OWNER"<

lsnrctl start

sqlplus /nolog<

connect / as sysdba

startup

EOS

EOO

;;

stop)

# stop listener, and database

su - "$ORACLE_OWNER"<

lsnrctl stop

sqlplus /nolog<

connect / as sysdba

shutdown immediate

EOS

EOO

;;

*)

echo "Usage: ora9i [start|stop]"

;;

esac

改变ora9i文件属性

chmod 755 /etc/rc.d/init.d/ora9i

建立启动数据库联接

ln -s /etc/rc.d/init.d/ora9i

/etc/rc.d/rc2.d/S99oracle ln -s /etc/rc.d/init.d/ora9i /etc/rc.d/rc3.d/S99oracle

ln -s /etc/rc.d/init.d/ora9i /etc/rc.d/rc5.d/S99oracle

建立关闭数据库联接

ln -s /etc/rc.d/init.d/ora9i /etc/rc.d/rc0.d/K01oracle

ln -s /etc/rc.d/init.d/ora9i /etc/rc.d/rc6.d/K01oracle