Hi ,

I am using System.Data.OracleClient to connect to a oracle 10g
database on a Win 2003 server.
I have also installed the oracle 10g client and .Net 2.0 on the app
server.
My problem is that I keep getting error (shown below) intermittently..

System.Data.OracleClient.OracleException: ORA-03114: not connected to
ORACLE
 at System.Data.OracleClient.OracleException.Check(OciErrorHandle
errorHandle, Int32 rc)
 at System.Data.OracleClient.OracleInternalConnection.Rollback()
 at System.Data.OracleClient.OracleConnection.Rollback()
 at System.Data.OracleClient.OracleTransaction.Dispose(Boolean
disposing)
 at System.Data.OracleClient.OracleTransaction.Rollback()

After getting this error if I reboot my server, the error goes away
only to return after some time.Also I have noticed that if the
application servers remian idle for some time, I get this error when
they resume work.

On googling I came across this article
http://support.microsoft.com/default.aspx?scid=kb;en-us;830173
It mentions this problem has been fixed in the Win 2003 SP1.I am
already at SP2 on my servers.

I am looking for ways to find the root cause of this error.Is it
related with setting on the oracle database server,oracle client or
some Win 2003 network settings?

Thanks In Advance!