Monday, August 14, 2017

ORA-09968 error when tried to start standby database



Issue :

Below error reported in alert log when tried to start physical standby database.


Error:

Tue Aug 13  03:33:12 2017
sculkget: failed to lock /vac/database/app/oracle/11.2.0.4/dbs/lkORCL exclusive
sculkget: lock held by PID: 21604
ORA-09968: unable to lock file
HPUX-ia64 Error: 13: Permission denied
Additional information: 21604
ORA-1102 signalled during: alter database mount standby database


Solution:

Remove 'lkORCL' file or rename it and restart the database.  It will automatically created when database restarts.

mv /vac/database/app/oracle/11.2.0.4/dbs/lkORCL lkORCL_old

Database started successfully after that.

Refer oracle metalink Doc ID 467251.1 for more information.

No comments:

Post a Comment

RMAN-06457

Issue : Rman active duplicate failed with below error. RMAN-00571: =========================================================== RMAN-...