Skip to Main Content
  • Questions
  • OGG-02030 Failed to set logmining server parameters back to default val

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Veronika.

Asked: March 30, 2020 - 5:27 am UTC

Last updated: October 31, 2022 - 4:01 am UTC

Version: 19 Standart Edition

Viewed 1000+ times

You Asked

I`ve try to start integrated Extract:
REGISTER EXTRACT EXTR_R DATABASE
ADD EXTRACT EXTR_R, INTEGRATED TRANLOG, begin now
ADD EXTTRAIL ./dirdat/lt, EXTRACT EXTR_R
START EXTRACT EXTR_R


with param file:
Extract EXTR_R
USERIDALIAS GGUSERSRC
exttrail ./dirdat/lt
LOGALLSUPCOLS
UPDATERECORDFORMAT COMPACT
STATOPTIONS RESETREPORTSTATS
REPORT at 15:00
REPORTROLLOVER AT 15:00
REPORTCOUNT EVERY 60 SECONDS, RATE  
Table hr.test_*;


and after start I get error:
INFO    OGG-06618  Oracle GoldenGate Capture for Oracle, extr_r.prm:  Database DBG125 Platform: Linux x86 64-bit.
ERROR   OGG-02030  Oracle GoldenGate Capture for Oracle, extr_r.prm:  Failed to set logmining server parameters back to default values.
ERROR   OGG-02042  Oracle GoldenGate Capture for Oracle, extr_r.prm:  OCI Error 23,605.
ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, extr_r.prm:  PROCESS ABENDING.


What were the problem parameters? How it can be fixed? Thanks, a lot for help.

and Connor said...

Check MOS 2521793.1

OGG changed to do some operations by default in parallel, which standard edition does not allow.

Chat to Support about a patch.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

ogg-02030: failed to set logmining server parameters back to default va

Rajat, October 27, 2022 - 4:23 pm UTC

ogg-02030: failed to set logmining server parameters back to default va

How to fix this

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database