R12 E-Business Suite Applications Technology Stack OID / SSO Login Error 'ORA-01017: invalid username/password; logon denied' Error After Cloning and Changing the Apps Password
Last updated on MARCH 20, 2018
Applies to:Oracle E-Business Suite Technology Stack - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
E-Business Suite R12 Applications Technology Stack, OID / SSO Technologies related issues
After cloning an E-Business Suite instance, user synchronization failed from OID to E-Business Suite and DIP server logs show the following errors:
Exception Connecting to DB using service name :java.sql.SQLException: ORA-01017: invalid username/password; logon denied
Retrying with SID ..
Using SID Name to connect - URL : jdbc:oracle:thin:@xxxxxxx:12510:xxxx,user : APPS
Using Service Name to connect - URL : jdbc:oracle:thin:@xxxxxx12:12510:xxxx,user : APPS
Exception Connecting to DB :java.sql.SQLException: ORA-01017: invalid username/password; logon denied
The issue can be reproduced at will with the following steps:
1.Change user details in OID or within E-Business Suite.
Changed the apps user password in the E-Business Suite 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