Auto start&shutdown Oracle9i on Linux9

最新推荐文章于 2025-11-25 12:24:36 发布

原创最新推荐文章于 2025-11-25 12:24:36 发布 · 723 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #linux #date #system #file #database

Oracle 专栏收录该内容

2 篇文章

订阅专栏

本文介绍了在Linux系统下配置Oracle自动启停的方法。首先在/etc/oratab文件中设置自动启停，接着在/etc/rc.d/init.d/目录下创建脚本实现启动和停止操作，还进行了软链接设置。此外，针对Oracle 9i可能出现的找不到初始化文件问题，给出了复制文件的解决办法。

1. set to auto start&shutdown in file of the /etc/oratab.

{SID}:/data/oracle/product/9i:Y

2. touch a file script to start&shutdown the oralce under /etc/rc.d/init.d/.

case "$1" in
start)
echo "Starting Oracle Databases ... "
echo "-------------------------------------------------" >> /var/log/oracle
date +" %T %a %D : Starting Oracle Databasee as part of system up." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
su - oracle -c "dbstart" >> /var/log/oracle
echo "Done."
echo "Starting Oracle Listeners ... "
echo "-------------------------------------------------" >> /var/log/oracle
date +" %T %a %D : Starting Oracle Listeners as part of system up." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
su - oracle -c "lsnrctl start" >> /var/log/oracle
echo "Done."
echo ""
echo "-------------------------------------------------" >> /var/log/oracle
date +" %T %a %D : Finished." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
touch /var/lock/subsys/oracle

;;
stop)
echo "Stoping Oracle Listeners ... "
echo "-------------------------------------------------" >> /var/log/oracle
date +" %T %a %D : Stoping Oracle Listener as part of system down." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
su - oracle -c "lsnrctl stop" >> /var/log/oracle
echo "Done."
rm -f /var/lock/subsys/oracle
echo "Stoping Oracle Databases ... "
echo "-------------------------------------------------" >> /var/log/oracle
date +" %T %a %D : Stoping Oracle Databases as part of system down." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
su - oracle -c "dbshut" >>/var/log/oracle
echo "Done."
echo ""
echo "-------------------------------------------------" >> /var/log/oracle
date +" %T %a %D : Finished." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle