handle Oracle ERROR ORA-12170: TNS:Connect timeout occurred
Hello dear all
We have a server that is responsible to collect data from some clients. In each of these devices we have installed Oracle 11.2g and they are connected via DB-link. There is a stored procedure that test the connection before do anything by executing command (+select count(*) from dual@db_link1+). In situations that one of clients can not be accessed, this ORA-12170 error occurred and the SP will be terminated. Now i want to prevent this happening and want sp skip this client and connect another one. I wonder if there is an exception raised by this fatal error and we can handle it.
Thank you