My Oracle Support Banner

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

Last updated on AUGUST 19, 2019

Applies to:

Oracle Discoverer - Version 4.1.48.08 to 11.1.1.7.0 [Release 4.1 to 11g]
Information in this document applies to any platform.
***Checked for relevance on 09-JuL-2018***


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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.