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-----
[EMAIL PROTECTED]
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\trace
SQL>
Coudl someone shed light on this?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
