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

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Veronika.

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

Answered by: Connor McDonald - Last updated: March 31, 2020 - 1:34 am UTC

Category: Golden Gate - Version: 19 Standart Edition

Viewed 100+ 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 we 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.

More to Explore

Administration

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