Useful Oracle 19c RAC Commands

Oracle oracle 19c rac commands, oracle 19c rac crsctl commands, oracle 19c rac srvctl commands, oracle 19c rac start sequence, oracle 19c rac stop sequence, oracle 19c rac stop/start one node

WHAT IS THE DIFFERENCE BETWEEN SRVCTL AND CRSCTL?

SERVER CONTROL UTILITY (SRVCTL)

Server Control Utility (SRVCTL): It is used to administer Oracle Real Application Clusters (Oracle RAC) databases and instances.

Use SRVCTL to manage Oracle supplied resources such as:

• Database
• Listener
• Instances
• Disk groups
• Networks

If resource name begins with ora then use SRVCTL. Oracle suggest DBAs to use srvctl command to stop/start the databases.

We can use the SRVCTL to manage configuration information.  Use SRVCTL commands to add, remove, start, stop, modify, enable, and disable a number of entities, such as Databases, instances, listeners, SCAN listeners, services, grid naming Service (GNS), and Oracle ASM.

CLUSTERWARE CONTROL UTILITY (CRSCTL)

Clusterware Control Utility (CRSCTL): It is used to managed oracle clusterware resources and components.

Use CRSCTL for managing Oracle Clusterware and its resources. CRSCTL command is used to manage the elements of the clusterware like crs, css, evm.

CRSCTL manages Oracle Clusterware related operations like:

• Starting and stopping Oracle Clusterware
• Enabling and disabling Oracle Clusterware daemons
• Checking the health of the cluster
• Registering cluster resources

SERVER CONTROL UTILITY (SRVCTL) – DATABASE RELATED COMMANDS

srvctl -help >>> List All Commands With Syntax

srvctl status listener -n node1 >>> Check Listener Status Of Specific Node
srvctl status listener >>> Check Listener Status Of All Nodes

srvctl start listener -n node1 >>> Start Listener On Specific Node
srvctl start listener >>> Start Listener On All Nodes

srvctl stop listener -n node1 >>> Stop Listener On Specific Node
srvctl stop listener >>> Stop Listener On All Nodes

srvctl status instance -d TEST -i TEST1 >>> Check Status Of Specific Instance
srvctl status database -d TEST >>> Check Status Of All Instances

srvctl start instance -d TEST -i TEST1 >>> Starts Specific Instance
srvctl start database -d TEST >>> Starts All Instances (+Open Database)

srvctl start database -d TEST -o nomount >>> Starts Service As Nomount
srvctl start database -d TEST -o mount >>> Starts Service As Mount
srvctl start database -d TEST -o open >>> Starts Service As Open

srvctl stop instance -d TEST -i TEST1 >>> Stops Specific Instance
srvctl stop database -d TEST >>> Stops All Instances (+Shutdown Database)

srvctl stop database -d TEST -o normal >>> Stops Service As Normal
srvctl stop database -d TEST -o immediate >>> Stops Service As Immediate
srvctl stop database -d TEST -o transactional >>> Stops Service As Transactional
srvctl stop database -d TEST -o abort >>> Stops Service As Abort

srvctl config database >>> Check Registered Databases In The Repository
srvctl config database -d TEST >>> Check Specific Database Configuration

CLUSTERWARE CONTROL UTILITY (CRSCTL) – CLUSTER RELATED COMMANDS

crsctl config has >>> Check Oracle HAS (High Availabilty Services) Config
crsctl disable has >>> Disable Automatic Startup Of The Oracle High Availability Services
crsctl enable has >>> Enable Automatic Startup Of The Oracle High Availability Services

crsctl check crs >>> Check Oracle High Availability Services On The Local Server.
crsctl stop crs >>> Stop Oracle High Availability Services On The Local Server.
crsctl start crs >>> Start Oracle High Availability Services On The Local Server.

crsctl query crs softwareversion >>> Check Oracle Clusterware Software Version
crsctl query crs activeversion >>> Check Oracle Clusterware Acitve Version
crsctl query crs releaseversion >>> Check Oracle Clusterware Release Version

OTHER USEFUL COMMANDS

show parameter CLUSTER_DATABASE; >>> Check Database Running As Cluster Or Not.

 

select instance_name, host_name, archiver, thread#, status from gv$instance; >>> Check RAC Status.

SHUTDOWN SEQUENCE OF ONLY ONE NODE IN A CLUSTER

Check Database And ASM Instance
[root@node1 ~]# ps -ef | grep pmon | grep -v grep
grid 9901 1 0 Sept10 ? 00:00:04 asm_pmon_+ASM1
oracle 16761 1 0 03:00 ? 00:00:00 ora_pmon_TEST1
[root@node1 ~]#

Check And Stop Instance
[root@node1 ~]# srvctl status instance -d TEST -i TEST1
[root@node1 ~]# srvctl stop instance -d TEST -i TEST1
[root@node1 ~]# srvctl status instance -d TEST -i TEST1

Check And Stop Oracle High Availability Services On The Local Server
[root@node1 ~]# crsctl check crs
[root@node1 ~]# crsctl stop crs
[root@node1 ~]# crsctl check crs

Check Database And ASM Instance
[root@node1 ~]# ps -ef | grep pmon | grep -v grep
[root@node1 ~]#

STARTUP SEQUENCE OF ONLY ONE NODE IN A CLUSTER

Check And Scan ASM Discs
[root@node1 ~]# ll /dev/oracleasm/disks/
[root@node1 ~]# oracleasm scandisks
[root@node1 ~]# ll /dev/oracleasm/disks/

Check And Start Oracle High Availability Services On The Local Server
[root@node1 ~]# crsctl check crs
[root@node1 ~]# crsctl start crs
[root@node1 ~]# crsctl check crs

Check And Start Instance
[root@node1 ~]# srvctl status instance -d TEST -i TEST1
[root@node1 ~]# srvctl start instance -d TEST -i TEST1
[root@node1 ~]# srvctl status instance -d TEST -i TEST1

Check Database And ASM Instance
[root@node1 ~]# ps -ef | grep pmon | grep -v grep
grid 9522 1 0 Aug 10 ? 00:00:03 asm_pmon_+ASM1
oracle 12756 1 0 08:00 ? 00:00:00 ora_pmon_TEST1

[root@node1 ~]#