GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle AWS RDS not able to connect

user10126973Jul 19 2023

Hi All,

I am trying replicate the data from premise to AWS RDS oracle , I am able to connect SQL developer remotely but I am not able to connect from ggsci

GG version and database version details

Oracle GoldenGate Command Interpreter for Oracle
Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Oct 18 2019 01:38:51
Operating system character set identified as UTF-8.
GGSCI (stdby1) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING MYEXT 00:00:00 00:00:05

GGSCI (stdby1) 3> DBLOGIN USERID ggate@xxxxxxx.cgcu09cfh01bac.us-east-2.rds.amazonaws.com, PASSWORD ggate
ERROR: OCI Error ORA (status = 12154-ORA-12154: TNS:could not resolve the connect identifier specified
).

ggate =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxx.cgcu09cfh01bac.us-east-2.rds.amazonaws.com)(PORT = 1521))

(CONNECT_DATA =
(SERVICE_NAME = DATABASE)
)
)

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxx.cgcu09cfh01bac.us-east-2.rds.amazonaws.com)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = DATABASE)))
TNS-12545: Connect failed because target host or object does not exist
[oracle@stdby1 admin]$