一台client发现无法连接服务器，服务器正常，检查client时发现本地执行sqlplus时hang住，最终定位为下面的一个bug，出现版本10.2.0.1,临时解决方法重启client机器，不过248天后还会再次出现，根本解决方法就是升级client的版本或者安装对应的patch即可

Cause

This is a known, unpublished bug.

BUG 4612267 OCI CLIENT IS IN AN INFINITE LOOP WHEN MACHINE UPTIME HITS 248 DAYS

Solution

Select one of the following two solutions:

1) Apply one-off patch available for 10.2.0.1.
   a. Download one-off patch off Metalink:
       Patch 4612267
       Description OCI CLIENT IS IN AN INFINITE LOOP WHEN MACHINE UPTIME HITS 248 DAYS
       Product CORE
       Release Oracle 10.2.0.1

   b. To apply patch on Instant Client install, please follow instructions documented in the OCI manual.
        You can find this in:
        http://www.oracle.com/pls/db102/db102.show_toc?which=main&partno=b14250&maxlevel=2�ion=&expand=3216

        under "Patching Instant Client Shared Libraries on Linux or UNIX".

2) Apply Patchset 10.2.0.2 or higher.
      According to unpublished BUG 4612267, this bug is fixed in version 11, and backported to 10.2.0.2 patchset.

ITPub博客

Sqlplus/OCI client关于机器uptime超过248天执行hang的一个bug

最新文章