Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Initial Load is Failed -

JhilMar 23 2024 — edited Mar 24 2024

Dear Experts,

I am trying to initiate a initial load but it was not successful.

Kindly help me to fix it.

DB Version is 19.22 and OGG Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO

>> Source Side

GGSCI (dgprim) 1> sh cat ./dirprm/initle.prm

EXTRACT INITLE
userid ggs,password ggs
RMTHOST replica,mgrport 7809
RMTTASK REPLICAT,GROUP INITLR
TABLE FOX.EMP;

GGSCI (dgprim) 3> start extract INITLE

Sending START request to MANAGER ...
EXTRACT INITLE starting

GGSCI (dgprim) 4> info INITLE

EXTRACT INITLE Initialized 2024-03-24 04:46 Status STARTING
Checkpoint Lag Not Available
Process ID 1852
Log Read Checkpoint Not Available
First Record Record 0
Task SOURCEISTABLE

>> Replicat Parameter

GGSCI (replica) 5> sh cat ./dirprm/initlr.prm

REPLICAT INITLR
userid ggs, password ggs
ASSUMETARGETDEFS
MAP FOX.EMP, TARGET TOM.EMP;

>> Error Log

[oracle@dgprim ogg_home]$ tail -50f ggserr.log

2024-03-24T05:14:35.015+1100  INFO    OGG-01889  Oracle GoldenGate Capture for Oracle, initle.prm:  Flush size (max message size) is set to 27,985.
2024-03-24T05:14:35.215+1100  INFO    OGG-01851  Oracle GoldenGate Capture for Oracle, initle.prm:  filecaching started: thread ID: 140061555271424.
2024-03-24T05:14:35.215+1100  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, initle.prm:  Virtual Memory Facilities for: COM
                                 anon alloc: mmap(MAP_ANON)  anon free: munmap
                                 file alloc: mmap(MAP_SHARED)  file free: munmap
                                 target directories:
                                 /u01/app/oracle/product/ogg19/ogg_home/dirtmp.
2024-03-24T05:14:35.324+1100  INFO    OGG-25340  Oracle GoldenGate Capture for Oracle, initle.prm:
                             Database Version:
                             Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production.
2024-03-24T05:14:35.324+1100  INFO    OGG-25341  Oracle GoldenGate Capture for Oracle, initle.prm:
                             Database Language and Character Set:
                             NLS_LANGUAGE     = "AMERICAN"
                             NLS_TERRITORY    = "AMERICA"
                             NLS_CHARACTERSET = "AL32UTF8".
2024-03-24T05:14:35.361+1100  INFO    OGG-06509  Oracle GoldenGate Capture for Oracle, initle.prm:  Using the following key columns for source table FOX.EMP: EMPNO.
2024-03-24T05:14:35.361+1100  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, initle.prm:  EXTRACT INITLE started.
2024-03-24T05:14:39.331+1100  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info EXTRACT INITLE.


2024-03-24T05:14:41.455+1100  ERROR   OGG-01201  Oracle GoldenGate Capture for Oracle, initle.prm:  Error reported by MGR : Access denied.
2024-03-24T05:14:41.455+1100  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, initle.prm:  PROCESS ABENDING.


2024-03-24T05:19:22.957+1100  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): edit param INITLE.
2024-03-24T05:21:23.686+1100  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info INITLE.
2024-03-24T05:21:33.757+1100  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start extract INITLE.
2024-03-24T05:21:33.760+1100  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host [192.168.127.131]:31082 (START EXTRACT INITLE ).
2024-03-24T05:21:33.764+1100  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT INITLE starting.
2024-03-24T05:21:33.943+1100  INFO    OGG-01017  Oracle GoldenGate Capture for Oracle, initle.prm:  Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.
2024-03-24T05:21:33.943+1100  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, initle.prm:  EXTRACT INITLE starting.
2024-03-24T05:21:33.943+1100  INFO    OGG-03059  Oracle GoldenGate Capture for Oracle, initle.prm:  Operating system character set identified as UTF-8.
2024-03-24T05:21:33.943+1100  INFO    OGG-02695  Oracle GoldenGate Capture for Oracle, initle.prm:  ANSI SQL parameter syntax is used for parameter parsing.
2024-03-24T05:21:33.961+1100  INFO    OGG-01360  Oracle GoldenGate Capture for Oracle, initle.prm:  EXTRACT is running in Initial Load mode.
2024-03-24T05:21:34.062+1100  INFO    OGG-01889  Oracle GoldenGate Capture for Oracle, initle.prm:  Flush size (max message size) is set to 27,985.
2024-03-24T05:21:34.269+1100  INFO    OGG-01851  Oracle GoldenGate Capture for Oracle, initle.prm:  filecaching started: thread ID: 140017780274944.
2024-03-24T05:21:34.269+1100  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, initle.prm:  Virtual Memory Facilities for: COM
                                 anon alloc: mmap(MAP_ANON)  anon free: munmap
                                 file alloc: mmap(MAP_SHARED)  file free: munmap
                                 target directories:
                                 /u01/app/oracle/product/ogg19/ogg_home/dirtmp.
2024-03-24T05:21:34.352+1100  INFO    OGG-25340  Oracle GoldenGate Capture for Oracle, initle.prm:
                             Database Version:
                             Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production.
2024-03-24T05:21:34.352+1100  INFO    OGG-25341  Oracle GoldenGate Capture for Oracle, initle.prm:
                             Database Language and Character Set:
                             NLS_LANGUAGE     = "AMERICAN"
                             NLS_TERRITORY    = "AMERICA"
                             NLS_CHARACTERSET = "AL32UTF8".
2024-03-24T05:21:34.392+1100  INFO    OGG-06509  Oracle GoldenGate Capture for Oracle, initle.prm:  Using the following key columns for source table FOX.EMP: EMPNO.
2024-03-24T05:21:34.392+1100  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, initle.prm:  EXTRACT INITLE started.
2024-03-24T05:21:38.061+1100  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info INITLE.


2024-03-24T05:21:39.471+1100  ERROR   OGG-01201  Oracle GoldenGate Capture for Oracle, initle.prm:  Error reported by MGR : Access denied.
2024-03-24T05:21:39.471+1100  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, initle.prm:  PROCESS ABENDING.

>> Source side Table is existing :

SQL> select count(*) from fox.emp;

COUNT(*)
----------
14

SQL> desc fox.emp
Name Null? Type
----------------------------------------- -------- ----------------------------
EMPNO NOT NULL NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SAL NUMBER(7,2)
COMM NUMBER(7,2)
DEPTNO NUMBER(2)

but target side, no data.

Thanks

Comments
Post Details
Added on Mar 23 2024
0 comments
51 views