最近在使用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编译存储过程，触发器果然是成功通过，唉，这个问题本郁闷我好几天了。