ORA-12505 Error Connecting From Veridata GUI To Exadata Container Database (Doc ID 2333623.1)

Last updated on FEBRUARY 10, 2020

Applies to:

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

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