Actions to Verify When Running Into ORA-01017 While Creating Datasource
(Doc ID 1556742.1)
Last updated on APRIL 06, 2021
Applies to:Oracle Application Object Library - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
The <Note:974949.1> "Oracle E-Business Suite Software Development Kit for Java (includes AppsDataSource, Java Authentication and Authorization Service, session management)" explains the steps to create a Datasource for external applications to connect to the E-Business Suite database.
An error often reported here is the ORA-01017: invalid username/password; logon denied which normally indicates that a database user passed incorrect credentials. However when it comes to creating Datasource the ORA-01017 is raised as soon as there is an issue with the connection and the actual ORA message is not reporting the actual error.
This document will provide a number of things to verify which may assist in troubleshooting the ORA-01017 when raised in context of Datasource.
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
|1. Verify the FND user defined in the Datasource|
|2. Verify relevant profile options|
|3. Small test class to verify the connection|