Skip to content
Home » Oracle Database » How to Resolve PRCD-1120 : The resource for database could not be found.

How to Resolve PRCD-1120 : The resource for database could not be found.

PRCD-1120

PRCD-1120 means that the database you want to operate with is not found in the cluster. Mostly, you misspelled the resource name of database.

[oracle@primary01 oracle]$ srvctl status database -d orclkdb
PRCD-1120 : The resource for database orclkdb could not be found.
PRCR-1001 : Resource ora.orclkdb.db does not exist
[oracle@primary01 oracle]$ srvctl config database -d orclkdb
PRCD-1120 : The resource for database orclkdb could not be found.
PRCR-1001 : Resource ora.orclkdb.db does not exist

Possibly, you could have removed the resource (e.g. MGMTDB) from the cluster and you don't remember.

Solution

You may use the following command to check what database we have in this cluster.

[oracle@primary01 oracle]$ srvctl config database
CATDB
ORCLCDB

As you can see, there're two resources (databases) in this cluster and we misspelled the second database name in the first place.

[oracle@primary01 oracle]$ srvctl status database -d orclcdb
Instance ORCLCDB1 is running on node primary01
Instance ORCLCDB2 is running on node primary02

We solved error PRCD-1120.

If you didn't find the right database you want, you can use srvctl add database to register it with the cluster, there're several steps to be done.

2 thoughts on “How to Resolve PRCD-1120 : The resource for database could not be found.”

Leave a Reply

Your email address will not be published. Required fields are marked *