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!

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.

Facing OGG-02830 error while creating classic extract

Umesh SharmaFeb 18 2025

HI ALL,

I am trying to create classic extract in goldengate microservices architecture(19.22.0.0.240124) via goldengate hub machine on database 11g(11.2.0.4) but i am facing ERROR OGG-02830 Formatting error, ERROR OGG-01668 PROCESS ABENDING.

Below is my report file of extract:-

***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 19.22.0.0.240124 OGGCORE_19.22.0.0.0OGGRU_PLATFORMS_240125.1200_FBO
Linux, x64, 64bit (optimized), Oracle 19c on Jan 25 2024 16:06:37

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

               Starting at 2025-02-18 12:40:07  

***********************************************************************

Operating System Version:
Linux
Version #1 SMP Thu Mar 14 14:20:09 EDT 2024, Release 4.18.0-513.24.1.el8_9.x86_64
Node: localhost.localdomain
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited

Process id: 917082

Description: extract from 11g(src)

***********************************************************************
** Running with the following parameters **
***********************************************************************

2025-02-18 12:40:07 INFO OGG-03059 Operating system character set identified as UTF-8.

2025-02-18 12:40:07 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.

2025-02-18 12:40:07 INFO OGG-01360 EXTRACT is running in Classic mode.
EXTRACT ext_11g
USERIDALIAS gg_tgt DOMAIN OracleGoldenGate
EXTTRAIL mm
TRANLOGOPTIONS DBLOGREADER
table test.table1;

2025-02-18 12:40:08 INFO OGG-02734 Using heartbeat table from schema ggadmin.

2025-02-18 12:40:08 INFO OGG-01635 BOUNDED RECOVERY: not used. NORMAL RECOVERY only used due to altered checkpoint.

2025-02-18 12:40:08 INFO OGG-01815 Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/micro_gg/servers/deploy2/var/run/BR/EXT_11G.

Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR = /micro_gg/servers/deploy2/var/run/

2025-02-18 12:40:08 INFO OGG-01851 filecaching started: thread ID: 140108793992960.

2025-02-18 12:40:08 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/micro_gg/servers/deploy2/var/temp.

2025-02-18 12:40:08 INFO OGG-25340
Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Solaris: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production.

2025-02-18 12:40:08 INFO OGG-25341
Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "WE8MSWIN1252".

2025-02-18 12:40:08 INFO OGG-06604 Database ORCL CPU info: CPU Count 4, CPU Core Count 4, CPU Socket Count 1.

Maximum supported ASM read buffer size is 4096 KB

2025-02-18 12:40:08 INFO OGG-02089 Source redo compatibility version is: 11.2.0.4.0.

2025-02-18 12:40:08 INFO OGG-02776 Native data capture is enabled for Oracle NUMBER data type.

2025-02-18 12:40:08 INFO OGG-01515 Positioning to begin time 2025 M02 18 12:36:25.

