topic Re: Where can I find Dbshut Log? and how can i delete it? in Operating System - Linux

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

Amit_68 — Fri, 08 Apr 2005 02:48:28 GMT

Friends,
one of my employee shutdown the oracle db so where can i get that log to find out person who shutdown the db..

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

Claudio Cilloni — Fri, 08 Apr 2005 04:56:45 GMT

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...

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

Alexander M. Ermes — Fri, 08 Apr 2005 04:57:28 GMT

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

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

Eric van Dijken — Mon, 11 Apr 2005 01:51:32 GMT

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?