ORA-12505 Error Connecting From Veridata GUI To Exadata Container Database

(Doc ID 2333623.1)

Last updated on FEBRUARY 13, 2018

Applies to:

Oracle GoldenGate Veridata - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to set-up a veridata connection from the veridata GUI to a container database we are getting the following error in the GUI:

OGGV-00119: Agent remote message (101): OGGV-60025: User 'C##VERIDATA' could not connect to database: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor ; Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Error Codes:
OGGV-00119 OGGV-60025 ORA-12505

database.url=jdbc:oracle:thin:@<host>:<port>:<service_name>


The tns entry that is being used in the database.url string refers to the pluggable not the container and scan address:

<service_name> =
 (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = <scan>)(PORT = <port>))
  (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = <service_name>)
  )
 )


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms