Re: my Oracle 9.2.0.1 unstable on my Windows XP box ORA-00470

April Nine wrote:
> Hi,
>
> I'm writing some simple JDBC programs do some simple things inside the
> DB.
>
> When I do development on Linux or Solaris, Oracle seems solid and
> stable.
>
> When I do JDBC development on my Win-XP box it seems that Oracle is
> somewhat unstable and tends to crash once or twice a day.
>
> It's slightly annoying but Oracle usually restarts with out a problem.
>
> I am finding a tiny clue in the alert log:
>
> Errors in file c:\oracle\admin\protect\bdump\protect_pmon_1980.trc:
> ORA-00470: LGWR process terminated with error
>
> The .trc contains text like this:
>
> Dump file c:\oracle\admin\protect\bdump\protect_pmon_1980.trc
> Wed Jun 18 14:25:55 2003
> ORACLE V9.2.0.1.0 - Production vsnsta=0
> vsnsql=12 vsnxtr=3
> Windows 2000 Version 5.1 Service Pack 1, CPU type 586
> Oracle9i Release 9.2.0.1.0 - Production
> JServer Release 9.2.0.1.0 - Production
> Windows 2000 Version 5.1 Service Pack 1, CPU type 586
> Instance name: protect
>
> Redo thread mounted by this instance: 1
>
> Oracle process number: 2
>
> Windows thread id: 1980, image: ORACLE.EXE
>
>
> *** 2003-06-18 14:25:55.000
> *** SESSION ID:(1.1) 2003-06-18 14:25:55.000
> error 470 detected in background process
> ORA-00470: LGWR process terminated with error
>
> As you can see, I'm running ORACLE V9.2.0.1.0 - Production
> which is Standard Edition.
>
> The above banner in the .trc file:
> "Windows 2000 Version 5.1 Service Pack 1"
> confuses me since I am under the assumption that I am running
> "Windows XP professional"
> which is what I see when I do ctl-alt-del.
>
> According to my System-Properties-Window I am running this:
> Microsoft Windows XP
> Professional
> Version 2002
> Service Pack 1
>
> The Java SDK I'm using is...
> 1.4.1_01
>
> Do you windows-Oracle experts have any suggestions on how to make
> Oracle more stable on my PC?
>
> -April Nine

One solution is to replace Windoze with Linux!

Are there any "interesting" entries System "Event Viewer"? I suspect some OS related error is happening

There are 17 Notes: on Metalink returned on a search of "ORA-00470: LGWR process terminated with error"

Try reading them & see if any are applicable to your situation. Received on Sat Jun 28 2003 - 19:46:33 CDT