目录
软件环境
- 操作系统
- RHEL6.1
- 软件
- Oracle10gr2
Oracle服务启动、停止、重启脚本
su - oraclecd /u01/oracle/bin
#进入到Oracle安装的home目录下bin目录中创建启动脚本：
在/u01/oracle/bin下创建启停脚本。
vim dbstartup
#!/bin/bash
lsnrctl start #启动监听程序
sqlplus /nolog <<EOF
connect / as sysdba
startup #进入到Oracle并且连接到SYS管理员账户，执行启动Database
EOF
vi dbstop
#!/bin/bash
lsnrctl stop
sqlplus /nolog <<EOF
connect / as sysdba
shutdown immediate
EOF赋予执行权限
chmod +x dbstartup
chmod +x dbstop进入到root用户：
su - root
cd /etc/rc.d/init.d创建oracle服务管理脚本：
oracle脚本调用了上面的dbstartup和dbstop脚本，可以实现在root用户下启动、停止、重启Oracle服务，并且能够通过/var/log/oracle查看启动日志。
vi oracle
#!/bin/bash
case "$1" in
start)
echo "Starting Oracle Listener and Database ... "
echo "----------------------------------------------------------------------" >> /var/log/oracle
date +" %T %a %D : Starting Oracle Listener and Database ... " >> /var/log/oracle
echo "----------------------------------------------------------------------" >> /var/log/oracle
su - oracle -c dbstartup >> /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 "Stop Oracle Database and Listener ... "
echo "---------------------------------------------------------------------" >> /var/log/oracle
date +" %T %a %D : Stop Oracle Listener and Databases ..." >> /var/log/oracle
echo "---------------------------------------------------------------------" >> /var/log/oracle
su - oracle -c dbstop >> /var/log/oracle
rm -f /var/lock/subsys/oracle
echo "Done."
echo ""
echo "---------------------------------------------------------------------" >> /var/log/oracle
date +" %T %a %D : Finished." >> /var/log/oracle
echo "---------------------------------------------------------------------" >> /var/log/oracle
;;
restart)
echo "Restarting Oracle Listener and Database ..."
echo "---------------------------------------------------------------------" >> /var/log/oracle
date +" %T %a %D : Restart ing Oracle Listener and Databases ..." >> /var/log/oracle
echo "---------------------------------------------------------------------" >> /var/log/oracle
su - oracle -c dbstop >> /var/log/oracle
su - oracle -c dbstartup >> /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
;;
*)
echo "Usage: oracle {start|stop|restart}"
exit 1
esac赋予执行权限：
chmod +x oracle测试：
[root@jmilk init.d]# /sbin/service oracle restart
Restarting Oracle Listener and Database ...
Done创建进程链接文件：
[root@jmilk init.d]# ln -s /etc/rc.d/init.d/oracle /etc/rc.d/rc3.d/K01oracle
[root@jmilk init.d]# ln -s /etc/rc.d/init.d/oracle /etc/rc.d/rc3.d/S99oracle
[root@jmilk init.d]# ln -s /etc/rc.d/init.d/oracle /etc/rc.d/rc5.d/K01oracle
[root@jmilk init.d]# ln -s /etc/rc.d/init.d/oracle /etc/rc.d/rc5.d/S99oracle
[root@jmilk init.d]# ln -s /etc/rc.d/init.d/oracle /etc/rc.d/rc0.d/K01oracle
[root@jmilk init.d]# ln -s /etc/rc.d/init.d/oracle /etc/rc.d/rc6.d/K01oracle自动启动实例:
vi /etc/oratab
demo:/u01/oracle:Y #把N改为Y相关阅读：