Ubuntu16.04/Linux安装Oracle 11g数据库/设置Enterpries Manager/设置em/及设置开机启动(三)

梦回起点

做你害怕做的事，你会发现：不过如此

本站基于WordPress—主题by 设计窝
冀ICP备15003737号
梦回起点
Copyright © 2015-2018 All rights reserved.

Ubuntu16.04/Linux安装Oracle 11g数据库/设置Enterpries Manager/设置em/及设置开机启动(三)

今天我们继续来说怎么开机自动启动oracle，首先我们需要修改/etc/oratab文件
$vi /etc/oratab
找到#orcl:/opt/oracle/oracle11g/product/11.2.0/dbhome_1:N这一行
改为：
orcl:/opt/oracle/oracle11g/product/11.2.0/dbhome_1:Y
也就是将最后的N改为Y，意思是将不允许自动启动改为允许自动启动。

然后我们在文件中输入如下内容

#!/bin/sh
### BEGIN INIT INFO
# Provides:          oracle
# Required-Start:    $local_fs $remote_fs $network $syslog
# Required-Stop:     $local_fs $remote_fs $network $syslog
# Default-Start:     2 3 4 5
# Default-Stop:      0 1 6
# Short-Description: starts the oracle daemon
# Description:       starts oracle using start-stop-daemon
### END INIT INFO

ORA_HOME=/opt/oracle/oracle11g/product/11.2.0/dbhome_1/
ORACLE_SID=orcl
PATH=$PATH:$ORACLE_HOME/bin
ORA_OWNER=oracle

if [ ! -f $ORA_HOME/bin/dbstart ]
then
echo "Oracle startup: cannot start"
exit
fi
case "$1" in
'start')
# Start the Oracle databases:
echo "Starting Oracle Databases ... "
echo "-------------------------------------------------" >> /var/log/oracle
date +" %T %a %D : Starting Oracle Databases as part of system up." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart" >>/var/log/oracle
echo "Done"
# Start the Listener:
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 - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start" >>/var/log/oracle
echo "Done."

echo "Starting emctl dbconsole ... "
echo "-------------------------------------------------" >> /var/log/oracle
date +" %T %a %D : Starting emctl dbconsole as part of system up." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start dbconsole" >> /var/log/oracle
echo "Done."

echo "-------------------------------------------------" >> /var/log/oracle
date +" %T %a %D : Finished." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
touch /var/lock/subsys/oracle
;;
'stop')
# Stop the Oracle Listener:
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 - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop" >>/var/log/oracle
echo "Done."
rm -f /var/lock/subsys/oracle

# Stop the Oracle Database:
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 - $ORA_OWNER -c "$ORA_HOME/bin/dbshut" >>/var/log/oracle 
echo "Done."

echo "Stoping emctl dbconsole ... "
echo "-------------------------------------------------" >> /var/log/oracle
date +" %T %a %D : Starting emctl dbconsole as part of system up." >> /var/log/oracle
echo "-------------------------------------------------" >> /var/log/oracle
su - $ORA_OWNER -c "$ORA_HOME/bin/emctl stop dbconsole" >> /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

esac

#!/bin/sh

### BEGIN INIT INFO

# Provides: oracle

# Required-Start: $local_fs $remote_fs $network $syslog

# Required-Stop: $local_fs $remote_fs $network $syslog

# Default-Start: 2 3 4 5

# Default-Stop: 0 1 6

# Short-Description: starts the oracle daemon

# Description: starts oracle using start-stop-daemon

### END INIT INFO

ORA_HOME=/opt/oracle/oracle11g/product/11.2.0/dbhome_1/

ORACLE_SID=orcl

PATH=$PATH:$ORACLE_HOME/bin

ORA_OWNER=oracle

if [ ! -f $ORA_HOME/bin/dbstart ]

then

echo "Oracle startup: cannot start"

exit

case "$1" in

'start')

# Start the Oracle databases:

echo "Starting Oracle Databases ... "