pl/sql developer编译存储过程中遇到了ORA-07445错误...
最近在使用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编译存储过程,触发器果然是成功通过,唉,这个问题本郁闷我好几天了。
扫一扫订阅我的微信号:IT技术博客大学习
- 作者:Incessant 来源: Incessant
- 标签: ORA-07445
- 发布时间:2009-10-11 22:22:30
- [70] Twitter/微博客的学习摘要
- [65] find命令的一点注意事项
- [64] 如何拿下简短的域名
- [64] IOS安全–浅谈关于IOS加固的几种方法
- [63] android 开发入门
- [62] 流程管理与用户研究
- [62] Go Reflect 性能
- [60] Oracle MTS模式下 进程地址与会话信
- [59] 读书笔记-壹百度:百度十年千倍的29条法则
- [59] 图书馆的世界纪录