Changing the ODI Supervisor Password Rotation

As part of the organization’s password rotation policy and Oracle security best practices, it is recommended to periodically change the ODI SUPERVISOR password. To simplify credential management, Oracle recommends using the same password for the ODI SUPERVISOR account and the WebLogic Administrator account.

After changing the ODI SUPERVISOR password, update the corresponding credential stored in the WebLogic Credential Store and the ODI connection settings in Data Management to ensure uninterrupted operation.

Note:

It's applicable to Oracle EPM Release 11.2.25 and Earlier Releases.

Updating the ODI Supervisor Password

To update the ODI SUPERVISOR Password, perform the following steps:

  1. Open ODI Studio from the ODI installation directory path: <Middleware HOME>/odi/studio/

    • For Linux: Run the odi.sh script

    • For Windows: Run odi64.exe

  2. Click on Connect to Repository.
  3. Click on plus sign and provide the following User and Password details and then select OK.

  4. Log in using the current ODI SUPERVISOR credentials:

    • User: SUPERVISOR
    • Password: You can provide the current SUPERVISOR password, if it has not been changed previously.

  5. Open the Security Navigator.

  6. Expand Users and double-click SUPERVISOR.

  7. Select Change Password.

  8. Enter the new password.

    NOTE: It's recommended to use the same password as the current WebLogic Administrator password.

  9. Confirm the new password and Save the changes.

  10. Disconnect from ODI Studio.

  11. Sign in again with the updated credentials.

    • User: SUPERVISOR

    • Password: Provide the new WebLogic admin password.

  12. Verify that ODI Studio authentication is successful.

Updating the ODI Credential in the WebLogic Credential Store

To update the ODI Credential in the WebLogic Credential Store, perform the following steps:

  1. Start the WebLogic Administration Server.
  2. Open a web browser and sign in to Oracle Enterprise Manager Fusion Middleware Control: http://<AdminServer_Host>:<AdminServer_Port>/em
  3. In the navigation pane, expand:
    • Farm_<EPMSystem>
    • WebLogic Domain
    • <Domain_Name>
  4. From the WebLogic Domain menu, select Security, then Credentials.
  5. Expand the oracle.odi.credmap credential map.
  6. Select the SUPERVISOR credential and click Edit.
  7. Update the password to the new ODI SUPERVISOR password.
  8. Click Apply or OK to save the changes.
  9. Restart the OracleDIAgent managed server. If required by your organization's operational procedures, restart the EPM services to ensure the updated credential is used.

Updating the ODI Connection in Data Management

To update the ODI Connection in Data Management, perform the following steps:

  1. Log in to Oracle EPM Workspace.

  2. Navigate to Navigate > Administer > Data Management.

  3. Select the Setup tab.

  4. Click System Settings.

  5. Under the ODI profile, update the ODI Password with the new SUPERVISOR password.

  6. Click Save.

  7. Click Check ODI Connection.

  8. Verify that the ODI connection test completes successfully.

Validation

After completing the password update, perform the following validation checks:

  • Verify that you can log in to ODI Studio using the new SUPERVISOR password.

  • Verify that the OracleDIAgent managed server starts successfully.

  • Verify that Check ODI Connection in Data Management completes successfully.

  • Execute a test import or data load in Data Management.

  • Run the standard post-change validation report and confirm that all validation checks complete successfully.

Note:

When changing the ODI SUPERVISOR password, update the password in all required locations, including the ODI repository, WebLogic Credential Store, and Data Management ODI configuration. Keeping these credentials synchronized helps prevent authentication failures and ensures uninterrupted operation of ODI and Data Management (FDMEE).