Issue: srvctl commands and functionalities are not working in the RAC databases.
Error:
[oracle@host oracle] srvctl config database -d SID_NAMEPRCR-1119 : Failed to look up CRS resources of database type
PRKC-1137 : Unable to find Version object with string value 19.0.0.0.0
PRCR-1006 : Failed to add resource ora.SID_NAME.db for SID_NAME
PRCT-1011 : Failed to run “osdbagrp”. Detailed error:
This issue is happening after the GRID Home is upgraded to 19c. This is causing major slowdown while performing typical bounce and maintenance activities of the RAC instances.
The fix is to copy the osdbagrp file from grid home to database oracle home
. asm.env
cd $ORACLE_HOME/bin
ls -lrth osdbagrp*
Take a backup of osdbagrp file in the RDBMS_HOME/bin before it replaced.
cp osdbagrp $ORACLE_HOME
cd
. db_env_file
osdbagrp –a #### output should return oinstall
cd
clear
After it is working, use the following commands to register the db in the cluster
srvctl add database > -db SID_NAME > -dbname SID_NAME > -oraclehome path > -startoption OPEN > -stopoption > -policy AUTOMATIC > -iskgroup DATA_DBQA > -dbtype RAC
srvctl config database -d
srvctl config database -d SID_NAME
srvctl config database
srvctl add database -d SID_NAME -o $ORACLE_HOME path
srvctl config database
srvctl config database -d SID_NAME
srvctl add instance -d SID_NAME -i SID_NAME -n DB_HOSTNAME
srvctl status database -d SID_NAME
Crosscheck the SRVCTL is working or not by using below commands.
First shut down the db from sqlplus, then use srvctl commands to start and stop
Start using srvctl, stop using srvctl and again start using srvctl to make sure all the variations are working.
srvctl status database -d SID_NAME
srvctl stop database -d SID_NAME
srvctl start database -d SID_NAME
srvctl status database -d SID_NAME
