Saturday, May 30, 2015

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

[oracle@OEL5RACN1 ~]$ srvctl status database -d RACDB -v
PRCD-1120 : The resource for database RACDB could not be found.
PRCR-1001 : Resource ora.rac.db does not exist

This is indicate that Database are not registered in OCR.

Solution : Register database into OCR  (database and instances).

[grid@OEL5RACN1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA_01.dg
               ONLINE  ONLINE       oel5racn1
               ONLINE  ONLINE       oel5racn2
ora.FRA_01.dg
               ONLINE  ONLINE       oel5racn1
               ONLINE  ONLINE       oel5racn2
ora.LISTENER.lsnr
               ONLINE  ONLINE       oel5racn1
               ONLINE  ONLINE       oel5racn2
ora.OCRS_FILES.dg
               ONLINE  ONLINE       oel5racn1
               ONLINE  ONLINE       oel5racn2
ora.asm
               ONLINE  ONLINE       oel5racn1                Started
               ONLINE  ONLINE       oel5racn2                Started
ora.eons
               ONLINE  ONLINE       oel5racn1
               ONLINE  ONLINE       oel5racn2
ora.gsd
               OFFLINE OFFLINE      oel5racn1
               OFFLINE OFFLINE      oel5racn2
ora.net1.network
               ONLINE  ONLINE       oel5racn1
               ONLINE  ONLINE       oel5racn2
ora.ons
               ONLINE  ONLINE       oel5racn1
               ONLINE  ONLINE       oel5racn2
ora.registry.acfs
               ONLINE  ONLINE       oel5racn1
               ONLINE  ONLINE       oel5racn2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       oel5racn1
ora.oc4j
      1        OFFLINE OFFLINE
ora.oel5racn1.vip
      1        ONLINE  ONLINE       oel5racn1
ora.oel5racn2.vip
      1        ONLINE  ONLINE       oel5racn2
ora.racdb.db
      1        OFFLINE OFFLINE
      2        OFFLINE OFFLINE
ora.scan1.vip
      1        ONLINE  ONLINE       oel5racn1
[grid@OEL5RACN1 ~]$
[oracle@OEL5RACN1 ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/db_1
[oracle@OEL5RACN1 ~]$ srvctl add database -d RACDB1 -o /u01/app/oracle/product/11.2.0/db_1
[oracle@OEL5RACN1 ~]$ srvctl start database -d RACDB1
Database RACDB1 cannot be started since it has no configured instances.
[oracle@OEL5RACN1 ~]$ srvctl config database -d RACDB1
Database unique name: RACDB1
Database name:
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: RACDB1
Database instances:
Disk Groups:
Services:
Database is administrator managed
[oracle@OEL5RACN1 ~]$ srvctl start database -d RACDB
[oracle@OEL5RACN1 ~]$ srvctl status database -d RACDB
Instance RACDB1 is running on node oel5racn1
Instance RACDB2 is running on node oel5racn2
[oracle@OEL5RACN1 ~]$

[Note : If your instance are not added you also need to add instance into CRS the following way ]
[oracle@OEL5RACN1 ~]$ srvctl add instance -d RACDB -i RACDB1 -n OEL5RACN1

No comments:

Post a Comment