alter database mount hangs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: alter database mount hangs

  1. #1
    Join Date
    May 2002
    Posts
    1
    hello,

    i'm running oracle 8.0.5 on solaris 7.

    i had previously tried shutting down oracle with
    the svrmgrl command, issuing the "shutdown" command,
    which halted after "Alter database dismount..."

    after waiting several 10's of minutes, i issued a "shutdown
    abort" via another svrmgrl session.

    Now, when I try to "startup", it hangs after saying:

    "Redo Buffers 81920 bytes"

    there are no error messages via the terminal, or the
    "alert... .log" file. Indeed, the alert.log file stops
    with "alter database mount".

    It hangs at this point indefinitely, and the only way I can
    get out of it is to issue another "shutdown abort" from another
    svrmgrl session.

    Does anyone know what could be causing this?

    thanks in advance,
    -tim


  2. #2
    Join Date
    May 2002
    Posts
    42
    I have waited 15 min for oracle to startup in the past. Make sure your CPU usage is not being maxed out by other processes.

    You did a shutdown abort so now oracle has to recover the database. give it some time. you can test using the "truss" command on solaris. truss will show you all the system calls oracle is doing. it may show you what it is hanging up on. (it is pretty ugly though)

  3. #3
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    Check how much amount of space you are trying to allocate for SGA and how much amount
    of memory is available in your RAM.
    Also check whether LOCK_SGA parameter value is set.

    Vijay.
    Say No To Plastics

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