Connecting from Oracle Applications E-Business to Discoverer Fails with GWYUID and ORA-12154 Errors (Doc ID 470471.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Oracle Discoverer - Version 4.1.48.08 and later
Information in this document applies to any platform.
***Checked for relevance on 02-Jun-2015***


Symptoms

The following error can occur when connecting to Discoverer Plus or Viewer via an Oracle Applications E-Business (E-BIS) Personal Home Page (PHP) menu item or link:

A connection error has occurred.
- OracleBI Discoverer was 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. Please enter the password again to continue.
- Failed to connect to database - ORA-12154: TNS:could not resolve the connect identifier specified.


A different error may occur when connecting directly from Discoverer Viewer or Plus connection page:

A connection error has occurred.
- Unable to connect, possibly due to an invalid Applications GWYUID setting please contact your
Discoverer manager.

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