ERROR OGG-05500 Detected database metadata mismatch between current trail file

early at work today, i encountered a very seldom error in oracle gg. the OGG-05500.
checking the history of the database, recently one of our database we migrated it to its dedicated server.

Old DB Name : CXXXLU
New DB Name : CXXXLATU

our gg configuration is multibidirectional replication.
here is the error i receive in one of our replicat.

 
016-04-01 23:22:14  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, ckltbrnm.prm:  REPLICAT CKLTBRNM started.
2016-04-01 23:22:24  ERROR   OGG-05500  Oracle GoldenGate Delivery for Oracle, ckltbrnm.prm:  Detected database metadata mismatch between current trail file /gg111/112/11g/dirdat/cxxxnuat/IN/LT/br000382 and the previous sequence.
DBNAME: [CXXXLATU]/[CXXXLU]
DBINSTANCE: [CXXXLATU1]/[CXXXLU1]
*DBCLIENTCHARSET: [0]/[1073741824].
2016-04-01 23:22:24  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, ckltbrnm.prm:  PROCESS ABENDING.


and here is the content of report file.

 
Source Context :
  SourceModule            : [er.api]
  SourceID                : [/scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/app/er/api.c]
  SourceFunction          : [trailHeaderUpdateDbMetadata]
  SourceLine              : [5337]
  ThreadBacktrace         : [10] elements
                          : [/gg111/112/11g/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x2b895ea7a70e]]
                          : [/gg111/112/11g/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2cc) [0x2b895ea736ac]]
                          : [/gg111/112/11g/libgglog.so(_MSG_ERR_TRAIL_DBMETADATA_MISMATCH(CSourceContext*, char const*, char const*, CMessageFactory::MessageDisposition)+0x3d) [0x2b895ea4f613]]
                          : [/gg111/112/11g/replicat [0x4c10ce]]
                          : [/gg111/112/11g/replicat(XT_read(chkpt_context_t*, char*, __std_rec_hdr*, int*, int*, short, short, char*, short*, char*, short*, int, long*, char*)+0x1264) [0x4c85a4]]
                          : [/gg111/112/11g/replicat(READ_EXTRACT_RECORD(chkpt_context_t*, short, char*, __std_rec_hdr*, int*, int*, long*, short, short,char*, short*, char*, short*, long*, char*)+0xe8) [0x4c8ff8]]
                          : [/gg111/112/11g/replicat(process_extract_loop()+0x402) [0x538dc2]]
                          : [/gg111/112/11g/replicat(main+0x732) [0x54cc02]]
                          : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x363dc1d9f4]]
                          : [/gg111/112/11g/replicat(__gxx_personality_v0+0x31a) [0x4c0c6a]]

2016-04-01 23:22:24  ERROR   OGG-05500  Detected database metadata mismatch between current trail file /gg111/112/11g/dirdat/cxxxnuat/IN/LT/br000382 and
the previous sequence.
DBNAME: [CXXXLATU]/[CXXXLU]
DBINSTANCE: [CXXXLATU1]/[CXXXLU1]
*DBCLIENTCHARSET: [0]/[1073741824].

solution :

OGG-05500 Detected Database Metadata Mismatch between Current Trail File (Doc ID 1605434.1)

just follow the docs in metalink and your issue should be fixed.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s