Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    1

    Unanswered: Cannot start Oracle - ora 01081

    Hi,

    I am working with an Oracle 8i database. I logged to the Oracle Enterprise Manager as sysdba and shut down the database in the normal mode. But it is taking a lot of time and the OEM session also got hung. Now I cannot log on to the database, it says that it is shutting down (ORA-01081). I tried to start it again but I get the same message.

    I am not sure what users are still logged on to the database. There is an application which runs on the database and it may have open hung sessions in it.

    Please let me know what is the solution.

    Thanks,

    Onomitra
    Last edited by onomitra; 04-22-04 at 03:13.

  2. #2
    Join Date
    Apr 2004
    Posts
    1

    Post

    Hi,

    try this.

    1) Close or Kill all Oracle application (sql plus, OEM, Application)

    2) Try to start OEM and shutdown your DB with option "ABORT".
    Or with instance manager: "shutdown abort"

    3) Startup your DB. This can take serval times...
    (with OEM or instance manager)

    Attentention: I am a newbie, but i had the same problem :-)

    Greetings,

    jedi

  3. #3
    Join Date
    Apr 2004
    Posts
    9
    You can use Shut down Abort,
    but this is not recommended, Oracle, may need to recover the database on startup.

    It is possible a session holding on to the database.

Posting Permissions

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