| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Alert Log
This is from the Oracle 8i Administrators Guide for Windows:
"Oracle8i for Windows NT background threads use trace files to record occurrences and
exceptions of database operations, as well as errors. Background thread trace files
are created regardless of whether the BACKGROUND_DUMP_DEST parameter is set in the
INIT.ORA initialization parameter file. If BACKGROUND_DUMP_DEST is set, the trace
files are stored in the directory specified. If the parameter is not set, the trace
files are stored in the ORACLE_BASE\ADMIN\DB_NAME\BDUMP directory."
This is the same information from the Oracle 9i Administrators Guide for Windows:
"The alert file is named SIDALRT.LOG and is found in the directory specified by
parameter BACKGROUND_DUMP_DEST in the initialization parameter file. If
parameter BACKGROUND_DUMP_DEST is not set, then file SIDALRT.LOG is
generated in ORACLE_BASE\admin\db_name\bdump. Alert files should be
deleted or archived periodically."
HTH
-----Original Message-----
jaysingh1_at_optonline.net
Sent: Monday, December 08, 2003 9:05 AM
To: Multiple recipients of list ORACLE-L
Hi List
My database is taking vert long time to startup. so I just wanted to check alert log file. But I don't see Alert log in either background_dump_dest or user_dump_dest. Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all directory).
SQL> show parameter dump
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ background_core_dump string partial background_dump_dest string C:\oracle\RDBMS\trace core_dump_dest string %ORACLE_HOME%\RDBMS\TRACE max_dump_file_size string 10240 shadow_core_dump string partial user_dump_dest string C:\oracle\RDBMS\traceSQL> Coudl someone shed light on this?
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: jaysingh1_at_optonline.net Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary W. Parker INET: garywp_at_ev1.net Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Dec 08 2003 - 09:59:26 CST
 |
 |