This content has been marked as final. Show 4 replies
That is not really an Apex problem. The connection between the two database was dropped, maybe because the other database went down. Ask your DBA what was going on.
Database never went down. I asked our dba.
I've had some problems in the past with in-doubt transactions with a DB link to a Sybase database. I can imagine it is more difficult for Oracle to manage transactions over a DB link if the the database is not Oracle. Especially with SQL Server/Sybase that do their own commit by default. Might that be the case here?
ORA-03113: end-of-file on communication channelThis also indicates a network problem.
You can also post this in the General Database forum.
Thank you for your response, remote database is also Oracle DB with same version.