Re: VB6->CR7->crash Oracle...

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 03 May 1999 15:08:20 -0700
Message-ID: <372E1E53.185A0B36@us.oracle.com>

You need to look at this file D:\ORANT\RDBMS73\trace\eca2PMON.TRC and see what happened. LGWR is a mandatory process so when it dies the server dies. Check the trace file for errors and let us know what you find.

HTH. Pete

hlh_nospam_at_excite.com wrote:

> We looked through the trace logs, and found the following entry which
> looks like it might be informative. The timestamp corresponds to
> within a minute of the time I noticed that everything went bad.
>
> *** SESSION ID:(1.1) 1999.05.01.15.03.03.265
> error 470 detected in background process
> 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\eca2PMON.TRC
> Sat May 01 15:11:57 1999
> ORACLE V7.3.4.0.0 - Production vsnsta=0
> vsnsql=b vsnxtr=3
> Windows NT V4.0, OS V5.101, CPU type 586
>
> ----- Posted via Deja.com, The People-Powered Information Exchange -----
> ------ http://www.deja.com/ Discussions * Ratings * Communities ------

Regards

Pete

Pete Sharman                              Email: psharman_at_us.oracle.com
Project Manager                           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

Oracle Corporation

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Mon May 03 1999 - 17:08:20 CDT