记录一下相关文档
Note:561429.1 "DNS Issue: Connections To Oracle 11g are Slow or Delayed" (Bug9593134)
Note:856820.1 "11g: Remote Connections Take Very Long to Establish"
Note:803838.1 "Listener startup / connections hang in 11g"
记录一下相关说明
Note:561429.1 "DNS Issue: Connections To Oracle 11g are Slow or Delayed" (Bug9593134)
Note:856820.1 "11g: Remote Connections Take Very Long to Establish"
Note:803838.1 "Listener startup / connections hang in 11g"
记录一下相关说明
We need to make sure that the DNS server(s) configured are reachable.
The "snlinGetAddrInfo" function is a TCP layer function which Oracle uses (since version 11g) for hostname-to-IP mappings.
When the DNS server is unreachable, the listener will wait for some time until it will time out and fail over to the next method configured for resolution of hostnames (usually the local "hosts" file).
Bug 9593134 - DNS or NIS mis-configuration can cause slow database connects (文档 ID 9593134.8)转到底部
APPLIES TO:Oracle Net Services - Version 1.0.2.4.0 to 11.2.0.1
Information in this document applies to any platform.
DETAILS Bug 9593134 DNS or NIS mis-configuration can cause slow database connects This note gives a brief overview of bug 9593134.
The content was last updated on: 27-MAR-2012
可以看到问题出在即使TNSNAMES.ORA你使用IP地址，任然会进行解析，并且首先会去尝试通过 resolv.conf中的配置进行解析，当一个地址不可达时就会出现等待，然后才会使用HOSTS文件。 此问题在11.2.0.2修复，影响11.1.0.7和11.2.0.1，解决注销掉 /etc/resolv.conf类容即可,或者安装补丁程序 bug 9593134
The "snlinGetAddrInfo" function is a TCP layer function which Oracle uses (since version 11g) for hostname-to-IP mappings.
When the DNS server is unreachable, the listener will wait for some time until it will time out and fail over to the next method configured for resolution of hostnames (usually the local "hosts" file).
Bug 9593134 - DNS or NIS mis-configuration can cause slow database connects (文档 ID 9593134.8)转到底部
APPLIES TO:Oracle Net Services - Version 1.0.2.4.0 to 11.2.0.1
Information in this document applies to any platform.
DETAILS Bug 9593134 DNS or NIS mis-configuration can cause slow database connects This note gives a brief overview of bug 9593134.
The content was last updated on: 27-MAR-2012
可以看到问题出在即使TNSNAMES.ORA你使用IP地址，任然会进行解析，并且首先会去尝试通过 resolv.conf中的配置进行解析，当一个地址不可达时就会出现等待，然后才会使用HOSTS文件。 此问题在11.2.0.2修复，影响11.1.0.7和11.2.0.1，解决注销掉 /etc/resolv.conf类容即可,或者安装补丁程序 bug 9593134
