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

  • by

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

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

Leave a Reply

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