ORA-03114: NOT CONNECTED TO ORACLE

plq
plq used Ask the Experts™
on
I'm running a long job from a web application with a IIS / vb.net mid tier and an oracle backend.

The web app runs in IIS as high isolated.

After many minutes (not sure how many yet), the thing comes back with ORA-03114: NOT CONNECTED TO ORACLE

Are there any configuration parameters either in IIS or ORACLE or other things I can set that might fix this?  

thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2006
Commented:
Hi,

can you check your alert log for when this happens?  it sounds as if there might be a server error and the database is dumping your conection.  if this is the case, there will be an entry in the alert log with reference to a tracefile that will contain more information.  you will need to know when the server dumps your connection tho'.

the alert log is located : select value from v$parameter where name = 'background_dump_dest'

let us know what it says ( if anything )

good luck :)
plq

Author

Commented:
Hi Richard.

Thanks for this. The sql gave me
F:\oracle\admin\DBNAME\bdump

So I went there and theres a alert_dbname.log which hasn't been updated for 7 days, I checked its contents as well and thats also 7 days old at the bottom

Other than that theres trc files the latest of which is 3 days ago.

thanks
Paul
IS Operational Excellence Manager
Commented:
It seems that your database is not opened.
Can you establish a connection using SQL*Plus ?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

plq

Author

Commented:
The error happens when we import a large file using our software. The process is constantly pushing data into oracle. Technically its running through IIS

When we use a smaller file (< 5 mins load time) it loads ok and completes. There's some kind of timeout going on I think
Hi,
  What is the profile of the user? Does it have any CPU limits or any other limits? If you have any limits, then please try to give unlimited resources and give it a try.
Please post the complete error message. Sometimes, it is possible that we get only the first line, which will be misleading.
HTH
Regards,
Badri.
Pierrick LOUBIERIS Operational Excellence Manager

Commented:
Have a look at TRC files in F:\oracle\admin\DBNAME\udump
plq

Author

Commented:
I am rerunning it now and will report back...

thanks
plq

Author

Commented:
Nope. I made it fail again and the latest trc or any file in those folders is dated 4 days ago.
Pierrick LOUBIERIS Operational Excellence Manager

Commented:
Do you have SQL*Plus installed on the IIS / .NET box ?
Can you open a session ?


Check if your archive log destination is 'full' (log_archive_dest)
plq

Author

Commented:
>> Can you open a session ?

Yes I can query the database fine from sql plus or from my own little "query analyser" program written in vb

>> Check if your archive log destination is 'full' (log_archive_dest)

Can you tell me how to check this ? I am not familiar with oracle - thanks
plq

Author

Commented:
>> What is the profile of the user?

DBA and AQ_ADMINISTRATOR_ROLE
plq

Author

Commented:
Here's all the text of the error message it gave me.. which is not very useful


17-Oct-2006 10:57:52,-2147467259,Error: ORA-03114: not connected to ORACLE$Native Error:3114 (-2147467259)$Occurred in (OraOLEDB) context Table DBTransform
Hi,
  Please check, if there are multiple connections in the programme. Please use some debug statements to print the connection string where it is failing.
It is possible that you have multiple connections and the first connection opening is fine and one connection opening is failing becuase you have specified wrong SID or something.
HTH
Regards,
Badri.
plq

Author

Commented:
No, the entire code runs under a single connection
plq

Author

Commented:
Points coming up... but the answer is in the above thread

Please note, for anyone trying to analyse NOT CONNECTED TO ORACLE in future, the cause in this case was a previous error that wasnt correctly handled. (end of communication error), which drops the connection and then not connected to oracle is raised on a subsequent query.

thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial