My Oracle Support Banner

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

Last updated on MARCH 27, 2023

Applies to:

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

Symptoms

When attempting to connect to Oracle Data Integrator (ODI) 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

To view full details, 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 a vibrant support community of peers and Oracle experts.