• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2208
  • Last Modified:

ORA-03114: not connected to ORACLE


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
  • 2
1 Solution
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.  
CMANI10Author Commented:
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?
ORA-03135:connection lost contact

Cause:       1) Server unexpectedly terminated or was forced to terminate. 2) Server timed out the connection.
Action:       1) Check if the server session was terminated. 2) Check if the timeout parameters are set properly in sqlnet.ora.
CMANI10Author Commented:
It's good
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now