[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
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