最近在使用pl/sql deverloper,toad第三方工具来编译procedure，trigger时,总出现pl/sql developer自动断开，编译失败的情况，重新连接oracle，编译还是失败。。。接着alert log就出现了一大堆ORA-07445错误，而用sql plus去编译则没有问题，编译顺利通过。我推断应该是oracle和第三个工具兼容的问题，可能是oracle的一个小bug，去metalink看看，果然发现了。。。 环境：Linux as3+oracle9205

    报错信息:

    Errors in file /u01/app/oracle/admin/sensky/udump/sensky_ora_656.trc:

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

    Metalink的解决办法：

    *** 05/27/03 09:36 am ***

    < TAR>: 13819861.6

     =========================

    < PROBLEM>:

     Every time developers debug a pl/sql object through Pl/Sql developer tool run

    into following errors

    . ORA-07445: exception encountered: core dump [0000000101E9F648] [SIGSEGV]

    [Address not mapped to object] [0x000000010] [] []

    . =========================

    < DIAGNOSTIC ANALYSIS>:

     The each trace has same following query referenced

    . BEGIN

     /* NOP UNLESS A TABLE OBJECT */

     IF dictionary_obj_type = \'TABLE\' AND sys.dbms_cdc_publish.active > 0

     THEN

     sys.dbms_cdc_publish.change_table_trigger(dictionary_obj_owner,dictionary_obj_n

    ame,sysevent);

     END IF;

     END;

    .

    This query is part of the CDC or "Change Data Capture" feature of Oracle

    rdbms.

    =========================

    < WORKAROUND>:

    Run following sql script as SYS user to deinstall CDc objects

    .

     SQL> @?/rdbms/admin/rmcdc.sql

    .

    =========================

    < RELATED BUGS>:

    Bug 2858875 - ORA-7445 WITH SQL NAVIGATOR

    Bug 2613832 - GSI 92 -- TTS -- GETTING ORA-7445 WHILE IMPORTING DICTIONARY

    ...............................................................................

     通过sys用户运行SQL> @?/rdbms/admin/rmcdc.sql ，在使用pl/sql tools编译存储过程，触发器果然是成功通过，唉，这个问题本郁闷我好几天了。