RE: Alert Log

From: Jesse, Rich <Rich.Jesse_at_qtiworld.com>
Date: Mon, 08 Dec 2003 09:34:36 -0800
Message-ID: <F001.005D930D.20031208093436@fatcity.com>

Regardless of whether or not it works, download it and the other tools like ntregmon, prcvire, and the almighty FileMonitor. No installs, no DLLs, no uninstall crap. Just extract and run the .exe. Excellent debugging tools.

Rich

Rich Jesse                           System/Database Administrator
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

-----Original Message-----
Sent: Monday, December 08, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L

If nothing else helps, download procexp or filemon from www.sysinternals.com and see which files are open by oracle.exe

Tanel.

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, December 08, 2003 5:04 PM

> 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: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

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 - 11:34:36 CST