Oracle Data Integrator 11g SUPERVISOR user password reset

When you try to create Master Repository Connection from Oracle Data Inegrator 11g console ..you might face issue with SUPERVISOR user's password. Issue-Error :- Oracle.odi.core.security.BadCredentialsException: Incorrect ODI username or password at oracle.odi.core.security.SecurityManager.doODIInternalAuthentication(SecurityManager.java:392) at oracle.odi.core.security.SecurityManager.createAuthentication(SecurityManager.java:260) at oracle.odi.ui.docking.panes.OdiCnxFactory$1.run(OdiCnxFactory.java:214) at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655) at java.lang.Thread.run(Thread.java:662) Before resetting the password of the user SUPERVISOR . Please try the steps below . 1. SQL> drop user snpm1 cascade; User dropped. SQL> create user snpm1 identified by welcome123 default tablespace users tempora ry tablespace temp; User created. SQL> SQL> grant connect, resource to snpm1; Grant succeeded. 2. Recreate the connection in odi studio 2.1 In the Master Repository Creation Wizard, select the browse icon of the JDBC Driver and then select Oracle JDBC Driver. Click OK. Edit the JDBC URL to read: jdbc:oracle:thin: localhost:1521:orcl Enter the User as snpm1 and the Password as oracle1 . Click the Test Connection button and verify successful connection. Click OK. Click Next on the Master Repository Creation Wizard screen. 2.2 In the Authentication window, enter Supervisor Password as SUNOPSIS. Enter SUNOPSIS again to confirm the password. Click Next. Note: User names and passwords are case-sensitive in ODI. 2.3 In the Password Storage window, select Internal password Storage, and then click Finish. When Master Repository is successfully created, you will see the Oracle Data Integrator Information message. Click OK. The ODI Master repository is now created. Connection should be succesful when you click on test 3. You connect to the ODI Master repository by creating a new ODI Master Login. Open the New Gallery by choosing File > New. In the New Gallery, in the Categories tree, select ODI. From the Items list select Create a New ODI Repository login. 3.1 Configure Repository Connections with the parameters from the tables provided below. To enter the JDBC URL, click the button next to JDBC URL field and select jdbc:oracle:thin:@:: as shown in the screenshot, then edit the URL. Select Master Repository only button. Click Test button. Verify successful connection and click OK. Click OK to save the connection. 4. Click Connect to Repository. Select the newly created repository connection Master Repository from the drop-down list. ClickOK. The ODI Topology Manager starts. You are now successfully logged in to the ODI Topology Manager. Follow the below steps to reset the SUPERVISOR user password . 1. Login to the MREP schema in the Database as sys user . SQL> CONN SYS AS SYSDBA Enter Password Connedted 2. Select the SNP_USER table to verify the username. SQL> SELECT WUSER_NAME FROM SNPM1.SNP_USER; WUSER_NAME ----------------------------------------------------------------------------- SUPERVISOR 3. Using the encode.sh ,create a encrypted password. C:\Oracle\Middleware\Oracle_ODI1\oracledi\agent\bin>encode SUNOPSIS fJyHhR,tqjrxeWsfL,nicqy 4. Update the SNP_USER Table with the Password generated using the encode.sh for the SUPERVISOR user. SQL> show user USER is "SYS" SQL> SQL> update DEV_ODI_REPO.snp_user set PASS='fJyHhR,tqjrxeWsfL,nicqy' where WUSER_NAME='SUPERVISOR'; 1 row updated. or try the below command SQL> update SNPM1.snp_user set PASS='fJyHhR,tqjrxeWsfL,nicqy' where WUSER_NAME=' SUPERVISOR'; 1 row updated. 5. Now, login to the ODI GUI .