Source Context :
SourceModule : [er.redo.ora.rdr]
SourceID : [er/redo/oracle/redoorardr.c]
SourceMethod : [getLogPosition]
SourceLine : [5594]
ThreadBacktrace : [15] elements
: [/micro_gg/gg_home/bin/../lib/libgglog.so(CMessageContext::AddThreadContext())]
: [/micro_gg/gg_home/bin/../lib/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/micro_gg/gg_home/bin/../lib/libgglog.so(_MSG_DateTime_String(CSourceContext*, int, timeval, char const*, CMessageFactory::MessageDisposition))]
: [/micro_gg/gg_home/bin/extract()]
: [/micro_gg/gg_home/bin/extract(RedoClassic::positionIntoRedoLogFile(int, bool, bool, bool))]
: [/micro_gg/gg_home/bin/extract(ggs::er::OraTranLogDataSource::establishStartPoint(char))]
: [/micro_gg/gg_home/bin/extract(ggs::gglib::ggapp::ReplicationContext::establishStartPoints(char, ggs::gglib::ggdatasource::DataSourceParams const&))]
: [/micro_gg/gg_home/bin/extract(ggs::gglib::ggapp::ReplicationContext::initializeDataSources(ggs::gglib::ggdatasource::DataSourceParams&))]
: [/micro_gg/gg_home/bin/extract()]
: [/micro_gg/gg_home/bin/extract(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [/micro_gg/gg_home/bin/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
: [/micro_gg/gg_home/bin/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [/micro_gg/gg_home/bin/extract(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [/micro_gg/gg_home/bin/extract()]

2025-02-18 12:40:32 ERROR OGG-02830 Formatting error.

2025-02-18 12:40:32 ERROR OGG-01668 PROCESS ABENDING.


I can't use Integrated extract on my 11g(11.2.0.4) as it requires Patch 17030189 but i cant install any patch on my DB due to some restrictions


Also i tried TRANLOGOPTIONS DBLOGREADER parameter , but still error persisits


Any guess on what could be the problem?

Thanks in advance

Comments

James Su Feb 14 2025

Do you have a MOS account? You can see the solution here:

https://support.oracle.com/knowledge/Oracle%20Cloud/2767882_1.html

BTW the toad behavior is normal and I usually choose rollback.

ronald_2017 Feb 15 2025

No, I don't have. Can you please copy paste the solution? Thanks.

James Su Feb 15 2025

Please leave an email address.

ronald_2017 Feb 15 2025

I log in. However, it asks Support Identifier. What should I write?

Thanks

James Su Feb 16 2025

You need to purchase the service to see the content.

I may be able to help you in private but if you don't want to post your email I have no way to contact you.

ronald_2017 Feb 16 2025

First of all thanks for your help. My words are not for you. The illogical thing is why should I purchase the service in order to solve the problem which caused by Oracle. What is Oracle support is used for? Besides, it used to be send dm in Oracle forum. Apparently, it is not active now. These kinds of restrictions are really ridiculous in today's world.

BluShadow Feb 17 2025

Oracle support is for paying customers. Like most businesses, not everything is free.

A part of the contract with having support is that customers are not permitted to share the content that is given within support anywhere in public, hence why James cannot post the solution for you here.

For that error you're getting though, it's a bit of a deceptive message. You may want to look at your Firewall (or get your network guys to) as that's a likely cause.

ronald_2017 Feb 17 2025

For that error you're getting though, it's a bit of a deceptive message. You may want to look at your Firewall (or get your network guys to) as that's a likely cause.

After I login, I am redirected to registration page. I don't think it is related to firewall. It is written “Connect your User Account” and there is an item called Support Identifier. What should I type there?

Thanks.

Cookiemonster76 Feb 17 2025

I believe that BluShadow is talking about the error you're getting in toad there, not your issues with oracle support.

BluShadow Feb 17 2025

Indeed, I'm referring to the ORA-24757: duplicate transaction identifier
I'm not trying to tell you how to get into Oracle Support. For that you would need to have a customer support identifier CSID which you only get when you pay for support. If you're working for a company then maybe your company has support with Oracle? In which case your company would have someone who is the support administrator and can assign your login to have support with Oracle (they will tie up your login with the company's support identifier for you). In many companies this is a DBA who has this access.

ronald_2017 Feb 17 2025

First of all thanks for your support. The thing is, even I just select via db link I get ORA-24757 duplicate transaction identifier error. I didn't do any DML. I use it in my laptop, not for the company. It is for the educational purposes. Where should I check in firewall?

Cookiemonster76 Feb 17 2025

So where are these two DB's that you're linking together?

Is one of them on your laptop?

ronald_2017 Feb 17 2025

One is in my laptop. It is a test db. The other one is in my friend's virtual windows server. Maybe somethings need to be changed in the virtual server.

ronald_2017 6 days ago

What do you recommend? Thanks.

Cookiemonster76 5 days ago

Any and all firewalls between your laptop and the virtual windows server need to have the port(s) you're trying to use completely open.

Alternatively stop trying to link those 2 DBs.

Is there a specific reason you need to link to that DB?

If you're just trying out how DB links work you could just create a loopback link (one that connects to the same DB).

ronald_2017 3 days ago

Yes, I want to use dblink between each other. I just recreated the db link as shared this time. However, it gives another error. It works at first but then gives an error.

ronald_2017 3 days ago

I am just wondering that should I replace 'localhost' in the server's listener file with the server's IP address?

1 - 17

Post Details

Added on Feb 18 2025
1 comment
34 views