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

Last updated on NOVEMBER 10, 2023

Applies to:

Purpose

This document aims to demonstrate the automatic startup and shutdown of Oracle databases on Linux.

Scope

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

Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.