How to resolve "ORA-12505 :TNS listener does not currently know of SID given in connect descriptor" while connecting to Oracle12 pluggable database in TIBCO Data Virtualization?

How to resolve "ORA-12505 :TNS listener does not currently know of SID given in connect descriptor" while connecting to Oracle12 pluggable database in TIBCO Data Virtualization?

book

Article ID: KB0075440

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 8.1 and higher

Description

How to resolve "ORA-12505 :TNS listener does not currently know of SID given in connect descriptor" while connecting to pluggable database in Oracle12 even though all the details about service name /port and server name are accurate ?



 

Issue/Introduction

How to resolve "ORA-12505 :TNS listener does not currently know of SID given in connect descriptor" while connecting to pluggable database in Oracle12 ?

Resolution

1. In TDV Studio's configuration tab for the data source, select the Advanced tab under "Connection Information".
2. On the Connection URL pattern , change the " ; " between port and service name to "/" as illustrated below:

User-added image

3. Test connection to ensure the connection works and save the changes by clicking on the floppy-disk icon at the top left hand corner the screen.

 

Additional Information

https://stackoverflow.com/questions/30861061/ora-12505-tns-listener-does-not-currently-know-of-sid-given-in-connect-descript