Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Received Response
41
Views
15
Comments
2»

Answers

  • 3240307
    3240307 Rank 4 - Community Specialist

    Both of those and just SID as well.

  • 3310714
    3310714 Rank 6 - Analytics & AI Lead

    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?

  • 3240307
    3240307 Rank 4 - Community Specialist

    Yes to both

  • 3310714
    3310714 Rank 6 - Analytics & AI Lead

    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. 

  • 3240307
    3240307 Rank 4 - Community Specialist

    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.