asked on

ORA-03114: not connected to ORACLE

Hi,

We are using IIS 6.0 in Windows 2003 server for hosting our website with .Net Framework 2.0 installed. We used to get "System.Data.OracleClient.OracleException: ORA-03114: not connected to ORACLE" exception when our asp.net application tries to interact with Oracle 10g Database.

Can anyone help us to identify the root cause for this issue.

Thanks & Regards,
Lenin Grad

aspxkid

Cause: A call to Oracle was attempted when no connection was established. Usually this happens because a user-written program has not logged on. It may happen if communication trouble causes a disconnection. In addition, this message could occur when ALTER SYSTEM KILL SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the IMMEDIATE qualifier because, in those cases, the client's connection to the database is terminated without waiting for the client to issue a request.
Action: Try again. If the message recurs and the program is user written, check the program.

CMANI10

ASKER

We also get this error per day 4 - 5 times while connecting to Oracle 10g Database from asp.net 2.0 web application.
"System.Data.OracleClient.OracleException: ORA-03135: connection lost contact".

Can you help us to solve this issue?

ASKER CERTIFIED SOLUTION

shock112

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CMANI10

ASKER

It's good