Thursday 3 July 2014

How to change SUPERVISOR password for ODI

Follow the below steps to change the SUPERVISOR password in ODI 11g:


1. Naviagate to start --> All Programs --> Oracle --> Oracle Data Integrator --> ODI Studio

2. Navigate on ODI Studio
  click on left pane -->   Connect to Repository --> pop up the Master Repository with Supervisor/<pwd> --> click on OK

        and go to
View --> ODI Security Navigator -->  click on users --> click on "Supervisor " --> on right pane click on "change password"

Change the password and save it.

Go to the below location:

3. cd <ODI_HOME>/odi_111/oracledi/agent/bin

4. Take the backup of the file odiparams.sh

5. Run the command

      ./encode.sh  <new password>

6. Copy the encoded password to odiparams.sh in the following location

      ODI_SUPERVISOR=SUPERVISOR
      ODI_SUPERVISOR_ENCODED_PASS=<encoded password>

7. Restart all the servers and DB.

If you face below error after changing:

<Jul 3, 2014 6:28:10 AM GMT> <Warning> <Default> <J2EE JMX-46252> <Error during postRegister for MBean oracle.odi.re:name=AgentStatistics,oditype=ODIRuntimeMBeans,Application=odiconsole
java.lang.RuntimeException: oracle.odi.core.security.BadCredentialsException: ODI-10199: Incorrect ODI username or password.
        at oracle.as.jmx.framework.generic.spi.interceptors.LoggingMBeanInterceptor.internalPostRegister(LoggingMBeanInterceptor.java:703)
        at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doPostRegister(AbstractMBeanInterceptor.java:205)
        at oracle.as.jmx.framework.standardmbeans.spi.OracleStandardEmitterMBean.postRegister(OracleStandardEmitterMBean.java:516)
        at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.postRegisterInvoke(DefaultMBeanServerInterceptor.java:1033)
        at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerDynamicMBean(DefaultMBeanServerInterceptor.java:973)
        at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerObject(DefaultMBeanServerInterceptor.java:916)
        at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(DefaultMBeanServerInterceptor.java:312)
        at com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(JmxMBeanServer.java:492)
        at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase$27.run(WLSMBeanServerInterceptorBase.java:714)
        at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase.registerMBean(WLSMBeanServerInterceptorBase.java:709)


Kindly check for below points if repository details have also been updated:

a) Master Repository connection details
b) Work Repository Details
c) Both the Datasources in weblogic console: jdbc/odiMasterRepository and jdbc/odiWorkRepository should have the correct password.
d) Update Master/Work repository configuration in odiparams.sh

3 comments:

  1. Great post, adding a little comment here, dont forget to update the CSF key under EM console with the new SUPERVISOR password as well, otherwise you would still see that error in odi managed servers logs and also you would not be able to successfully test the odi standalone agent from odiconsole app.

    ReplyDelete
  2. Can you please let me know what steps needs to be done for updating the CSF key in EM console. I am not able to test standalone agent and it fails saying incorrect username/password but same agent test works from ODI studio.

    ReplyDelete