Database shutdown
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Database shutdown

  1. #1
    Join Date
    Apr 2001
    Posts
    46

    Angry

    Hi!

    My production database was shutting down on ABORT
    But I don't known who did it.

    How can I know, who is connected to the database before the database was shutting down.

    Is there a trace of the listener.

    Thank you for answering.


  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Why are you shutting down production Serverusing ABORT option?
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    Apr 2001
    Posts
    46
    I didn't shut down the database myself.

    Someone did it, but I don't know who did it.

    In alert log, I 've just know when the database was shutting
    down on ABORT.
    So I would like to know who was connected to database
    with SVRMGRL.

    I've heard that it is possible to know who was connected to the database with the trace of the LISTENER, but I don't know more.

    If someone have a little idea, can he ou she suggest me
    where can I investigate ?

    Thanks
    yt

  4. #4
    Join Date
    Feb 2001
    Posts
    203
    First Check which users have the Privileges(SYS AND SYSTEM).
    sree

  5. #5
    Join Date
    Apr 2001
    Posts
    46
    I know who have got the privilege SYS and SYSTEM

    But I need proof to be sur that it was him
    yt

  6. #6
    Join Date
    Jun 2001
    Posts
    33
    $ORACLE_HOME/network/log/listener_name.log

    u can find in that file all connection time and client IP ...
    just got to find the last connection before shutdown
    hope that will help

    Armel

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