How to Automate Startup/Shutdown of Oracle Database on Linux
(Doc ID 222813.1)
Last updated on APRIL 21, 2020
Applies to:Oracle Database - Standard Edition - Version 188.8.131.52 to 184.108.40.206 [Release 12.1]
Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
This document applies to:
SLES7, SLES8, SLES9, SLES10
RHAS 2.1, RHEL 3,4,5,6 OL 4,5,6
This document aims to demonstrate automatic startup and shutdown of Oracle databases on Linux.
The information in this document is useful for system administrators and database administrators trying to automate Oracle database startup and shutdown. The document describes the detailed steps for configuration on Red Hat Advanced Server 2.1, RedHat Enterprise Linux (RHEL) 3,4,5,6 SuSE SLES7, United Linux 1.0 (SuSE SLES8 Edition), SLES9, SLES10, Oracle Linux (OL) 4,5,6. The information may not apply to other Linux distributions. The main solution does not work on OL7. References provided at the end for Oracle Linux 7 and later.
The following configuration is done to allow Oracle database be up and running in runlevels 3 (character mode) and 5 (X-Window system) and the start / stop commands does not provide the exhaustive list of all possibilities and it presents an example. Therefore the exact scripts may not work with your configuration
Since the configuration is based on dbstart and dbshut scripts provided by the Oracle Server installation, please see <Note 207508.1>
The configuration also facilitates automated startup shutdown of Intelligent Agent, Management Server and HTTP Server, which are available with Oracle Server.
The information in this document does not apply to Oracle Internet Application Server. Still the script can be configured to handle starting up and shutting down iAS processes.
As per Note:105957.1 and Note 1397813.1,
When using an 11.2 ASM or CRS managed database (using the 11.2 Grid Infrastructure), the startup/shutdown script may no longer be used. CRS manages automatic restarts/startups for RAC and single instance databases are managed with Oracle Restart. See the following for more information:
- <Document 105957.1> How to setup Oracle to startup automatically if the system is restarted
- <Document 1397813.1> Oratab - # Line Added By Agent
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Oracle Linux 7 and later|