ODI-23018 And ORA-01017 When Connecting to ODI Studio 11g (Doc ID 1984038.1)

Last updated on AUGUST 04, 2016

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to connect to Oracle Data Integrator (ODI) 11g  Studio after either:

and then attempting to log in, you get the message:

ODI-23018 Unable to Connect to Work Repository

with the following in the "Details" window:

java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException:

ORA-01017: invalid username/password; logon denied

However, when attempting to connect to the ODI Work Repository user via SQL Developer, no problems occur.

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