Accessing Discoverer 11g Plus/Viewer from EBS Fails With Error ORA-12154: TNS:Could Not Resolve The Connect Identifier Specified
Last updated on JANUARY 31, 2017
Applies to:Oracle Discoverer - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 11g]
Information in this document applies to any platform.
***Checked for relevance on 23-Oct-2014***
After setting connection for Discoverer 11g to E-Business 11i or 12, connection doesn't works from Core EBS Application links, they returns 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.
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