Dear Experts,
Extract initial load is failing.
As checked user credentials are correct for ggadmin but getting error when i tried to startup the extract.
$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 21.3.0.0.0 OGGCORE_21.3.0.0.0_PLATFORMS_210728.1047_FBO
Oracle Linux 7, x64, 64bit (optimized), Oracle Database 21c and lower supported versions on Jul 29 2021 03:59:23
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2021, Oracle and/or its affiliates. All rights reserved.
GGSCI (HRMS-DB-VP06) 1> dblogin useridalias gguser1
Successfully logged into database.
GGSCI (HRMS-DB-VP06 as ggadmin@hrmsdb) 2> exit
[oracle@HRMS-DB-VP06 gg21home]$
[oracle@HRMS-DB-VP06 gg21home]$ sqlplus ggadmin@HRMSDB
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Mar 25 19:16:57 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Enter password:
Last Successful login time: Mon Mar 25 2024 19:16:44 +05:30
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
GGSCI (HRMS-DB-VP06) 1> sh cat ./dirprm/initlext.prm
EXTRACT INITLEXT
USERIDALIAS gguser1
RMTHOST 172.31.17.121, mgrport 7809
RMTTASK REPLICAT, GROUP INITLREP
TABLE HRMS.DRAFT_PAY_CUR_FULL_BK_09_2013;
GGSCI (HRMS-DB-VP06) 2> start initlext
Sending START request to Manager ...
Extract group INITLEXT starting.
GGSCI (HRMS-DB-VP06) 3> info initlext
Extract INITLEXT Initialized 2024-03-25 18:36 Status STOPPED
Checkpoint Lag Not Available
Log Read Checkpoint Not Available
First Record Record 0
Task SOURCEISTABLE
>> ggeerr.log
$ tail -20f ggserr.log
2024-03-25T19:11:41.983+0530 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, initlext.prm: PROCESS ABENDING.
2024-03-25T19:11:47.963+0530 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info extract INITLEXT.
2024-03-25T19:16:44.003+0530 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): dblogin useridalias gguser1.
2024-03-25T19:18:13.719+0530 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start initlext.
2024-03-25T19:18:13.720+0530 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from application GGSCI on host [172.31.17.119]:64592: START EXTRACT INITLEXT.
2024-03-25T19:18:13.726+0530 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: Extract group INITLEXT starting.
2024-03-25T19:18:13.807+0530 INFO OGG-01017 Oracle GoldenGate Capture for Oracle, initlext.prm: Wildcard resolution set to IMMEDIATE because SOURCEISTABLE Extract is used.
2024-03-25T19:18:13.817+0530 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, initlext.prm: Extract group EXTRACT INITLEXT starting.
2024-03-25T19:18:13.817+0530 INFO OGG-03059 Oracle GoldenGate Capture for Oracle, initlext.prm: Operating system character set identified as UTF-8.
2024-03-25T19:18:13.817+0530 INFO OGG-02695 Oracle GoldenGate Capture for Oracle, initlext.prm: ANSI SQL parameter syntax is used for parameter parsing.
2024-03-25T19:18:13.820+0530 INFO OGG-01360 Oracle GoldenGate Capture for Oracle, initlext.prm: EXTRACT is running in Initial Load mode.
2024-03-25T19:18:13.837+0530 INFO OGG-01889 Oracle GoldenGate Capture for Oracle, initlext.prm: Flush size (max message size) is set to 27,985.
2024-03-25T19:18:13.892+0530 INFO OGG-03541 Oracle GoldenGate Capture for Oracle, initlext.prm: Oracle Environment Variables:
LD_LIBRARY_PATH = /u01/app/oracle/product/19.0.0/dbhome_1/:/gg_home/gg21home/:/tmp/OraInstall2024-03-25_01-02-25PM/ext/bin:/tmp/OraInstall2024-03-25_01-02-25PM/ext/lib:/u01/app/oracle/product/19.0.0/dbhome_1/lib:/u01/app/oracle/product/19.0.0/dbhome_1/oracm/lib:/lib:/usr/lib:/usr/local/lib:/tmp/OraInstall2024-03-25_01-02-25PM/oui/lib/linux64:::.
2024-03-25T19:18:13.958+0530 INFO OGG-03542 Oracle GoldenGate Capture for Oracle, initlext.prm: Failed to connect to the database. Verify that the connection string and following environment variables are correct:
LD_LIBRARY_PATH = /u01/app/oracle/product/19.0.0/dbhome_1/:/gg_home/gg21home/:/tmp/OraInstall2024-03-25_01-02-25PM/ext/bin:/tmp/OraInstall2024-03-25_01-02-25PM/ext/lib:/u01/app/oracle/product/19.0.0/dbhome_1/lib:/u01/app/oracle/product/19.0.0/dbhome_1/oracm/lib:/lib:/usr/lib:/usr/local/lib:/tmp/OraInstall2024-03-25_01-02-25PM/oui/lib/linux64:::.
2024-03-25T19:18:13.958+0530 ERROR OGG-00303 Oracle GoldenGate Capture for Oracle, initlext.prm: Unable to connect to database using user ggadmin@HRMSDB. Ensure that the necessary privileges are granted to the user.
Login to the database as user ggadmin failed because of error ORA-12154: TNS:could not resolve the connect identifier specified.
2024-03-25T19:18:13.958+0530 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, initlext.prm: PROCESS ABENDING.
2024-03-25T19:18:18.340+0530 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info initlext.
Thanks
Thanks