使用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' AND sys.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;

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

ora.GIF

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22997/viewspace-561471/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22997/viewspace-561471/