Auto start&shutdown Oracle9i on Linux9
来源:互联网 发布:php源代码加密 编辑:程序博客网 时间:2024/05/19 10:12
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
;;
restart)
$0 stop
$0 start
;;
*)
echo "Usage: oracle {start|stop|restart}"
exit 1
esac
3. ln -s /etc/rc.d/init.d/oracle /etc/rc.d/rc3.d/S99Oracle
ln -s /etc/rc.d/init.d/oracle /etc/rc.d/rc0.d/K01Oracle
ln -s /etc/rc.d/init.d/oracle /etc/rc.d/rc6.d/K01Oracle
4. with oracle9i, it will prompt Can't find init file for Database "SID". fix it with below operate.
cp /opt/oracle/admin/test/pfile/init{SID}.ora $ORACLE_HOME/dbs
- Auto start&shutdown Oracle9i on Linux9
- linux9下Oracle9i的安装
- 在linux9下安装oracle9I
- Linux9下oracle9i的安装之记录
- Install cvs on Redhat Linux9
- shutdown 和 start 命令
- 在redhat Linux9下安装和使用Oracle9i
- linux9
- db2 auto start
- Auto start DB2 Sript
- qmail + webmail on Linux9 安装全过程
- oracle9i on redhat as 4.4
- Oracle9i Installation on RHEL5 (转)
- LINUX下AUTO START ORACLE
- raspberry robot auto start server
- deepin OS Service auto start
- Linux: 安装播放器 Install mplayer (on linux9)
- Start,on my way.
- vb.net中的水晶报表注册码
- 如何表达爱意
- Web Services 中 Web Method 的使用小结(二)
- DELPHI加注册表自启动的最简单代码
- 初试NHibernate
- Auto start&shutdown Oracle9i on Linux9
- STL实践指南
- 大学暗恋她四年,毕业半年后,同学告诉我她等了我四年
- 项目和项目管理基础知识
- I miss my password.
- 如何查询当前进程的TOKEN
- 对文本文件操作很好的类
- 关于计算机的经典笑话(转自MOP)
- About the edition of Windows Server 2003