This discussion is archived
3 Replies Latest reply: Jan 19, 2013 12:50 AM by 655280 RSS

Discoverer Connection Issue

user605933 Newbie
Currently Being Moderated
Hi All,

I am getting below error while connecting to Discoverer Desktop & Discoverer Admin..I am able to connect the Discoverer Plus. I am using the correct tnsname as I am able to connect the database but facing issue in Discoverer.

ora-12154:TNS :Could not resolve the connect identifier specified

Thanks
  • 1. Re: Discoverer Connection Issue
    user605933 Newbie
    Currently Being Moderated
    Can anyone update the below issue.
  • 2. Re: Discoverer Connection Issue
    PatrickBacon Explorer
    Currently Being Moderated
    Hi,

    Do you have multiple oracle homes? If this is the case, you want to make sure that the tnsname.ora file associated with the oracle home associated with the Disco Admin tool is set-up properly.

    Are you logging in as the EUL owner or as an APPS user (assuming you have an APPS implementation)? There are set-ups that need to performed before this will work (which are explained in the article below....e.g. the secure file).

    Have you looked at the Knowledge Base article, "Questions And Guidance For Troubleshooting Common Discoverer Desktop and Administrator Connection Issues [ID 415614.1]"?

    Patrick
  • 3. Re: Discoverer Connection Issue
    655280 Newbie
    Currently Being Moderated
    This error is related to the network connectivity. You have to verify & note the I.P. address of database server where your EUL is created. Update the tnsnames.ora in the $Discover_home/network/admin with the correct I.P. address/hostname, database name & port no. of the EUL database.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points