Leo is Sunny @_@
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 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 […]
We can’t generate compressed trail files now. you can only configure Oracle GoldenGate to compress trail files in its extract pump process and distpath where you can specify COMPRESS in the RMTHOST option. For example, RMTHOST localhost, mgrport 7789, compress, compressthreshold 512 COMPRESS This option is valid for online or batch Extract […]
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 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 […]
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 […]
–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 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 […]
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 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 […]