:While trying to start the Oracle database for the first time in Rac cluster (11gR2) getting below error.:
$ srvctl start
database -d racdb
PRCD-1120 : The resource for database racdb could not be
found.
PRCR-1001 : Resource ora.racdb.db does not exist
Cause:
The database and its instance is not registered with CRS .
Solution: Register the Database and instance in CRS . Follow the below steps to register with CRS
$ srvctl add database -d racdb -o /u01/app/oracle/product/11.2.0.4/dbhome_2
$ srvctl add database -d racdb -o /u01/app/oracle/product/11.2.0.4/dbhome_2
$ srvctl
config database -d racdb
Database unique name: racdb
Database name:
Oracle home: /u01/app/oracle/product/11.2.0.4/dbhome_2
Oracle user: oracle
Spfile:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racdb
Database instances:
Disk Groups:
Mount point paths:
Services:
Type: RAC
Database is administrator managed
Now
try to bring up the Database.
$ srvctl start database -d racdb
PRKO-3119 : Database racdb cannot be started since it has no
configured instances.
$ srvctl add instance -d racdb -i
racdb1 -n node1
$ srvctl add instance -d racdb -i
racdb2 -n node2
$ srvctl config database -d racdb
Database unique name: racdb
Database name:
Oracle home: /u01/app/oracle/product/11.2.0.4/dbhome_2
Oracle user: oracle
Spfile:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racdb
Database instances: racdb1,racdb2
Disk Groups:
Mount point paths:
Services:
Type: RAC
Database is administrator managed
$ srvctl start database -d racdb
$ srvctl status database -d racdb
Instance racdb1 is running on node node1
Instance racdb2 is running on node node2