Oracle如何设置在Linux上设置自启动（无crs/has管理）

 

Oracle如何设置在Linux上设置自启动（无crs/has管理）

 

安装了crs或者has的无需通过此方式。

官方提供的方式。

 

1.修改文件/etc/oratab：

   <SID>:<ORACLE_HOME>:Y

改为Y状态。

Y状态表示可以通过自带的脚本dbstart和dbshut来启动和关闭。

 

2.创建脚本：/etc/init.d/dbora

修改第13和14行

 #!/bin/bash
 #
 # chkconfig: 35 99 10   
 # description: Starts and stops Oracle processes
 #
 # Set ORA_HOME to be equivalent to the $ORACLE_HOME
 # from which you wish to execute dbstart and dbshut;
 #
 # Set ORA_OWNER to the user id of the owner of the
 # Oracle database in ORA_HOME.
 #

 ORA_HOME=<Type your ORACLE_HOME in full path here>
 ORA_OWNER=<Type your Oracle account name here>

 case "$1" in
   'start')
      # Start the TNS Listener
      su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
 
      # Start the Oracle databases:
      # The following command assumes that the oracle login
      # will not prompt the user for any values
      su - $ORA_OWNER -c $ORA_HOME/bin/dbstart

      # Start the Intelligent Agent
      if [ -f $ORA_HOME/bin/emctl ]; then
         su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start agent"
      elif [ -f $ORA_HOME/bin/agentctl ]; then
         su - $ORA_OWNER -c "$ORA_HOME/bin/agentctl start"
      else
         su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl dbsnmp_start"
      fi

      # Start Management Server
      if [ -f $ORA_HOME/bin/emctl ]; then
         su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start dbconsole"
      elif [ -f $ORA_HOME/bin/oemctl ]; then
         su - $ORA_OWNER -c "$ORA_HOME/bin/oemctl start oms"
      fi

      # Start HTTP Server
      if [ -f $ORA_HOME/Apache/Apache/bin/apachectl ]; then
         su - $ORA_OWNER -c "$ORA_HOME/Apache/Apache/bin/apachectl start"
      fi

      touch /var/lock/subsys/dbora
      ;;

   'stop')
      # Stop HTTP Server
      if [ -f $ORA_HOME/Apache/Apache/bin/apachectl ]; then
         su - $ORA_OWNER -c "$ORA_HOME/Apache/Apache/bin/apachectl stop"
      fi

      # Stop the TNS Listener
      su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"

      # Stop the Oracle databases:
      # The following command assumes that the oracle login
      # will not prompt the user for any values
      su - $ORA_OWNER -c $ORA_HOME/bin/dbshut

      rm -f /var/lock/subsys/dbora
      ;;
 esac

 # End of script dbora

 

3.设置脚本权限：

chmod 755 /etc/init.d/dbora
chown oracle:oinstall /etc/init.d/dbora

 

4.注册服务（Linux 6）

chkconfig --add dbora

 

4.注册服务（Linux 7）

vi /usr/lib/systemd/system/dbora.service
[Unit]
Description=Oracle Database Start/Stop Service
After=syslog.target network.target local-fs.target remote-fs.target
[Service]
# systemd, by design does not honor PAM limits
# See: https://bugzilla.redhat.com/show_bug.cgi?id=754285
LimitNOFILE=65536
LimitNPROC=16384
LimitSTACK=32M
LimitMEMLOCK=infinity
LimitCORE=infinity
LimitDATA=infinity

Type=simple
User=oracle
Group=oinstall
Restart=no
ExecStartPre=/bin/rm -rf /u01/app/oracle/product/11.2.0/db_1/listener.log
ExecStartPre=/bin/rm -rf /u01/app/oracle/product/11.2.0/db_1/startup.log
ExecStart=/bin/bash /u01/app/oracle/product/11.2.0/db_1/bin/dbstart /u01/app/oracle/product/11.2.0/db_1
RemainAfterExit=yes
ExecStop=/bin/rm -rf /u01/app/oracle/product/11.2.0/db_1/shutdown.log
ExecStop=/bin/bash /u01/app/oracle/product/11.2.0/db_1/bin/dbshut /u01/app/oracle/product/11.2.0/db_1
TimeoutStopSec=5min

[Install]
WantedBy=multi-user.target

 

 

重载并并设置自启动服务：

systemctl daemon-reload
systemctl enable dbora

 

 

参考文档

How to Automate Startup/Shutdown of Oracle Database on Linux (文档 ID 222813.1)

Automatic Stop of Database (dbshut) not working in OL 7 with systemd (文档 ID 2229679.1)