Oracle errors

[mrathi]

Hi,
I have created a simple asp.net application with a login page. When i run my application it works fine sometimes. I can correctly login and see the next page fine. However, sometimes I get the following two Oracle errors. These errors are on and off. I would appreciate any help at all.

1. ORA-03114: not connected to ORACLE
2. ORA-03113: end-of-file on communication channel

These errors just come on randomly.

Thanks.

 

[ca8msm]

These are basically Timeout errors issued by the Oracle database when a session times out. I would suggest you look through your code as the most likely problem is that you open a connection to oracle and forget to close it - hence the timeout.

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[mrathi]

Thanks for the reply. I did check my code. I do have close connection code wherever I open a connection. So I guess that should not be the case.

Thanks

 

[ca8msm]

What about the Oracle database then? Do you have administrative access to it to be able to check sessions?

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[mrathi]

No, I do not. Does that mean I will have to contact my DBA?

 

[ca8msm]

I would suggest contacting the DBA to make sure that the sessions are not timing out - he/she should be able to see all your active sessions.

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[mrathi]

Hi,
I did check my sessions. The DBA wasn't very helpful. However, I noticed one thing. I have a login page, that checks the user name and password in an oracle table. When I try to login, I get that error, and in a fraction of a second, when I click login again, the error goes away. This does not happen randomly. It just happens the first time everyday.

Thanks