Need help on ORA-09968:
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Need help on ORA-09968:

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586

    Question Need help on ORA-09968:

    I just started getting this error message. Nothing has changed.
    hpux 11i w/8.1.6 64-bit.

    any ideas?

    ALTER DATABASE MOUNT
    Mon Dec 2 02:22:10 2002
    scumnt: failed to lock /u01/apps/oracle/product/8.1.6saidev/dbs/lkINFADEV exclusive
    Mon Dec 2 02:22:10 2002
    ORA-09968: scumnt: unable to lock file
    HP-UX Error: 13: Permission denied
    Mon Dec 2 02:22:10 2002
    ORA-1102 signalled during: ALTER DATABASE MOUNT...

    -Jigar
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    133
    You will need to re-create the control file again to solve this issue.
    Giani

  3. #3
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    whast the reason? I know about recreating the control file but why? Nothing has changed. No database files have been moved?
    "High Salaries = Happiness = Project Success."

  4. #4
    Join Date
    Mar 2001
    Posts
    144

  5. #5
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Ramaral.
    thanks for the note: but I have already traveled that path and I couldnt get any more info the I already know. I have not moved the Oracle home. Nothing has happened to this instance. All dbf/ctrl/rdo files are where they were when this db was created.

    Jigar
    "High Salaries = Happiness = Project Success."

  6. #6
    Join Date
    Mar 2001
    Posts
    144
    It's a zombie process on the machine that's causing your problem. Moving/renaming the files is not the issue. The OS is just not letting go of that file when the database shuts down. It's just a zombie process that refuses to be killed when the database shuts down and nothing that you or Oracle has done to cause it.

    If you're asking about it being a regular occurence then your guess is as good as any one elses.
    Last edited by ramaral; 12-03-2002 at 12:14 PM.

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