很囧的ORA-07445

昨晚遇到很囧的问题

ORA-07445。

[@more@]

晚上正在洗衣服，听到手机响了。

擦干手跑去接电话，刚好对方挂了，一看是公司MVPN的号码，再一看是X厂 ITS的负责人，当下感觉不妙（此人来电话必有事请发生）。

火速连线至相关DB，果然Instance Crash。

翻了下ALERT：

Errors in file /u01/app/oracle/admin/shanb1/bdump/shanb1_s000_8678.trc:

ORA-07445: exception encountered: core dump [ptmak()+144] [SIGSEGV] [Address not mapped to object] [0x000000010] [] []

Mon Jun 23 22:06:33 2008

found dead shared server 'S000', pid = (12, 1)

再接下来：

ORA-00600: internal error code, arguments: [kcbzpb_1], [67369171], [2], [1], [], [], [], []

看到这里，明白了7 8分。

肯定又是谁在用PL/SQL Developer Run什么东西。去年发生过后曾经宣导过此事。

先把Instance恢复起来, 再分析TRC。

果然，之前某人在透过PL/SQL developer compile一个SP。

附上Metalink的解释：

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.8.0
This problem can occur on any platform.

Symptoms

The database crashed with the following errors:

ORA-07445: exception encountered: core dump [ptmak()+144] [SIGSEGV] [Address not

ORA-00600: internal error code, arguments: [kclfusfake_5], [1], [483215946], [],
ORA-00600: internal error code, arguments: [kjmsm_epc], [], [], [], [], [], [],

The stack trace from the ORA-07445: exception encountered: core dump [ptmak()+144]:

ksedmp ssexhd pthread_sighandler_rt ptmak r_rt pdtidc pdlifu phpcmp pcicog kkxcog opitca rpiswu2 kkssbt kksfbc opiexe opiall0 kpoal8

Cause

Older version of PL/SQL Developer.

Solution

Upgrade PL/SQL Developer to the most recent version.

There have been other bugs reporting a very similar stack and mostly with 3rd party pl/sql development tools. While the exact root cause in unknown, it may be related to using debug mode.

If this problem is encountered, perhaps setting the session for debug might cause it to reproduce directly from pl/sql and aid in troubleshooting:

alter session set plsql_debug=true;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10856805/viewspace-1006074/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10856805/viewspace-1006074/