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 […]

OGG-02191 Incompatible record 104 in /trail/TR000000003, rba 1,589

OGG-02191 Incompatible record 104 in /trail/TR000000003, rba 1,589 when getting trail header. Symptoms: 2019-10-13 20:48:53 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_adc00jza/oggcore/OpenSys/src/gglib/ggtrail/TrailDataSource.cpp] SourceMethod : [readNextTrailRecord] SourceLine : [2687] ThreadBacktrace : [14] elements : [/ogg/oggma_12.3.0/bin/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**))] : [/ogg/oggma_12.3.0/bin/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))] : [/ogg/oggma_12.3.0/bin/replicat(_ZN3ggs5gglib14MultiThreading10MainThread3RunEiPPc+0xb5) […]

Issues: ACFS-03008: The volume could not be resized

Issues: ACFS-03008: The volume could not be resized Symptoms: oracle@scrboranl007090:/home/oracle % acfsutil size +50G /ogg_home/ acfsutil size: ACFS-03008: The volume could not be resized. The volume expansion limit has been reached. acfsutil size: ACFS-03216: The ADVM compatibility attribute for the diskgroup was below the required version (11.2.0.4.0) for unlimited volume expansions. oracle@scrboranl007090:/home/oracle % source asm.env […]

Test: OGG_extarct&reaplict with PK and duplicates

Test: OGG_extarct&reaplict with PK and duplicates 1. Source table without PK and OGG extract set the PK ”PKEY” 2. Target Table has PK “PKEY” and OGG replicat the PK ”PKEY” –Prepare the testing tables CREATE TABLE SOURCE.TST_TAB01 ( PKEY NUMBER(19) NOT NULL, TIME_IN TIMESTAMP(6), TIME_OUT TIMESTAMP(6), OGG_DATETIME DATE ) TABLESPACE USERS PCTUSED 0 PCTFREE 10 […]

Exaple: expdp&impdp in parfile

impdp_tab01_user.par directory=DMPDIR dumpfile=expdp_tab01_user.dmp logfile=impdp_tab01_user.log parallel=4 cluster=n EXCLUDE=INDEX EXCLUDE=TABLE_STATISTICS EXCLUDE=INDEX_STATISTICS TABLE_EXISTS_ACTION=REPLACE transform=disable_archive_logging:y transform=storage:n TABLES=USER.tab01 remap_schema=USER:USER remap_tablespace=USERS:USERS impdp c##ogg_user@ORCLPDB1 parfile=impdp_tab01_user.par vi expdp_tab01_user.par DIRECTORY=DMPDIR DUMPFILE=expdp_tab01_user.dmp LOGFILE=expdp_tab01_user.log CLUSTER=N PARALLEL=4 TABLES= USER.tab01 expdp c##ogg_user@pstg parfile=expdp_tab01_user.par vi expdp_orcl_preprod_data_schemas.par DIRECTORY=DMPDIR DUMPFILE=expdp_orcl_preprod_data_schemas_%U.dmp LOGFILE=expdp_orcl_preprod_data_schemas.log FLASHBACK_SCN=1197898541013 CLUSTER=N PARALLEL=4 SCHEMAS=USER,OGG EXCLUDE=TABLE_STATISTICS EXCLUDE=INDEX_STATISTICS vi impdp_orcl_preprod_data_schemas.par directory=DMPDIR dumpfile=expdp_orcl_preprod_data_schemas_1111.dmp logfile=imppdp_orcl_preprod_data_schemas_.log PARALLEL=10 CLUSTER=N SCHEMAS=USER,OGG TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y TRANSFORM=STORAGE:N vi expdp_orcl_preprod_data_user.par DIRECTORY=DMPDIR DUMPFILE=expdp_orcl_preprod_data_user_%U.dmp […]

OGG4BD to send boolean data to Cassandra

OGG4BD to send boolean data to Cassandra –Create target table in Cassandra CREATE TABLE TARGET.TARGET01 ( col1 text PRIMARY KEY, col5 float, col2 bigint, col3 timestamp, col4 boolean ) WITH bloom_filter_fp_chance = 0.01 AND caching = {‘keys’: ‘ALL’, ‘rows_per_partition’: ‘NONE’} AND comment = ” AND compaction = {‘class’: ‘org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy’, ‘max_threshold’: ’32’, ‘min_threshold’: ‘4’} AND compression […]

Alert the usage of tablespace

Alert the usage of tablespace —-Create tablespace for user create tablespace yw_cux_data  datafile ‘/u02/lsdb/yw_cux_data01.dbf’ size 100m; create user lsdb_yw identified by ****** default tablespace yw_cux_data temporary  tablespace temp; grant connect,dba to lsdb_yw; grant select on DBA_FREE_SPACE to lsdb_yw; grant select on  DBA_DATA_FILES to lsdb_yw; grant execute on sys.UTL_TCP to lsdb_yw; grant execute on sys.UTL_SMTP to […]

OGG-05259 The Extract’s recovery checkpoint LSN is not in the cdc.lsn_time_mapping table of database ‘test’.

OGG-05259 The Extract’s recovery checkpoint LSN 00009da1:0057deff:0004 is not in the cdc.lsn_time_mapping table of database ‘test’. Symptoms: 2019-10-08 14:33:14 INFO OGG-05257 For CDC tuning best practices, please see https://technet.microsoft.com/en-us/library/dd266396%28v=sql.100%29.aspx. 2019-10-08 14:33:14 WARNING OGG-05292 The Oracle GoldenGate capture job is running on database test with NOMANAGECDCCLEANUP. Oracle GoldenGate will not purge CDC enabled tables. Source Context […]