ORA-12505 Error Connecting From Veridata GUI To Exadata Container Database
(Doc ID 2333623.1)
Last updated on FEBRUARY 10, 2020
Applies to:Oracle GoldenGate Veridata - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
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
OGGV-00119 OGGV-60025 ORA-12505
The tns entry that is being used in the database.url string refers to the pluggable not the container and scan address:
(ADDRESS = (PROTOCOL = TCP)(HOST = <scan>)(PORT = <port>))
(SERVER = DEDICATED)
(SERVICE_NAME = <service_name>)
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