技术头条 - 一个快速在微博传播文章的方式     搜索本站
您现在的位置首页 --> Oracle --> pl/sql developer编译存储过程中遇到了ORA-07445错误...

pl/sql developer编译存储过程中遇到了ORA-07445错误...

浏览:1572次  出处信息

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

QQ技术交流群:445447336,欢迎加入!
扫一扫订阅我的微信号:IT技术博客大学习
© 2009 - 2024 by blogread.cn 微博:@IT技术博客大学习

京ICP备15002552号-1