Issue: OGG-01416  File KA000000028, with format RELEASE 9.0/9.5, does not match current format specification of RELEASE 12.3

  Issue: OGG-01416  File KA000000028, with format RELEASE 9.0/9.5, does not match current format specification of RELEASE 12.3   1           SYMPTOMS: OGG (https://linuxvm01:18100 LOCAL) 20> info EXT01 detail EXTRACT    EXT01  Last Started 2019-03-18 12:58   Status ABENDED Checkpoint Lag       58:45:47 (updated 47:38:58 ago) Log Read Checkpoint  Oracle Integrated Redo Logs                      2019-03-16 01:21:11                      SCN 0.404133134 […]

OGG4DB2 for IBM i PURGEOLDEXTRACTS not working

  OGG4DB2 for IBM i PURGEOLDEXTRACTS not working 1.1        SYMPTOMS We set PURGEOLDEXTRACTS for mgr process in OGG4DB2, but purge action not working to clean down the old trail files. > view params mgr Port 7809 PURGEOLDEXTRACTS /GoldenGate/dirdat/SA*, USECHECKPOINTS, MINKEEPDAYS 7 > pwd /GoldenGate/dirdat > ls -lrt total 2752512 -rw-r—– 1 datahub 0 199998879 16 […]

OGG-02198 Incompatible record (logical EOF) in trail file

OGG-02198 Incompatible record (logical EOF) in trail file Symptoms: 2019-10-17 14:48:43 ERROR OGG-02171 Error reading LCR from data source. Status 509, data source type 0. Source Context : SourceModule : [gglib.ggtrail.TrailDataSource] SourceID : [/scratch/aime/adestore/views/aime_adc4150505/oggcore/OpenSys/src/gglib/ggtrail/TrailDataSource.cpp] SourceMethod : [checkLogicalEOF] SourceLine : [3829] ThreadBacktrace : [15] elements : [/ogg/app/oracle/ogg4bd/12.3.2.1.0/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f9a8d6230ae]] : [/ogg/app/oracle/ogg4bd/12.3.2.1.0/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, …)+0x6ac) [0x7f9a8d6139b c]] : […]

Create and Drop type in Oracle DB

create or replace TYPE “ora_typ_01” AS OBJECT ( delievery_order_number VARCHAR2(20), haulage_number VARCHAR2(20), count_issued NUMBER, count_total NUMBER, document_status VARCHAR2(10) ) Type ora_typ_01 compiled CREATE OR REPLACE EDITIONABLE TYPE ora_typ_01 AS OBJECT ( delievery_order_number VARCHAR2(20), haulage_number VARCHAR2(20), count_issued NUMBER, count_total NUMBER, document_status VARCHAR2(10) ) Type ORA_TYP_01 compiled select * from dba_objects where object_type=’TYPE’ and owner=’LEOSUNNY’; LEOSUNNY ora_typ_01 […]

Archive log mining steps(logminer to html)

1.1        Archive log mining steps(logminer to html): 1.1.1        STEP 1: Execute the below query on the target db alter session set nls_date_format=’dd-mm-yyyy hh24:mi’; select name,thread#,sequence#,first_time,next_time from v$archived_log where first_time between to_date(’05-05-2019 16:00′) and to_date(’05-05-2019 20:00′); <<<<<<<<<<<<<<<<Put the time when the record was inserted on source around example around 2019/05/05 17:43:56.030.651, we need to find corresponding […]

Example: OGG Microservice Architecture RestAPI Commands

–Get the information of Distribution Path curl -u oggadmin:oracle -k -H “Content-Type: application/json” -H “Accept: application/json” -X GET http://linuxvm01:9102/services/v2/sources curl -u oggadmin:Oracle1! -k -H “Content-Type: application/json” -H “Accept: application/json” -X GET https://127.0.0.1:9102/services/v2/sources curl -u oggadmin:Oracle1! -k -H “Content-Type: application/json” -H “Accept: application/json” -X GET https://linuxvm01:19102/services/v2/sources/DIST01| python -m json.tool curl -u oggadmin:Oracle1! -k -H “Content-Type: application/json” […]

ORA-31623: a job is not attached to this session via the specified handle

ORA-31623: a job is not attached to this session via the specified handle SYMPTOMS UDE-31623: operation generated ORACLE error 31623 ORA-31623: a job is not attached to this session via the specified handle ORA-06512: at “SYS.DBMS_DATAPUMP”, line 3905 ORA-06512: at “SYS.DBMS_DATAPUMP”, line 5203 ORA-06512: at line 1 UDI-31623: operation generated ORACLE error 31623 ORA-31623: a […]

OGG-00868 Error code 1291, error message ORA-01291 missing logfile

Symptoms: 2019-07-29 10:15:56 INFO OGG-02248 Logmining server DDL filtering enabled. Source Context : SourceModule : [er.redo.oraxo] SourceID : [/scratch/aime/adestore/views/aime_adc00jza/oggcore/OpenSys/src/app/er/redo/oracle/redooraix.c] SourceMethod : [REDOORAIX_abend_if_missing_logfile] SourceLine : [8360] ThreadBacktrace : [16] elements : [ng::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract()] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::er::OraTranLogDataSource::setup())] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::er::OraTranLogDataSource::setup())] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract()] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::gglib::MultiThreading::MainThread::ExecMain())] : […]

GG-02022 Logmining server does not exist on this Oracle database

GG-02022 Logmining server does not exist on this Oracle database Symptoms: 2019-07-29 11:49:40 ERROR OGG-02022 Logmining server does not exist on this Oracle database. Cause: The extract is not registered in DB SOLUTION: 1)Register extract 2)Add extract 3)Start extract Set the ORACLE_HOME ORACLE_SID using the SETENV parameter in the extract parameter file Below is the […]