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

Try to find additional trace files. Check in udump directory also. You should find something that has more information than ORA-00470.

On 28 Jun 2003 17:15:38 -0700, april94111_at_yahoo.com (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
Received on Sat Jun 28 2003 - 23:46:39 CDT