Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Direct Database Request results in ORA-12154: TNS:could not resolve the connect identifier specified
Answers
-
Both of those and just SID as well.
0 -
i'm assuming your server have the tnsnames.ora file already? are you able to connect to DB from your server?
also, you are using the right call interface, OCI 0g/11g in your repository?
0 -
Yes to both
0 -
i tested on my side and it works fine. i'm using 12.2.1.2, but i don't think the version matters.
i only use the easyconnect for my data source, so i don't have tnsnames anywhere.
the error msg says it can't resolve your SID. so it can't find your tnsnames.ora or something is not in the environment path.
0 -
The issue was with the DB, I wasn't made aware that the DB was upgraded recently and the TNSNAMES was changed. Thank you all for your efforts.
0
