| Alert Log file [message #172141] |
Mon, 15 May 2006 02:53  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
I've scheduled a scripts which executes daily automatically,connects to the database and collects the details about database & finally generate a spool file daily.It generated spool file successfully for every day,but on 14-May-2006,for each & every query contained in the script,the spool file contains the following error "sp-0640 Not connected".
I thought that the database may be shutdowned by someone,so i tried to check the alert.log file,but for the date 14-May-2006,it doesn't contain any info about shutdown & startup of the database.
1) What could be the reason for this,why it's not recorded in alert.log?
2) Or in anyother file,can i find the details about database activity on 14-May-2006?
|
|
|
|
| Re: Alert Log file [message #172146 is a reply to message #172141] |
Mon, 15 May 2006 03:59  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Maybe the listener was down - check your listener.log file for details.
PS: Anyone can edit the alert.log file. So, is the DB was down, one of the DBAs might be covering his/her tracks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
