Operating System - Linux
1829054 Members
2935 Online
109986 Solutions
New Discussion

Re: Where can I find Dbshut Log? and how can i delete it?

 
Amit_68
Occasional Contributor

Where can I find Dbshut Log? and how can i delete it?

Friends,
one of my employee shutdown the oracle db so where can i get that log to find out person who shutdown the db..
3 REPLIES 3
Claudio Cilloni
Honored Contributor

Re: Where can I find Dbshut Log? and how can i delete it?

As far as I know the dbshut command produces no logs.
Usually the dbshut command is executed by the oracle user; maybe you can watch the system logs to find who logged in as oracle user immediately before the database shutdown.

Ciao
Claudio

P.S.: ... hope you won't fire him...
Alexander M. Ermes
Honored Contributor

Re: Where can I find Dbshut Log? and how can i delete it?

Hi there.
Find outfrom which terminal oracle has been logged in( btmp / wtmp /utmp ). Then check the alertlog file of oracle for the time. In the sulog you can see, whether oracle has been logged in with 'su '.
Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Eric van Dijken
Trusted Contributor

Re: Where can I find Dbshut Log? and how can i delete it?

Silly question,

If you want to find out how did it, why would you want to delete the log file?

Don't you need proof?

Watch, Think and Tinker.