Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing

Post Details

Added on Feb 25 2025
6 comments
95 views