某金融客户一套OGG生产环境replicat进程报错,具体报错信息如下:
2014-05-10 01:24:29 ERROROGG-00519 Fatal error executing DDL replication: error [Error code[38029], ORA-38029: ^Z^Z^Z^Z^Z^Z^Z
^Z^Z SQL analyze table ORIG.PRPJPL compute statistics ], no errorhandler present.
因为OGG配置了DDL同步,从报错的信息来看,看来是源端在执行analyzetable的DDL语句时,该语句同步到目标端执行失败。
报错信息 ORA-38029: ^Z^Z^Z^Z^Z^Z^Z^Z^Z显示的是一串乱码,在服务器上查了下ora-38029的错误内容:
$ oerr ora 38029
38029, 00000, "object statistics are locked"------对象统计信息已锁定
// *Cause: An attept was made to modify optimizer statistics of theobject.
// *Action: Unlock statistics with theDBMS_STATS.UNLOCK_TABLE_STATS procedure
// on base table(s). Retry the operation if it is okay to updatestatistics.
一则OGG-00519 ORA-38029错误及解…
最新推荐文章于 2024-01-10 17:23:07 发布