DB_LINK and end-of-file on communication channel
Posted on 1998-08-24
I am working with two oracle 7.3.4. oracle databases.
The databases are connect to each other by database links.
I have some deamons set up on one database wich are processing some database database transactions on both of the databases.
The problem arises when the database which is accessed throug the database link has been shut down. If the database comes up again the deamon still complains about end-of-file on communication channel ....
I did some exception handeling to solve the problem but from time to time the exeception handeling does not seems to work because the errors seem to migrate...
The exceptions i am currently handeling are the ORA-3113 end-of-file on communication channel and the ORA-2068 02068, 00000, "following severe error from %s%s"
// *Cause: A severe error (disconnect, fatal Oracle error) received from
// the indicated database link. See following error text.
// *Action: Contact the remote system administrator.
How can i capture all the errors that are generated from the database link without using WHEN OTHERS wich will capture all the errors which means the database link errors but also all other possible errors.