Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 49 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 287 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 110 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI 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
