Wednesday, March 13, 2013

PRCR-1079 : Failed to start resource ora.sapccstandby.db


After duplicating database to a standby database, when trying to start standby database using srvctl utility following errors might appear:

[oracle@oracle-node-dr ~]$ srvctl start database -d sapdbstandby
PRCR-1079 : Failed to start resource ora.sapdbstandby.db
CRS-5010: Update of configuration file "/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initsapdbstandby.ora" failed: details at "(:CLSN00014:)" in "/u01/app/11.2.0/grid/log/oracle-node-dr/agent/ohasd/oraagent_grid/oraagent_grid.log"
CRS-5017: The resource action "ora.sapdbstandby.db start" encountered the following error:
CRS-5010: Update of configuration file "/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initsapdbstandby.ora" failed: details at "(:CLSN00014:)" in "/u01/app/11.2.0/grid/log/oracle-node-dr/agent/ohasd/oraagent_grid/oraagent_grid.log"
. For details refer to "(:CLSN00107:)" in "/u01/app/11.2.0/grid/log/oracle-node-dr/agent/ohasd/oraagent_grid/oraagent_grid.log".

CRS-2674: Start of 'ora.sapdbstandby.db' on 'oracle-node-dr' failed

Workaround

Change permissions on initsapdbstandby.ora

[oracle@oracle-node-dr dbhome_1]$ cd $ORACLE_HOME
[oracle@oracle-node-dr dbhome_1]$ chmod 775 dbs
[oracle@oracle-node-dr dbhome_1]$ cd dbs
[oracle@oracle-node-dr dbs]$ chmod 775 initsapdbstandby.ora

Start database resource:

[oracle@oracle-node-dr ~]$ srvctl start database -d sapdbstandby

Check available resources:

[grid@oracle-node-dr ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       oracle-node-dr
ora.FRA.dg
               ONLINE  ONLINE       oracle-node-dr
ora.LISTENER.lsnr
               ONLINE  ONLINE       oracle-node-dr
ora.asm
               ONLINE  ONLINE       oracle-node-dr           Started
ora.ons
               OFFLINE OFFLINE      oracle-node-dr
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       oracle-node-dr
ora.diskmon
      1        OFFLINE OFFLINE
ora.evmd
      1        ONLINE  ONLINE       oracle-node-dr
ora.sapdbstandby.db
      1        ONLINE  INTERMEDIATE oracle-node-dr           Mounted (Closed)
[grid@oracle-node-dr ~]$

No comments:

Post a Comment