7 Troubleshooting ODI on OCI

This chapter describes about various services associated with ODI on OCI and ways to troubleshoot them when you encounter issues while using them.

Note:

If you are facing issues connecting to ADB dataserver and MySQL repository after long hours of inactivity, try reconnecting to ODI repository to overcome this problem.

How Tos

Note:

The following commands are supported in release(s) prior to 12.2.1.4.200618 version of ODI Marketplace. For latest release, refer to Managing ODI Credential.

• How to get the password for a MYSQL based ODI repository?

  $MW_HOME/odi/common/scripts/getPassword.sh

• How to update ODI Repository and schema credentials for ADB technology?

  cd $MW_HOME/odi/common/scripts
  Create a new file updateCredentials.sh and add below contents
  echo "Updating credentials in wallet..." 
  WCLASSPATH=../../sdk/lib/odi-core.jar:../../sdk/lib/commons-lang-2.2.jar:../../../oracle_common/modules/oracle.jps/*:../../../oracle_common/modules/oracle.igf/identitydirectory.jar:../../../oracle_common/modules/oracle.idm/identitystore.jar:../../../oracle_common/modules/oracle.osdt/osdt_cert.jar:../../../oracle_common/modules/oracle.osdt/osdt_core.jar:../../../oracle_common/modules/oracle.osdt/osdt_xmlsec.jar:../../../oracle_common/modules/oracle.pki/oraclepki.jar:../../../wlserver/modules/com.oracle.weblogic.security.jar:../../../wlserver/modules/com.oracle.weblogic.security.subject.jar
  export WCLASSPATH 
  java -cp $WCLASSPATH oracle.odi.setup.util.ODIWalletSetupUtil odi ../../common/scripts/jps-config-jse.xml <supervisorPassword> <schemaPassword>
  Save the file and stop the ODI agent.
  Run the script ./updateCredentials.sh.
  Restart the ODI agent.

  Note:

  In the above commands, change the values for <supervisorPassword> <schemaPassword> fields with your respective ODI supervisor password and ADB Repository schema password.