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

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

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

[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

Startování z 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
ASMCMD> ls -lt
Type Redund Striped Time Sys Name
 Y TEMPFILE/
 Y PARAMETERFILE/
 Y DATAFILE/
 N spfileracdb.ora => +DATA/racdb/PARAMETERFILE/spfile.280.848177711

[oracle@node1 dbs]$ srvctl modify database -d racdb -p +data/racdb/spfileracdb.ora
[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
Spfile: +data/racdb/spfileracdb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racdb
Database instances: racdb1,racdb2
Disk Groups: REDO,DATA
Mount point paths:
Services:
Type: RAC
Database is administrator managed

SYS@racdb1> show parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/racdb/spfileracdb.ora

Komentáře