Wednesday 13 December 2023

Oracle 19C RAC Database stop and start Step By Step process

 

Dear All,


In this post i am going to show you how to start and stop Oracle 19c RAC Database services including cluster services .


Check the db and grid background process status from putty ( backend ) 

ps -ef |grep oracle / ps -fu $USER  >> this will show you the all the process which are running under specific login user .


ps -ef |grep grid

ps -ef |grep d.bin

ps -ef |grep smon




Check the DB and Oracle Instance status from SQL prompt : 


select name,open_mode,instance_name from v$database,v$instance;

 


 

 

 Stop the database :: 

 

srvctl stop database -d RACSDB -o immediate

srvctl stop database -d RACSDB

 



Start and stop individual Instances : 


srvctl start instance -d RACSDB -i racsdb1

srvctl start instance -d RACSDB -i racsdb2

 

srvctl stop instance -d RACSDB -i racsdb1

srvctl stop instance -d RACSDB -i racsdb2

 



 Start and stop the cluster services :


Note : login to root user and go the grid home/bin path and execute below commands 


##cluster status 

./crsctl check cluster -all

./crsctl stat res -t

./crsctl check crs







##stop the cluster services 

./crsctl stop crs






##start the cluster services 

./crsctl start crs

 


crsctl check cluster -all

crsctl start res ora.crsd -init

crsctl check crs

./crsctl stat res -t









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 software version

>>> Check Oracle Cluster ware Software Version


crsctl query crs 
active version

 >>> Check Oracle Cluster ware Active Version


crsctl query crs 
release version

>>> Check Oracle Cluster ware Release Version

 




 Thanks,

srini


No comments:

Post a Comment


No one has ever become poor by giving