Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

In my oracle database alert log file, I saw someone issued the command to shutdown oracle database. I am not able to find out what caused this. Is there a way to find out which user/program that issued the command?

Fri Feb 1 22:30:35 2013 Completed: alter database close Fri Feb 1 22:30:35 2013 alter database dismount Completed: alter database dismount

share|improve this question
add comment

1 Answer 1

The details should be available in audit files located by default in $ORACLE_BASE/admin/$ORACLE_SID/adump -directory or wherever your AUDIT_FILE_DEST-parameter points them to.

Look for more information for example from here: http://docs.oracle.com/cd/B28359_01/network.111/b28531/auditing.htm#CEGJADDC

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.