You can start and stop instances with Oracle Enterprise Manager, SQL*Plus or SRVCTL as described in the following sections. Both Oracle Enterprise Manager and SRVCTL provide options to start and stop all of the instances in an Oracle RAC database with a single step.
Using any tool, you can choose the startup state to which you want to start the database. The state of the database and database instance will determine what operations you can perform. You can perform certain operations only when the database is in the MOUNT (NOMOUNT) state. Performing other operations requires that the database be in the OPEN state.
Note:
Oracle does not support running more than one instance of the same database on the same node.
To start an Oracle RAC database instance on a node in the cluster, you must first start the Oracle Grid Infrastructure stack on the node. An Oracle RAC database instance will not start on a server on which the Oracle Grid Infrastructure stack is not running.
Oracle Database QoS Management Policy Workload Criticality Determines Database Startup Order
If a user-created Oracle Database Quality of Service Management (Oracle Database QoS Management) policy is active, then the ranked order of the performance classes determines the order in which the associated Oracle RAC databases start or request real-time LMS process slots. Using the performance class rankings ensures that mission-critical databases running in a consolidated environment have their LMS processes run in real time, thus eliminating a resource bottleneck within inter-node communication. Because the Oracle Database QoS Management policy specifies the rank of each workload, using the value of Max(Ranks) for each database provides a consistent expression of the expressed business criticality of each database.
The procedures in the following sections discuss starting and stopping Oracle RAC database instances:
Starting One or More Instances and Oracle RAC Databases Using SRVCTL
Stopping One or More Instances and Oracle RAC Databases Using SRVCTL
See Also:
Oracle Database Concepts for more information about database and instance startup states
Oracle Database 2 Day + Real Application Clusters Guide for step-by-step instructions on using Oracle Enterprise Manager to start or stop a cluster database instance or a cluster database.