Wednesday, December 27, 2017

How to Start Oracle RAC Database

In Starting Real Application Clusters Database, We will also follow a set of sequence. The order will be just opposite to Shutting down the Real Application Clusters Database. Here we are following all such sequences because we stopped databases, node-apps and other processes manually before stopping CRS. CRS can re-start resources which were up while it was going down.

1. Start Oracle Clusterware and ASM.
2. Start Node applications running on nodes.
3. Start RAC Database Instances on all nodes.
4. Start Oracle Home process accessing database.

1. Start Oracle Clusterware and ASM: 
If Oracle HAS auto-start was not disabled before restarting server, CRS starts automatically. However if auto-start is disabled you need to execute crsctl start crs command to start CRS and ASM. In mine case auto-start is enabled so I just verified the status.
[root@rac121 ~]# crsctl config crs
CRS-4622: Oracle High Availability Services autostart is enabled.

[root@rac121 ~]# crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

[root@rac121 ~]# crsctl check cluster -all
**************************************************************
rac121:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
rac122:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************

2. Start Node applications running on nodes:
To start node applications running on a node, enter the following command for each nodes.
[oracle@rac121 ~]$ srvctl status nodeapps
VIP rac121-vip.localdomain is enabled
VIP rac121-vip.localdomain is not running
VIP rac122-vip.localdomain is enabled
VIP rac122-vip.localdomain is not running
Network is enabled
Network is running on node: rac121
Network is running on node: rac122
ONS is enabled
ONS daemon is running on node: rac121
ONS daemon is running on node: rac122

[oracle@rac121 ~]$ srvctl start nodeapps -n rac121
PRKO-2421 : Network resource is already started on node(s): rac121,rac122
PRKO-2422 : ONS is already started on node(s): rac121,rac122

[oracle@rac121 ~]$ srvctl start nodeapps -n rac122
PRKO-2421 : Network resource is already started on node(s): rac121,rac122
PRKO-2422 : ONS is already started on node(s): rac121,rac122

[oracle@rac121 ~]$ srvctl status nodeapps
VIP rac121-vip.localdomain is enabled
VIP rac121-vip.localdomain is running on node: rac121
VIP rac122-vip.localdomain is enabled
VIP rac122-vip.localdomain is running on node: rac122
Network is enabled
Network is running on node: rac121
Network is running on node: rac122
ONS is enabled
ONS daemon is running on node: rac121
ONS daemon is running on node: rac122



3. Start RAC Database Instances on all nodes:-
Now, We will start database instances on database nodes.
[oracle@rac121 ~]$ srvctl start database -d racdb
[oracle@rac121 ~]$ srvctl status database -d racdb
Instance racdb1 is running on node rac121
Instance racdb2 is running on node rac122

4.Start Oracle Home process accessing database:-
let's start listener and OEM to access database and allow users to connect to the database.
[oracle@rac121 ~]$ srvctl start listener -n rac121
[oracle@rac121 ~]$ srvctl start listener -n rac122
[oracle@rac121 ~]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): rac121,rac122

[oracle@database ~]$ emctl start dbconsole
. started.

Verify Status
Now we can use below commands to verify status of cluster and services.
[oracle@rac121 ~]$ cd grid_home/bin
[oracle@rac121 ~]$ crsctl status resource -t
[oracle@rac121 ~]$ crsctl check crs
[oracle@rac121 ~]$ crsctl check cluster -all

Related Links
How to Stop Processes in Oracle RAC

No comments:

Post a Comment