Upgrading Oracle Data Integrator (ODI) agent from 11.1.1.6 to 11.1.1.7

Upgrading Oracle Data Integrator (ODI) agent from 11.1.1.6 to 11.1.1.7

1)  Shutdown the services & take backup

a)  Backup below agent files

cp -p $ORACLE_HOME/oracledi/agent/bin/agent.bat $ORACLE_HOME/oracledi/agent/bin/agent.bat.pre_11117

cp -p $ORACLE_HOME/oracledi/agent/bin/agent.sh $ORACLE_HOME/oracledi/agent/bin/agent.sh.pre_11117

cp -p $ORACLE_HOME/oracledi/agent/bin/odiparams.bat $ORACLE_HOME/oracledi/agent/bin/odiparams.bat.pre_11117

cp -p $ORACLE_HOME/oracledi/agent/bin/odiparams.sh $ORACLE_HOME/oracledi/agent/bin/odiparams.sh.pre_11117

cp -p $ORACLE_HOME/oracledi/agent/bin/startscenremote.sh $ORACLE_HOME/oracledi/agent/bin/startscenremote.sh.pre_11117

cp -p $ORACLE_HOME/oracledi/agent/lib/odi-standalone-agent.jar $ORACLE_HOME/oracledi/agent/lib/odi-standalone-agent.jar.pre_11117

cp -p $ORACLE_HOME/oracledi.sdk/lib/odi-core.jar $ORACLE_HOME/oracledi.sdk/lib/odi-core.jar.pre_11117

cp -p $ORACLE_HOME/oracledi/client/jdev/extensions/oracle.odi.navigator.jar.pre_11117 $ORACLE_HOME/oracledi/client/jdev/extensions/oracle.odi.navigator.jar.pre_11117


mkdir -p $ORACLE_HOME/oracledi/xml-reference_pre_11117

cp -p $ORACLE_HOME/oracledi/xml-reference/* $ORACLE_HOME/oracledi/xml-reference_pre_11117/.


2. Install ODI 11.1.1.7 binaries 

a) open a vnc session on Linux MT Nodes

./runInstaller -jreLoc JRE_LOCATION (/MW_HOME/jrockit_160_29/jre)

b) On Windows MT host

setup.exe -jreLoc JRE_LOCATION (MW_HOME\jrockit_160_29\jre )


4. Resore odiparams.bat and odiparams.sh

cp -p $ORACLE_HOME/oracledi/agent/bin/odiparams.bat.pre_11117 $ORACLE_HOME/oracledi/agent/bin/odiparams.bat

cp -p $ORACLE_HOME/oracledi/agent/bin/odiparams.sh.pre_11117 $ORACLE_HOME/oracledi/agent/bin/odiparams.sh


5. Start all services



Related posts:

Oracle Data Integrator 11g Studio (ODI Studio & ODI SDK) Installation on Windows

Error starting the Oracle Data Integrator 11g Studio at ODI_HOME/oracledi/client/odi.sh

Error starting the Oracle Data Integrator 11g Studio at ODI_HOME/oracledi/client/odi.sh


When trying to start the Oracle Data Integrator Studio to create the agent definition for Oracle Data Integrator Agent, you may hit errors as below and ODI studio fails to load.

When you do echo $JAVA_HOME, it may be set correctly but the issue still persists.

Verify if odi.conf under $ODI_HOME/oracledi/client/odi/bin has Set JAVA Home parameter defined correctly. 

You end up seeing errors as below and ODI Studio fails to load if Java home parameter is set incorrectly.

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at oracle.ide.boot.PCLMain.callMain(PCLMain.java:63)
        at oracle.ide.boot.PCLMain.main(PCLMain.java:55)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at oracle.classloader.util.MainClass.invoke(MainClass.java:128)
        at oracle.ide.boot.IdeLauncher.bootClassLoadersAndMain(IdeLauncher.java:190)
        at oracle.ide.boot.IdeLauncher.launchImpl(IdeLauncher.java:90)
        at oracle.ide.boot.IdeLauncher.launch(IdeLauncher.java:65)
        at oracle.ide.boot.IdeLauncher.main(IdeLauncher.java:55)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at oracle.ide.boot.Launcher.invokeMain(Launcher.java:714)
        at oracle.ide.boot.Launcher.launchImpl(Launcher.java:117)
        at oracle.ide.boot.Launcher.launch(Launcher.java:69)
        at oracle.ide.boot.Launcher.main(Launcher.java:59)