How To Stop Service In One Node In Oracle Rac

STOP ORACLE RAC

1. emctl stop dbconsole

2. srvctl stop listener -north racnode1

three. srvctl stop database -d RACDB

iv. srvctl stop asm -due north racnode1 -f

5. srvctl terminate asm -northward racnode2 -f

half dozen. srvctl stop nodeapps -n racnode1 -f

7. crsctl stop crs

First ORACLE RAC

1. crsctl starting time crs

2. crsctl start res ora.crsd -init

iii. srvctl get-go nodeapps -due north racnode1

4. srvctl commencement nodeapps -n racnode2

v. srvctl get-go asm -due north racnode1

6. srvctl first asm -northward racnode2

7. srvctl start database -d RACDB

8. srvctl start listener -north racnode1

nine. emctl offset dbconsole

Terminate Oracle Real Application Clusters

1. Stop Oracle Dwelling LISTENER

[grid@racnode1 bin]$ srvctl stop listener -north racnode1

[grid@racnode1 bin]$ srvctl status listener -n racnode1
Listener LISTENER is enabled on node(south): racnode1
Listener LISTENER is not running on node(s): racnode1

2. Shutdown RAC Database Instances on all nodes

Syntax: srvctl finish database -d {databasename}

[oracle@racnode2 ~]$ srvctl status database -d racdb
Instance racdb1 is running on node racnode1
Instance racdb2 is running on node racnode2
[oracle@racnode2 ~]$ srvctl stop database -d racdb

[oracle@racnode2 ~]$ srvctl status database -d racdb
Instance racdb1 is not running on node racnode1
Instance racdb2 is not running on node racnode2

Execute ane command from any i of the server having database and information technology will terminate all database instances on all servers.

iii. Shutdown All ASM instances from all nodes

Syntax: srvctl stop asm -northward {node}

[grid@racnode2 oracle]# srvctl terminate asm -n racnode1 -f

[grid@racnode2 oracle]# srvctl stop asm -n racnode2 -f

Check Status

[grid@racnode2 oracle]# srvctl status asm -northward racnode1
ASM is non running on racnode1

[filigree@racnode2 oracle]# srvctl condition asm -n racnode2
ASM is not running on racnode2

Sometimes, nosotros may face up some problems in stopping ASM instance, In that case use "-f" selection to forcefully shutdown ASM instances.

4. Shutdown Node applications running on nodes

[grid@racnode2 oracle]# srvctl end nodeapps -n racnode1 -f

[grid@racnode2 oracle]# srvctl condition nodeapps -n racnode1
VIP racnode1-vip is enabled
VIP racnode1-vip is running on node: racnode1
Network is enabled
Network is running on node: racnode1
GSD is disabled
GSD is not running on node: racnode1
ONS is enabled
ONS daemon is running on node: racnode1

Echo aforementioned command for all nodes one by 1. If you face whatever upshot in stopping node applications utilise "-f" every bit force pick to end applications.

v. Shut downwards the Oracle Clusterware or CRS In this command all CRS related process will be stopped.
This needs to exist executed by "root" user on all database nodes.

[root@racnode1 bin]# crsctl cheque cluster -all

**************************************************************
racnode1:
CRS-4537: Cluster Gear up Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Managing director is online

*************************************************************
racnode2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Managing director is online
**************************************************************

[root@racnode1 bin]# crsctl stop crs

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resource on 'racnode1'
CRS-2673: Attempting to finish 'ora.crsd' on 'racnode1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'racnode1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'racnode1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'racnode1'
CRS-2673: Attempting to terminate 'ora.LISTENER_SCAN3.lsnr' on 'racnode1'
CRS-2673: Attempting to stop 'ora.racnode2.vip' on 'racnode1'
-------------------------------------------------
-------------------------------------------------
-------------------------------------------------
CRS-2677: Finish of 'ora.cssd' on 'racnode1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'racnode1'
CRS-2677: Cease of 'ora.gipcd' on 'racnode1' succeeded
CRS-2673: Attempting to terminate 'ora.gpnpd' on 'racnode1'
CRS-2677: Stop of 'ora.gpnpd' on 'racnode1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resource on 'racnode1' has completed
CRS-4133: Oracle High Availability Services has been stopped.

[root@racnode1 bin]# crsctl cheque cluster -all

CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Check failed, or completed with errors.

------------------------------------------------------------------------------------------------------------------------

Offset Oracle Real Application Clusters Database

1. First Oracle Clusterware or CRS: CRS starts automatically when you start or restart Server
This needs to be executed by "root" user on all nodes.

[root@racnode1 bin]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started
[root@racnode2 bin]# crsctl check cluster -all
**************************************************************
racnode1:
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Outcome Manager is online
**************************************************************

racnode2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Director is online
**************************************************************

If we meet "CRS-4639: Could not contact Oracle Loftier Availability Services" or "CRS-4535: Cannot communicate with Cluster Ready Services" messages. Wait v minutes and so over again check with "crsctl check cluster -all" command. This time Database ambassador will get "CRS-4537: Cluster Gear up Services is online". If still same issue DBA tin showtime ora.crsd process to resolve this issue. Below is the control

[root@racnode1 bin]# crsctl offset res ora.crsd -init

[root@racnode1 bin]# crsctl bank check cluster -all
**************************************************************
racnode1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Outcome Managing director is online
**************************************************************

racnode2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Issue Manager is online
**************************************************************

At present, Cluster is up and running. DBA tin can as well employ "ps -ef | grep d.bin" to cheque cluster status.

2. Start Node applications running on nodes

[filigree@racnode1 bin]$ srvctl beginning nodeapps -n racnode1

[filigree@racnode1 bin]$ srvctl status nodeapps -northward racnode1
VIP racnode1-vip is enabled
VIP racnode1-vip is running on node: racnode1
Network is enabled
Network is running on node: racnode1
GSD is disabled
GSD is not running on node: racnode1
ONS is enabled
ONS daemon is running on node: racnode1

Execute this command for each node to start RAC Cluster database.

iii. Outset All ASM instances from all nodes

[filigree@racnode1 bin]$ srvctl start asm -due north racnode1

[grid@racnode1 bin]$ srvctl status asm -n racnode1
ASM is running on racnode1

DBA has to beginning ASM case on all database nodes.

4. Start RAC Database Instances on all nodes

[filigree@racnode1 bin]$ srvctl start database -d racdb

[grid@racnode1 bin]$ srvctl status database -d racdb
Case racdb1 is running on node racnode1
Example racdb2 is running on node racnode2

Now database is upward and running on both DB nodes.

5. Beginning Oracle Domicile LISTENER

[filigree@racnode1 bin]$ srvctl start listener -due north racnode1

[grid@racnode1 bin]$ srvctl status listener -due north racnode1
Listener LISTENER is enabled on node(s): racnode1
Listener LISTENER is running on node(s): racnode1

Source: https://www.funoracleapps.com/2018/05/stopping-and-starting-rac-services.html

Posted by: kingmempity1975.blogspot.com