ORA-01017: invalid username/password; logon denied Error After Cloning and Changing the Apps Password (Doc ID 1272959.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Applications Technology Stack - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

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