Connecting to Oracle EBS 11.5.10 with Discoverer 4i/10g Fails with ORA-01017 Invalid Username/Password Error
Last updated on AUGUST 07, 2017
Applies to:Oracle Discoverer - Version 4.1.48.06 to 10.1.2.3 [Release 4.1 to 10.1.2]
Information in this document applies to any platform.
Checked for relevance 03-MAY-2013.
You are trying to connect with Discoverer 4.1 / 9.0.4 Administration/Desktop Edition or Discoverer 4.1 / 9.0.4
Plus/Viewer Edition using an Oracle Application username/password but encounter the following error:
"Failed to connect to database - ORA-01017: invalid username/password; logon denied"
The checkbox, "Oracle Application user" is checked at the login window.
The userid and password are valid as the same user can successfully connect to Oracle Applications.
The Discoverer 4.1 one-off securtiy <Patch 2112426> and the latest 4.1.48 patch have been applied, but the problem still exists.
For Discoverer 10gR1, you are on Discoverer 220.127.116.11.
When generating a SQL*Net Trace for the failed connection attempt, an error is displayed:
"APP-FND-01542: This Applications Server is not authorized to access this database."
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