plq
asked on
ORA-03114: NOT CONNECTED TO ORACLE
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Have a look at TRC files in F:\oracle\admin\DBNAME\udu mp
ASKER
I am rerunning it now and will report back...
thanks
thanks
ASKER
Nope. I made it fail again and the latest trc or any file in those folders is dated 4 days ago.
Do you have SQL*Plus installed on the IIS / .NET box ?
Can you open a session ?
Can you open a session ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
>> 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
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
ASKER
>> What is the profile of the user?
DBA and AQ_ADMINISTRATOR_ROLE
DBA and AQ_ADMINISTRATOR_ROLE
ASKER
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
17-Oct-2006 10:57:52,-2147467259,Error
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No, the entire code runs under a single connection
ASKER
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
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
ASKER
Thanks for this. The sql gave me
F:\oracle\admin\DBNAME\bdu
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