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?
Article ID: KB0075440
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 ?
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:
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.
2. On the Connection URL pattern , change the " ; " between port and service name to "/" as illustrated below:
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.
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 ?
Additional Information
Feedback
Yes
No
Powered by
