Connecting from Oracle Applications E-Business to Discoverer Fails with GWYUID and ORA-12154 Errors
Last updated on SEPTEMBER 27, 2016
Applies to:
Oracle Discoverer - Version 4.1.48.08 and laterInformation 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.
- 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.
- 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