srvctl add database
Hey, I created an instance manually via init.ora file (without dbca) for a manual standby.
Now, I like to add this newly created database to the clusterressources ( installed GI 11.2.0.3) for oracle restart. (RDBMS 11.2.0.3)
Problem: While issuing the srvctl add database command, I am not able to specify my SID.
My SID is in uppercase ( STDBY) and the dbname is stdby
It will result in: Database instance: stdby whereby is should be Database instance: STDBY
srvctl add database -d stdby -o /srv/app/oracle/product/11.2.0/db_1 -n primary -p /srv/app/oracle/product/11.2.0/db_1/dbs/spfileSTDBY.ora -s MOUNT -r PHYSICAL_STANDBY -y AUTOMATIC -a "DATA,RECO"
srvctl config database -d stdby -a
Database unique name: stdby
Database name: primary
Oracle home: /srv/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: /srv/app/oracle/product/11.2.0/db_1/dbs/spfileSTDBY.ora
Domain:
Start options: mount
Stop options: immediate
Database role: PHYSICAL_STANDBY
Management policy: AUTOMATIC
Database instance: stdby
Disk Groups: DATA,RECO
Services:
Database is enabled
crsctl stat res ora.stdby.db
NAME=ora.stdby.db
TYPE=ora.database.type
TARGET=OFFLINE
STATE=OFFLINE
crsctl start res ora.stdby.db
CRS-2672: Attempting to start 'ora.stdby.db' on 'stdbynode'
CRS-5010: Update of configuration file "/srv/app/oracle/product/11.2.0/db_1/dbs/initstdby.ora" failed: details at "(:CLSN00014:)" in "/srv/app/11.2.0/grid/log/stdbynode/agent/ohasd/oraagent_grid/oraagent_grid.log"
CRS-5017: The resource action "ora.stdby.db start" encountered the following error:
CRS-5010: Update of configuration file "/srv/app/oracle/product/11.2.0/db_1/dbs/initstdby.ora" failed: details at "(:CLSN00014:)" in "/srv/app/11.2.0/grid/log/stdbynode/agent/ohasd/oraagent_grid/oraagent_grid.log"
. For details refer to "(:CLSN00107:)" in "/srv/app/11.2.0/grid/log/stdbynode/agent/ohasd/oraagent_grid/oraagent_grid.log".
CRS-2674: Start of 'ora.stdby.db' on 'stdbynode' failed
CRS-2679: Attempting to clean 'ora.stdby.db' on 'stdbynode'
CRS-2681: Clean of 'ora.stdby.db' on 'stdbynode' succeeded
CRS-4000: Command Start failed, or completed with errors.
crsctl stat res ora.stdby.db
NAME=ora.stdby.db
TYPE=ora.database.type
TARGET=ONLINE
STATE=OFFLINE