Re: Help Interpreting PMON Trace Errors

Hi Tim,

PMON is stating here LGWR has died unexpectedly. LGWR is the (redo) log writer, one of the most vital processes in an Oracle database. Following the PMON trace file there should be a file D:\ORANT\RDBMS73\TRACE\ORCLLGWR.TRC, which should provide more detail. Without that it is impossible to tell what happened.

Hth

Sybrand Bakker

Tim Romano wrote:

> After some kind of Oracle crash earlier in the day, cause unknown,
> my system now slows to a crawl when the Oracle db is started up;
> TNSListener is consuming 99% of the CPU, according to the NT Task
> Manager. I would be grateful for any help interpreting the
> following error messages from PMON, so I can fix this situation.
> Thanks,
> Tim
>
> Sat Sep 05 10:06:41 1998
>
> *** SESSION ID:(1.1) 1998.09.05.10.06.41.783
> error 470 detected in background process
> Sat Sep 05 10:07:11 1998
> OPIRIP: Uncaught error 447. Error stack:
> ORA-00447: fatal error in background process
> ORA-00470: LGWR process terminated with error
> Dump file D:\ORANT\RDBMS73\trace\orclPMON.TRC
> Sat Sep 05 10:19:36 1998
> ORACLE V7.3.3.0.0 - Production Release vsnsta=0
> vsnsql=b vsnxtr=3
> Windows NT V4.0, OS V5.101, CPU type 586
> Dump file D:\ORANT\RDBMS73\trace\orclPMON.TRC
> Sat Sep 05 10:57:40 1998
> ORACLE V7.3.3.0.0 - Production Release vsnsta=0
> vsnsql=b vsnxtr=3
> Windows NT V4.0, OS V5.101, CPU type 586
Received on Sun Sep 06 1998 - 01:48:57 CDT