Wednesday, January 5, 2022

TNSPING sqlnet Timeout option for net address not reachable.

sqlnet.ora timeout for tnsping of offline host/vip address, this would normally hang your tnsping for 3 minutes, if you have 1500+ entries in a global tns file, with many of them dead of offline for maintenance, that adds up quickly. 


###########################

# tnsping host/vip timeout option 

TCP.CONNECT_TIMEOUT=1

###########################


No comments:

Post a Comment