Erman Arslan's Oracle Forum - Re: WARNING OGG-02544 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Unhandled error (ORA-01031: insufficient privileges) while processing the record at SEQNO 237, RBA 266900102 in Integrated mode. REPLICAT will retry in Direct mode.

Re: WARNING OGG-02544 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Unhandled error (ORA-01031: insufficient privileges) while processing the record at SEQNO 237, RBA 266900102 in Integrated mode. REPLICAT will retry in Direct mode.

Posted by Roshan on Sep 27, 2019; 1:52pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/WARNING-OGG-02544-Oracle-GoldenGate-Delivery-for-Oracle-reploggt-prm-Unhandled-error-ORA-01031-insuf-tp7707p7715.html

Hi,

thanks Erman.

I managed to get the table error. I tried for 2 different RBAs and it the same table

ora12c@dware1:/ogg/ora12c$ ./logdump

Oracle GoldenGate Log File Dump Utility for Oracle
Version 18.1.0.0.0 OGGCORE_18.1.0.0.0_PLATFORMS_180928.0432

Copyright (C) 1995, 2018, Oracle and/or its affiliates. All rights reserved.

Logdump 18 >open /ogg/ora12c/dirdat/cd000000251
Current LogTrail is /ogg/ora12c/dirdat/cd000000251
Logdump 19 >pos 277953568
Reading forward from RBA 277953568
Logdump 20 >detail data
Logdump 21 >ggstoken detail
Logdump 22 >sfh

2019/09/27 17:29:51.000.098 GGSUnifiedUpdate Len 32 RBA 277953568
Name: CLM_TT.WF_WORKFLOW (TDR Index: 28)
After Image: Partition 12 G b
0000 000e 0000 000a 0000 0000 0000 0007 2e89 0000 | ....................
000a 0000 0000 0000 0007 2e89 | ............
Before Image Len 18 (x00000012)
BeforeColumnLen 14 (x0000000e)
Column 0 (x0000), Len 10 (x000a)
0000 0000 0000 0007 2e89 | ..........

After Image Len 14 (x0000000e)
Column 0 (x0000), Len 10 (x000a)
0000 0000 0000 0007 2e89 | ..........

GGS tokens:
TokenID x58 'X' ALTFORMAT Info x01 Length 4
0009 0024 | ...$
TokenID x52 'R' ORAROWID Info x00 Length 20
4141 4255 4934 4142 5541 4143 4d33 6e41 4143 0001 | AABUI4ABUAACM3nAAC..
TokenID x4c 'L' LOGCSN Info x00 Length 12
3236 3636 3039 3133 3838 3638 | 266609138868
TokenID x36 '6' TRANID Info x00 Length 13
302e 3531 2e35 302e 3336 3539 39 | 0.51.50.36599
TokenID x69 'i' ORATHREADID Info x01 Length 2
0002 | ..

Logdump 23 >exit
ora12c@dware1:/ogg/ora12c$ ./logdump

Oracle GoldenGate Log File Dump Utility for Oracle
Version 18.1.0.0.0 OGGCORE_18.1.0.0.0_PLATFORMS_180928.0432

Copyright (C) 1995, 2018, Oracle and/or its affiliates. All rights reserved.

Logdump 23 >open /ogg/ora12c/dirdat/cd000000251
Current LogTrail is /ogg/ora12c/dirdat/cd000000251
Logdump 24 >pos 354541248
Reading forward from RBA 354541248
Logdump 25 >detail data
Logdump 26 >ggstoken detail
Logdump 27 >sfh

2019/09/27 17:40:24.000.101 GGSUnifiedUpdate Len 32 RBA 354541248
Name: CLM_TT.WF_WORKFLOW (TDR Index: 28)
After Image: Partition 12 G b
0000 000e 0000 000a 0000 0000 0000 0007 2e4b 0000 | .................K..
000a 0000 0000 0000 0007 2e4b | ...........K
Before Image Len 18 (x00000012)
BeforeColumnLen 14 (x0000000e)
Column 0 (x0000), Len 10 (x000a)
0000 0000 0000 0007 2e4b | .........K

After Image Len 14 (x0000000e)
Column 0 (x0000), Len 10 (x000a)
0000 0000 0000 0007 2e4b | .........K

GGS tokens:
TokenID x58 'X' ALTFORMAT Info x01 Length 4
0009 0024 | ...$
TokenID x52 'R' ORAROWID Info x00 Length 20
4141 4255 4934 4142 5541 4143 4d36 6241 4144 0001 | AABUI4ABUAACM6bAAD..
TokenID x4c 'L' LOGCSN Info x00 Length 12
3236 3636 3039 3432 3035 3737 | 266609420577
TokenID x36 '6' TRANID Info x00 Length 13
302e 3333 2e36 302e 3330 3035 38 | 0.33.60.30058
TokenID x69 'i' ORATHREADID Info x01 Length 2
0001 | ..

Regards,

Roshan