- 最后登录
- 2013-4-10
- 在线时间
- 6 小时
- 威望
- 36
- 金钱
- 175
- 注册时间
- 2012-3-9
- 阅读权限
- 10
- 帖子
- 11
- 精华
- 0
- 积分
- 36
- UID
- 287
|
1#
发表于 2012-4-16 16:23:59
|
查看: 6183 |
回复: 1
今天发现生产环境中,goldengate的数据同步出现问题了,主要表现为target的replicat出现了异常中止,具体的报错信息为:
2012-04-16 16:08:32 INFO OGG-01407 Setting current schema for DDL operation to [EAUSER].
Source Context :
SourceModule : [ggapp.ddl]
SourceID : [/scratch/pradshar/view_storage/pradshar_bugdbrh40_12927937/oggcore/OpenSys/src/gglib/ggapp/ddlrep.c]
SourceFunction : [DDLREP_handleDDLError]
SourceLine : [500]
ThreadBacktrace : [11] elements
: [/data/ora10g/ggate/replicat(CMessageContext::AddThreadContext()+0x26) [0x5f1e56]]
: [/data/ora10g/ggate/replicat(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x7b2) [0x5e88f2]]
: [/data/ora10g/ggate/replicat(_MSG_ERR_DDL_ABEND_NO_HANDLER(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x9
2) [0x5980e2]]
: [/data/ora10g/ggate/replicat(DDLREP_handleDDLError(char const*, char const*, char const*, char*, int, RepConfig_t*, char const*,
char const*, char const*, DBString<258>&, DBString<258>&, long*)+0x936) [0x84356e]]
: [/data/ora10g/ggate/replicat [0x847e1c]]
: [/data/ora10g/ggate/replicat(DDLREP_process(char*, __std_rec_hdr*, unsigned short)+0x21a8) [0x84ef40]]
: [/data/ora10g/ggate/replicat [0x8f2b4c]]
: [/data/ora10g/ggate/replicat [0x8f5f02]]
: [/data/ora10g/ggate/replicat(main+0x84b) [0x507a0b]]
: [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3f9ba1d974]]
: [/data/ora10g/ggate/replicat(__gxx_personality_v0+0x1e2) [0x4e3ffa]]
2012-04-16 16:08:32 ERROR OGG-00519 Fatal error executing DDL replication: error [Error code [24344], ORA-24344: success with compilation error, SQL crea
te or replace procedure "EAUSER"."TEST"() is
declare name varchar2(100);
declare nick varchar2(100);
declare pwd varchar2(100);
declare cusor_1 cursor is select uname,nname,fn_md5(pwd) from temp_x], no error handler present.
通过日志查看发现是由于存储过程引起的,请问下刘老大该怎么解决啊?是否可以屏蔽掉存储过程的同步啊? |
|