ORA-03114 not connected to ORACLE

[Vortex76]

I've some problems with one of our servers here running Oracle 8.1.5. I can pretty much reproduce this error anytime when running my application and doing some sql heavy stuff.

The server itself is on my LAN so im pretty certain that there is no communication problems and the oracle server never goes down. I can be connected with pl/sql developer during this and only my application gets the error.

This server is _old_, something like pentium-233, 256mb ram. On one of our faster servers we rarely get this but I really need to get this down to never so if anyone have any tips on what causes this and how to fix it I'll be very happy

Thanks
/Christer

 

[Marco Kalter]

It may be that the server process has died. Check if a user dump file exists on the database server that is related to the problem. If so, feel free to send it to me.

------------------
Marco Kalter
Allround Automations

 

[Vortex76]

Hmm, well, dont think that the server process dies since everything works in my pl/sql developer window where im connected both before and after this happens. There's nothing written to the the log files (bdump,cdump,udump)..

I'll see if I can set up the listener to log.. maybe someone can get something out of that.

I just upped some memory params in the init.ora file and it took a little more effort to get the error (~3 mins instead o 1).

/Christer

 

[Vortex76]

Oh well, guess I was just "lucky" before. Now i got the error after about 30sec. This time i turned on logging so i have a cli.trc and sqlnet.log file. Not sure if it helps but I'll send it to you anyway

/Christer