Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fixing OGG-02171 Error reading LCR from data source; OGG-01091 Unable to open file...

Dan MurphyFeb 25 2025 — edited Feb 25 2025

Hi,

I am responsible for ~6,000 instances running world wide. My company embeds Oracle Database 19c and Oracle GoldenGate 19 into it's software product. I occasionally see the following error in ggserr.log:

2025-02-21T10:00:14.933-0600 ERROR OGG-02171 Oracle GoldenGate Capture for Oracle, pcapture.prm: Error reading LCR from data source. Status 500, data source type TrailDataSource.
2025-02-21T10:00:14.933-0600 ERROR OGG-01091 Oracle GoldenGate Capture for Oracle, pcapture.prm: Unable to open file "/home/root/home/company/oracle/oracle/product/gg/dirdat/V1035335/aa000000093" (error 2, No such file or directory).
2025-02-21T10:00:14.941-0600 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, pcapture.prm: PROCESS ABENDING.

What are the implications if I simply do the following to resolve the issue:

ggsci
dblogin userid stradmin@V1035335, password <password>
ALTER EXTRACT PCAPTURE, EXTSEQNO 0 EXTRBA 0
exit

Best,

Dan

This post has been answered by AlexLima-Oracle on Feb 25 2025
Jump to Answer
Comments
Post Details
Added on Feb 25 2025
6 comments
460 views