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

oracle@node1 dbs]$ srvctl status database -d racdb

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

PRCR-1001 : Resource ora.racdb.db does not exist

STEP 1:

oracle@node1 dbs]$ srvctl add database -d racdb -o /u01/app/oracle/product/11.2.0.4/dbhome_2

oracle@node1 dbs]$ 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

STEP 2:

[oracle@node1 dbs]$ srvctl start database -d racdb

PRKO-3119 : Database racdb cannot be started since it has no configured instances.

[oracle@node1 dbs]$ srvctl add instance -d racdb -i racdb1 -n node1

[oracle@node1 dbs]$ srvctl add instance -d racdb -i racdb2 -n node2

[oracle@node1 dbs]$ srvctl config database -d racdb

STEP 3:

[oracle@node1 dbs]$ srvctl start database -d racdb

[oracle@node1 dbs]$ srvctl status database -d racdb

Instance racdb1 is running on node node1

Instance racdb2 is running on node node2

STEP 4:

we need to create spfile

SYS@racdb1> create spfile='+DATA' from pfile='/u01/app/oracle/product/11.2.0.4/dbhome_2/dbs/initracdb1.ora';

File created.

ASMCMD> pwd

+data/racdb/parameterfile

ASMCMD> ls

spfile.280.848177711

ASMCMD> mkalias +data/racdb/parameterfile/spfile.280.848177711 spfileracdb.ora

STEP 5:

[oracle@node1 dbs]$ srvctl modify database -d racdb -p +data/racdb/spfileracdb.ora

[oracle@node1 dbs]$ srvctl config database -d racdb

SYS@racdb1> show parameter spfile

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

spfile string +DATA/racdb/spfileracdb.ora