My Oracle Support Banner

Goldengate Dblogin Giving Error But Sqlplus Is Able To Make The Connection (Doc ID 2561899.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate - Version to [Release 12.3 to 12.2]
Information in this document applies to any platform.


Get "ORA-12533: TNS:illegal ADDRESS parameters" when you use dblogin .  But it works in sqlplus with the same TNS name.
Using "SQLNET.COMPRESSION = on" in sqlnet.ora


GGSCI > dblogin userid c##ogg@<tns_db>
ERROR: OCI Error ORA (status = 12533-ORA-12533: TNS:illegal ADDRESS parameters


/home/oracle> sqlplus c##ogg@<tns_db>

SQL*Plus: Release Production on Mon Jun 17 17:58:31 2019

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Enter password:
Last Successful login time: Mon Jun 17 2019 17:17:48 -04:00

Connected to:
Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics, Real Application Testing and Unified Auditing options

SQL> exit




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.