Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2004
    Posts
    60

    Unanswered: Database Shut Down information

    Hi All,

    Is there any way, by which I can find the terminal (machine address or OSuser), from where the database is shutdown.

    Looking at alert log, gives information about shutdown operation, but not the user or terminal that shut downed it.

    Please suggest where I can get that information?

    AD

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    You could create a "BEFORE SHUTDOWN" database event trigger.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Sep 2004
    Posts
    60
    Thanks LKBrwn for idea.

    But can you suggest any way for gathering same information, if no such trigger is in place? I am not sure, but any dB view/table or OS file should have such information.

    Regards
    AD

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    change remote_login_passwordfile to NONE
    then someone will call you asking why they cannot shut the database down.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    Maybe also a good idea would be to CHANGE the system passwords and REVOKE DBA (or SYSOPER) privileges to non dba accounts.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  6. #6
    Join Date
    Jan 2004
    Posts
    370
    Oracle provides an audit trail for connecting as sysdba (previously connect internal), startup, and shutdown.

    On Unix the files are kept in:

    $ORACLE_HOME/rdbms/audit

    (Have you never had to clear this directory out?)


    On Windows the audit is written to the Event Viewer

    HTH

Posting Permissions

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