How to Fix the error PRCD-1120: The resource for RAC Database could not be found

How to Fix the error PRCD-1120: The resource for RAC Database could not be found

This procedure includes Oracle Database 11g,12c, 18c and 19c Real Application Cluster.

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

[oracle@node01 ~]$ srvctl status database -d DB01

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

PRCR-1001: Resource ora.DB01.db does not exist

 

Cause: This error indicates that the database is not registered in OCR.

Solution: Register the Database into OCR including the Instance.

 

1-     Add the Database

 

[oracle@node01 ~]$ echo $ORACLE_HOME

/u01/app/oracle/product/11.2.0.4/db_1

[oracle@node01 ~]$ srvctl add database -d DB01 -o /u01/app/oracle/product/11.2.0.4/db_1/

 

2-     Configure the Database

 

[oracle@node01 ~]$ srvctl config database -d DB01

Database unique name: DB01

Database name:

Oracle home: /u01/app/oracle/product/11.2.0.4/db_1/

Oracle user: oracle

Spfile:

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: DB01

Database instances:

Disk Groups:

Mount point paths:

Services:

Type: RAC

Database is administrator managed

 

3-     Add the instances (For All nodes)

[oracle@node01 ~]$ srvctl add instance -d DB01 -i DB011 -n node01

[oracle@node01 ~]$

 

[oracle@node02 dbs]$ srvctl add instance -d DB01 -i DB012 -n node02

[oracle@node02 dbs]$

 

 

4-     Check and Start Database Services

 

[oracle@node01 ~]$ srvctl status database -d DB01

Instance DB011 is not running on node node01

Instance DB012 is not running on node node02

[oracle@node01 ~]$

 

[oracle@node01 ~]$ srvctl start database -d DB01

[oracle@node01 ~]$

 [oracle@node01 ~]$ srvctl status database -d DB01

Instance DB011 is running on node node01

Instance DB012 is running on node node02