Oracle11g启动关闭脚本

最新推荐文章于 2021-04-04 09:42:57 发布

转载最新推荐文章于 2021-04-04 09:42:57 发布 · 810 阅读

Oracle Troubleshooting 专栏收录该内容

2 篇文章

订阅专栏

本文介绍了一种用于启动和停止Oracle数据库服务的方法，通过编写shell脚本实现数据库服务的自动化管理。其中包括了start11g和shutdown11g两个脚本，分别用于启动和关闭Oracle 11g实例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

转载自：http://blog.youkuaiyun.com/kcen_cai/article/details/26759449

[root@oracle ~]# cat /etc/init.d/oracle

#! /bin/bash
#
# oracle Bring up/down oracle
#
# chkconfig: 2345 90 1
# description: Activates/Deactivates all network interfaces configured to \
# start at boot time.
#

# Source function library.
. /etc/init.d/functions

case "$1" in
start)

su - oracle -c "sourec /home/oracle/.11g;lsnrtctl start;start11g"

;;
*)
echo $"Usage: $0 {start|stop|restart|reload|status}"
exit 1
esac

exit $rc

[root@oracle ~]# cat start11g
#!/bin/bash
source /home/oracle/.11g
lsnrctl start;
sqlplus / as sysdba
startup
EOF

chmod +x ./start11g

[root@oracle ~]# cat shutdown11g
#!/bin/bash
source /home/oracle/.11g
lsnrctl stop;
sqlplus / as sysdba
shutdown immediate
EOF

chmod +x ./shutdown11g

[root@oracle ~]# cat /etc/init.d/oracle
#! /bin/bash
#
# oracle Bring up/down oracle
#
# chkconfig: 2345 90 1
# description: Activates/Deactivates all network interfaces configured to \
# start at boot time.
#

# Source function library.
. /etc/init.d/functions

case "$1" in
start)

su - oracle -c "sourec /home/oracle/start11g"

;;
stop)

su - oracle -c "sourec /home/oracle/shutdown11g"
*)
echo $"Usage: $0 {start|stop|restart}"
exit 1
esac

exit $rc
chmod +x !$
chmod +x /etc/init.d/oracle

chkconfig oracle on