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

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 - 19:15:38 CDT