DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Can't bring up database!sculkget: failed to lock

  1. #1
    Join Date
    Jul 2005
    Posts
    87

    Can't bring up database!sculkget: failed to lock

    Hi,
    I am trying to bring up the db and its kind of hung ,on checking alert log its showing this error.Help me to resolve it.
    "sculkget: failed to lock /u01/app/oracle/product/10.2.0/db_1/dbs/lkinstMSBD1 exclusive"

    Thanks

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    You are probably getting an ORA-09968 error along side identifying the offending PID; the one holding the lock on your affected file.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Jul 2005
    Posts
    87
    This is part of alertlog ,i dont see ORA-09968 in it.

    Tue Aug 21 15:57:53 2007
    LMS 0: 0 GCS shadows traversed, 0 replayed
    Tue Aug 21 15:57:53 2007
    Submitted all GCS remote-cache requests
    Post SMON to start 1st pass IR
    Fix write in gcs resources
    Reconfiguration complete
    LCK0 started with pid=58, OS id=5979
    Tue Aug 21 16:00:02 2007
    sculkget: failed to lock /u01/app/oracle/product/10.2.0/db_1/dbs/lkinstMSBD1 exc
    lusive
    sculkget: lock held by PID: 4323
    Oracle Instance Shutdown operation failed. Another process may be attempting to
    startup or shutdown this Instance.
    Failed to acquire instance startup/shutdown serialization primitive
    Tue Aug 21 16:00:08 2007
    Shutting down instance (abort)
    License high water mark = 1
    Instance terminated by USER, pid = 10092

  4. #4
    Join Date
    Jul 2005
    Posts
    87
    oracle RAC 10202 runing on HP-UX 11.23v

  5. #5
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    sculkget: lock held by PID: 4323
    Oracle Instance Shutdown operation failed. Another process may be attempting to
    startup or shutdown this Instance.
    Failed to acquire instance startup/shutdown serialization primitive
    Are you working on different sessions?

    Lock held by 4323 has to be released.
    "What is past is PROLOGUE"

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    As pointed by dbasan you have to get rid of the lock held by PID 4323

    Can you identify PID 4323? what kind of process is it?

    Be sure everything is down, then try again.

    Did you said RAC? what's the status of the other node/s? Shouldn't you being using crs_stop to shutdown your instance?
    Last edited by PAVB; 08-21-2007 at 04:08 PM.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #7
    Join Date
    Jul 2005
    Posts
    87
    All the other instances in this cluster are running fine except the one that is down ,i tried to bring it up from different sessions.?grepping for the PID did't give anything ,how to find what is the process?

    crs_stat -t command sometimes just hangs and at times work and shows that the instances are up ,where as it is actually down
    Tried stopping the db with srvctl but its just hanging doing nothing.

    /bdump $ ps -ef|grep 4323
    oracle 14323 1 0 Aug 16 ? 0:00 oracleWxx2D1 (LOCAL=NO)
    oracle 3530 28173 0 20:03:18 pts/6 0:00 grep 4323
    Last edited by areeb; 08-21-2007 at 04:26 PM.

  8. #8
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Your ps -ef | grep 4323 is showing a different PID... 14323, pretty similar but not the one that was holding the lock.

    If you run crsstat.sh; what's the status of this database node (instance)?

    Could you share with us the command you are using to bring the instance back up?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  9. #9
    Join Date
    Jul 2005
    Posts
    87
    crs_stat -t command sometimes just hangs and at times work and shows that the instances are up ,where as it is actually down .
    Tried stopping the db with srvctl but its just hanging doing nothing.
    even check on crs is hanging.

    commands using
    $ORA_CRS_HOME/bin/crs_stat -t
    srvctl stop database -d dbname-as both instance are down
    pbrun crsctl check crs
    Last edited by areeb; 08-21-2007 at 04:32 PM.

  10. #10
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Tue Aug 21 16:00:08 2007
    Shutting down instance (abort)
    License high water mark = 1
    Instance terminated by USER, pid = 10092
    What's after the termination in the alert log?

    Instance is aborted by user 10092. But still you can see some oracle processes running. Check
    > ps -ef | grep ora
    > top -- to see if any oracle process is still running.

    Now you can delete the file /u01/app/oracle/product/10.2.0/db_1/dbs/lkinstMSBD1
    If no oracle process is running try to start the db by force -if still unsuccessfull then go for reboot server should be the final option as this would clear all the locks.
    "What is past is PROLOGUE"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width