Linux下自动启动和关闭Oracle数据库


自动启动oracle9i
在/home/oracle下建立文件StartOra.sh:
vi StartOra.sh
--------------------------------
echo "Begin to start the oracle!"
lsnrctl start
sqlplus /nolog < connect /as sysdba
startup
exit
EOF
echo "Oracle just have been started!"
exit
--------------------------------
给StartOra.sh执行权限
chmod a+x StartOra.sh

自动关闭oracle9i
在/oracle下建立文件StopOra.sh:
vi StopOra.sh
--------------------------------
echo "Begin to stop the oracle!"
sqlplus /nolog < connect /as sysdba
shutdown immediate
exit
EOF
lsnrctl stop
echo "Oracle just have been stopped!"
exit
--------------------------------
给StopOra.sh执行权限
chmod a+x StopOra.sh

将启动和关闭oracle脚本加到系统的开机自启动
vi /etc/rc.local
su - oracle -c "/home/oracle/StartOra.sh" #启动oracle

后续:其实这个脚本并不是最好的,最好的解决方案是通过调用Oracle自带的dbstart和dbshut来实现。

文章见此:http://heylinux.com/archives/371.html

  1. No comments yet.
(will not be published)
*