使用PL/SQL developer 工具编译包或者其他objects时候出现错误

DB:9.2.0.6

出现的错误,有多种:

1,如果plsqldeveloper 的版本过低话,出现图1的错误.

2,如果plsqldeveloper 的版本在7.0.1 以上,则出现" 未连接数据库错误"

检查alter.log日志

Thu Mar 5 10:49:39 2009

Errors in file /datavg41/bjuat/db/bjuatdb/9.2.0/admin/BJUAT_misdev17/udump/bjuat_ora_13335.trc:

ORA-07445: exception encountered: core dump [0000000102301468] [SIGSEGV] [Address not mapped to object] [0x000000010] [] []

对应trace文件

ksedmp: internal or fatal error

ORA-07445: exception encountered: core dump [0000000102301468] [SIGSEGV] [Address not mapped to object] [0x000000010] [] []

Current SQL statement for this session:

BEGIN

     /* NOP UNLESS A TABLE OBJECT */

     IF dictionary_obj_type = 'TABLE' ANDsys.dbms_cdc_publish.active> 0

     THEN

       sys.dbms_cdc_publish.change_table_trigger(dictionary_obj_owner,dictionary_obj_name,'LOCK');

     END IF;

     END;

解决办法:

参考ORA-7445 and ora-3113 when either creating / altering or dropping an object and CDC is enabled

- One workaround for this error and if customer is not using Change Data Capture

is to remove this product by running$ORACLE_HOME/rdbms/admin/rmcdc.sql.

or

     SQL> ALTER TRIGGER sys.cdc_alter_ctable_before DISABLE;
     SQL> ALTER TRIGGER sys.cdc_create_ctable_after DISABLE;
     SQL> ALTER TRIGGER sys.cdc_create_ctable_before DISABLE;
     SQL> ALTER TRIGGER sys.cdc_drop_ctable_before DISABLE;

---问题:不知道这样做对系统有没有其他影响?