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 NOVEMBER 21, 2019

Applies to:

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


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.


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

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