How To Remove a Dead Connection to the Target Database Through DBlink After a Network Connection Failure Applies to: Oracle Net Services – Version: 8.1.7 to 9.2 Information in this document applies to any platform. Goal This document describe how you can remove a dead connection to the remote database through dblink after a network connection failure with the remote database server. Solution
1. Please set (ENABLE=BROKEN) in the connect string for the target database in the tnsnames.ora file at the origin or source database ORACLE_HOME\network\admin or TNS_ADMIN directory.
E.g. TEST.WORLD = (DESCRIPTION = (ENABLE=BROKEN) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = < >)(PORT = < >)) ) (CONNECT_DATA = (SERVICE_NAME = DISCARD.WORLD) ) ) 2. Please create the dblink using this connect string. 3. Please set the OS tcp/ip keepalive parameter in the local databse to a desired low value (e.g. 5 minutes).
Please note that in the case of a database link, the target destination of the link constitutes the server side of the connection. So it is not possible to use the DCD to close the database link from the origin database server in case of a network failure.
How To Remove a Dead Connection to the Target Database Through DBlink After a Network Connection Failure
Applies to:
Oracle Net Services – Version: 8.1.7 to 9.2
Information in this document applies to any platform.
Goal
This document describe how you can remove a dead connection to the remote database through dblink after a network connection failure with the remote database server.
Solution
1. Please set (ENABLE=BROKEN) in the connect string for the target database in the tnsnames.ora file at the origin or source database ORACLE_HOME\network\admin or TNS_ADMIN directory.
E.g.
TEST.WORLD =
(DESCRIPTION =
(ENABLE=BROKEN)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = < >)(PORT = < >))
)
(CONNECT_DATA =
(SERVICE_NAME = DISCARD.WORLD)
) )
2. Please create the dblink using this connect string.
3. Please set the OS tcp/ip keepalive parameter in the local databse to a desired low value (e.g. 5 minutes).
Please note that in the case of a database link, the target destination of the link constitutes the server side of the connection. So it is not possible to use the DCD to close the database link from the origin database server in case of a network failure.