Accessing Discoverer 11g Plus/Viewer from EBS Fails With Error ORA-12154: TNS:Could Not Resolve The Connect Identifier Specified (Doc ID 1354848.1)

Last updated on JANUARY 31, 2017

Applies to:

Oracle Discoverer - Version 11.1.1.2.0 to 11.1.1.4.0 [Release 11g]
Information in this document applies to any platform.
***Checked for relevance on 23-Oct-2014***

Symptoms


After setting connection for Discoverer 11g to E-Business 11i or 12, connection doesn't works from Core EBS Application links, they returns error :

Connection Error.
- Oracle BI Discoverer is unable to authenticate using the password provided. This can happen due to an invalid password or because the password was lost while using back, forward, or refresh in your browser. Enter the password again to continue.
- Failed to connect to database - ORA-12154: TNS:could not resolve the connect identifier specified



The applications ICX profiles are well configured and the same connection works fine from Discoverer standalone connection (ie. http://servername.domain:port/discoverer/viewer) and from sql*plus with same username/password@dbalias.

This problem occurs in an Oracle Applications environment that is Oracle Real Application Clusters (RAC) aware.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms