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

(Doc ID 1272959.1)

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.

Symptoms

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:

Using Service Name to connect - URL : jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxx)(PORT=12510))(CONNECT_DATA=(SERVICE_NAME=xxxx))),user : APPS
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.

Changes

Changed the apps user password in the E-Business Suite database.

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