Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

log file that tracks database uptime, etc.

Status
Not open for further replies.

JazzGeek

IS-IT--Management
Jun 23, 2002
165
US
Hi All, is there an Oracle 10g logfile anywhere that I can regularly check to see if the database was bounced or crashed or brought up at any time?

Thank you. I'm a newbie.

SJ

Sebastian Jazzer
MCSE 4.0 & 2000, Network+, A+, Web Developer

 
Hi, SJ

The log files are located in the:

/admin/<your database name>/bdump

directory

Regards,


William Chadbourne
Oracle DBA
 
Bill's answer is correct in a default install. If, like ours, yours isn't, you may have to search through your system for the log file, commonly called alert<SID>.log. You might also be able to find it by typing:

select value from v$parameter where name = 'background_dump_dest';

at an sqlplus command prompt.

I want to be good, is that not enough?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top