book
Article ID: KB0075440
calendar_today
Updated On:
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.
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 ?