HPE Community
Operating System - Linux
1839837 Members
3083 Online
110156 Solutions
New Discussion

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

 
Amit_68
Occasional Contributor

‎04-07-2005 07:48 PM

‎04-07-2005 07:48 PM

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..
0 Kudos
Reply
3 REPLIES 3
Claudio Cilloni
Honored Contributor

‎04-07-2005 09:56 PM

‎04-07-2005 09:56 PM

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...
0 Kudos
Reply
Alexander M. Ermes
Honored Contributor

‎04-07-2005 09:57 PM

‎04-07-2005 09:57 PM

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"
0 Kudos
Reply
Eric van Dijken
Trusted Contributor

‎04-10-2005 06:51 PM

‎04-10-2005 06:51 PM

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.
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.