How To Reset ODI User Password Using a SQL Editor

(Doc ID 1070522.1)

Last updated on FEBRUARY 13, 2018

Applies to:

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

Goal

You have forgotten the password of the Oracle Data Integrator (ODI) user and cannot login to ODI Security for changing the password.

Is there any way to reset the password from back end?

See also: <Document 1984054.1> - Failed To Run Delivered Scripts (encode.sh) In ODI 12.1.3

Solution

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