oracle10G运行了198天就连不上的问题,望高手指导,谢谢!!!

niubro · 发表于 2008-1-9 19:54

原帖由 SingleLove 于 2008-1-9 15:25 发表
10.2.0.3的补丁在哪下？

metalink上下载

frankfan126 · 发表于 2008-1-14 13:35

那位大侠能发一个补丁 4612267
frankfan126@126.com
万分感谢！

[ 本帖最后由 frankfan126 于 2008-1-14 13:51 编辑 ]

frankfan126 · 发表于 2008-1-16 12:06

不要REBOOT机器，只重启ORACLE可以避免问题发生吗？

Gavin_ygf · 发表于 2008-1-17 12:53

SQL*Plus 10.2.0.1 Hangs,

数据库client 版本SQL*Plus - Version: 10.2.0.1.0
系统: lLinux x86
现象：系统在运行200天左右sqlplus 执行没有任何反应
运行strace 工具观测显示
$ strace /oracle/home/bin/sqlplus -V 2>&1 |less

times(NULL)                            = -2051777571
times(NULL)                            = -2051777571
times(NULL)                            = -2051777571
times(NULL)                            = -2051777571
times(NULL)                            = -2051777571
times(NULL)                            = -2051777571
times(NULL)                            = -2051777571
times(NULL)                            = -2051777571
times(NULL)                            = -2051777571
times(NULL)                            = -2051777571
times(NULL)                            = -2051777571
times(NULL)                            = -2051777571
times(NULL)                            = -2051777571
times(NULL)                            = -2051777571
times(NULL)                            = -2051777571
times(NULL)                            = -2051777571
times(NULL)                            = -2051777571

It is looping on the times() function.

原因：

This is a known, unpublished bug.
Bug 4612267 OCI CLIENT IS IN AN INFINITE LOOP WHEN MACHINE UPTIME HITS 248 DAYS

解决方法：

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/ ... on=&expand=3216

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

2)  Wait for Patchset 10.2.0.2 to be available.
   According to Bug 4612267, this bug is fixed in version 11, and backported to 10.2.0.2 patchset.
   This patchset is estimated to be available mid-Dec 2005; but this is subject to change.