ORA-03113 at SQLDisconnect() after retrying connect Oracle

phatngovan
phatngovan used Ask the Experts™
on
My application is developed in C++. It does not need to be restarted when network to database server is disconnected or oracle database is shut down because it can retry connecting to oracle database after network is reconnected or oracle database is restarted up.
However, after the application is shut down, an error log message appears when the SQLDisconnect(hpHdbc) is executed like below:
"SQLDisconnect() SQLSTATE=08S01 ERROR=[Oracle][ODBC][Ora]ORA-03113:
end-of-file on communication channel"
Error log information is also registed in alert.log file of oracle.
Is there any way to solve the error at reconnecting database in order to avoid getting the error log message after shuting down the application?
Thanks!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Deputy General Manager - IT
Commented:
is there any way by which u can check the connection is currently active or not, if yes then check the status and if connected only disconnect.
Or u may have to capture the exception after disconnect command is issued

Author

Commented:
close this question

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