How to resolve "ORA-12505 :TNS listener does not currently know of SID given in connect descriptor" while connecting to Oracle12 database in TIBCO Data Virtualization?
Article ID: KB0070307
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All Supported Versions |
Description
Users may encounter the error mentioned when connecting to the Oracle12 database from TIBCO Data Virtualization. This article illustrates the steps to resolve the error.
Issue/Introduction
This article explains the steps to resolve "ORA-12505:TNS listener does not currently know of SID given in connect descriptor" while connecting to Oracle12 database in TIBCO Data Virtualization.
Environment
All supported environments
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 given below:
Change the below:
To:
3. Test connection to ensure the connection works and save the changes.
2. On the Connection URL pattern, change the ":" between port and service name to "/" as given below:
Change the below:
To:
3. Test connection to ensure the connection works and save the changes.
Feedback
Yes
No
Powered by
