Saturday 4 March 2017

PRCD-1120 : The resource for database RAC could not be found.

:While trying to start  the Oracle database for the first time in Rac cluster (11gR2) getting below error.:


$ srvctl start database -d racdb
PRCD-1120 : The resource for database racdb could not be found.
PRCR-1001 : Resource ora.racdb.db does not exist

Cause: The database and its instance is not registered with CRS . 

Solution: Register the Database and instance in CRS . Follow the below steps to register with CRS

$ srvctl add database -d racdb -o /u01/app/oracle/product/11.2.0.4/dbhome_2
$ srvctl config database -d racdb
Database unique name: racdb
Database name:
Oracle home: /u01/app/oracle/product/11.2.0.4/dbhome_2
Oracle user: oracle
Spfile:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racdb
Database instances:
Disk Groups:
Mount point paths:
Services:
Type: RAC
Database is administrator managed

Now try to bring up the Database.

 $ srvctl start database -d racdb

PRKO-3119 : Database racdb cannot be started since it has no configured instances.

 $ srvctl add instance -d racdb -i racdb1 -n node1
 $ srvctl add instance -d racdb -i racdb2 -n node2

 $ srvctl config database -d racdb
Database unique name: racdb
Database name:
Oracle home: /u01/app/oracle/product/11.2.0.4/dbhome_2
Oracle user: oracle
Spfile:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racdb
Database instances: racdb1,racdb2
Disk Groups:
Mount point paths:
Services:
Type: RAC
Database is administrator managed

$ srvctl start database -d racdb

$ srvctl status database -d racdb

Instance racdb1 is running on node node1

Instance racdb2 is running on node node2