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