Skip to Main Content

GoldenGate

Announcement

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

Initial Load is failing

JhilMar 25 2024

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

Comments
Post Details
Added on Mar 25 2024
1 comment
58 views