Configure ODI 11g Local Agent

Configure ODI 11g Local Agent:

Today we are going create and configure Local Agent in ODI 11g. So open your odi studio and proceed as per below screenshot.

lclagent1
lclagent2
lclagent3
lclagent4
Before doing any modification to the odiparams.bat file, take a backup of this. So that in case of any problem you can put this file again.

lclagent5
We need to change the value for below pointed line in the screenshot.
lclagent6
Just modify the bold values only but not others. Now open command prompt and go to ODI_HOME\oracledi\agent\bin.
For encoding master repository password in windows use “encode your_master_repo_pwd“.
For unix use “sh encode.sh your_master_repo_pwd

REM # Repository Connection Information
REM #
set ODI_MASTER_DRIVER=oracle.jdbc.OracleDriver
set ODI_MASTER_URL=jdbc:oracle:thin:@localhost:1521:xe
set ODI_MASTER_USER=ODI_MASTER1
set ODI_MASTER_ENCODED_PASS=bSyphW25OZr9ggsHRfvfy
REM #
REM # User credentials for agent startup program
REM #
set ODI_SUPERVISOR=SUPERVISOR
set ODI_SUPERVISOR_ENCODED_PASS=fJya.vR5kvNcu9TtV,jVZEt
REM #
REM # User credentials for ODI tools
REM #
set ODI_USER=%ODI_SUPERVISOR%
set ODI_ENCODED_PASS=%ODI_SUPERVISOR_ENCODED_PASS%
REM #
REM # Work Repository Name
REM #
set ODI_SECU_WORK_REP=WORKREP91_LOGON

lclagent7
lclagent8
lclagent9
Put the encoded password for ODI_MASTER_ENCODED_PASS. It should look like below screenshot.
lclagent10
Now go to ODI_Home\oracledi\agent\bin in command prompt and use below commands to start the agent

For unix
sh agent.sh -PORT=20910 -NAME=ODIAgent1

For windows
agent.bat “-PORT=20910” “-NAME=ODIAgent1”

lclagent11
lclagent12
Thats All.
Thanks.

Comments are always welcome.

About Bhabani 86 Articles
Bhabani has 10 plus years of experience in Data warehousing and Analytics projects that has span across multiple domains like Travel, Banking and Financial, Betting and Gaming Industries. Solution areas he focuses on designing the data warehouse and integrating it with cloud platforms like AWS or GCP. He is also a Elite level contributor at OTN forum more than 9 years. He loves to do experiment and POC on different integration tools and services. Some of his favorite skills are Redshift, Big Query, Python, Apache Airflow, Kafka, HDFS, Map Reduce ,HIVE, Habse, Sqoop, Drill, Impala.

32 Comments

  1. I have created one agent as per your instruction but i get error ODI 1441 user unable to connect the master repository

  2. hello bhabani,
    i have installed odi as standalone but my master repository stored in my oracle server which credentials for that is server1:1521:init2
    when i creating agent i get error
    my master repository user is DEV_ODI_REPO
    i encode the password and i add this into the ODIPAREMS.bat
    when i done with this i get error that bad password
    then i tried for encript again DEV_ODI_REPO and add to the ODIPARAMS.bat
    and also the supervisor password i am encripted and add to the .bat file then its show the agent is running and agin it gives error the bad credetials are not match
    so what should i do
    if u have any sol please replay urgent
    if no please reply

  3. Hi Bhabani,

    while encoding the master rep passowrd,i’m getting below error.

    ”The Java Virtual Machine was not found at the following location:
    The ODI_JAVA_HOME environment variable is not defined correctly.
    Please set this variable in odiparams.bat.
    the system can not find path specified ”

    now what i need to change ,pls suggest me.

    Thanks in advance

    Vasu

    • Open ODIPARAMS.BAT file from Oracledi/agent/bin folder and set the jdk location for ODI_JAVA_HOME.

      You can verify the jdk location details from your environmental variable.

  4. Hi Bhabani,

    Could you please help me with OPMN configuration for using ODI standalone agent as a service?

    Is it possible to send document / screenshots to mail id (aditya.karmalkar@gmail.com) ?

    Thanks
    Aditya

      • Hi,

        I followed steps given in oracle docs. But not able to start agent.
        It is failing with below error,

        java.lang.NoClassDefFoundError: Files\Java\jdk1/6/0_45\lib\tools/jar
        Caused by: java.lang.ClassNotFoundException: Files\Java\jdk1.6.0_45\lib\tools.jar
        at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
        Could not find the main class: Files\Java\jdk1.6.0_45\lib\tools.jar. Program will exit.
        Exception in thread “main”

        Tried with different jdk path (w/o spaces),but got same error.

        Do you have any idea about it?

        Thanks for the above link. Will check my configuration against it again

        Thanks
        Aditya

        • Can you provide the ODI_JAVA_HOME variable value present in odiparams.bat file?
          Also have you installed java in a path having space in the name (ex: Program Files)?

  5. Hi Bhabani,
    I am getting below error while trying to start the agent

    C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\agent\bin>agent -Name=TEST_Agent
    OracleDI: Starting Agent …
    2014-09-02 19:11:45.808 NOTIFICATION ODI-1128 Agent OracleDIAgent is starting. C
    ontainer: STANDALONE. Agent Version: 11.1.1.7.0 – 02/03/2013. Port: 20910. JMX P
    ort: 21910.
    2014-09-02 19:11:51.889 ERROR ODI-1131 Agent OracleDIAgent encountered an error:
    ODI-1405: Agent OracleDIAgent start failure: the agent is not defined in the to
    pology for master repository.
    javax.servlet.UnavailableException: javax.servlet.ServletException: ODI-1405: Ag
    ent OracleDIAgent start failure: the agent is not defined in the topology for ma
    ster repository.
    at org.mortbay.jetty.servlet.ServletHolder.makeUnavailable(ServletHolder
    .java:406)
    at org.mortbay.jetty.servlet.ServletHolder.initServlet(ServletHolder.jav
    a:442)
    at org.mortbay.jetty.servlet.ServletHolder.doStart(ServletHolder.java:26
    3)
    at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:
    50)
    at org.mortbay.jetty.servlet.ServletHandler.initialize(ServletHandler.ja
    va:676)
    at org.mortbay.jetty.servlet.Context.startContext(Context.java:140)
    at org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.jav
    a:1239)
    at org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:
    517)
    at org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:466
    )
    at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:
    50)
    at org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:
    130)
    at org.mortbay.jetty.Server.doStart(Server.java:224)
    at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:
    50)
    at oracle.odi.Agent.startAgent(Agent.java:306)
    at oracle.odi.Agent.main(Agent.java:697)

    Please help..

    • Make sure you have defined the physical and logical agent (TEST_Agent) in topology. Normally these informations are stored in master repository. Once this is done you can start the agent.

    • HI Gaurav,

      FIRST CONNECT TO MASTER REPOSITORY .CREATE AGENT ..NOW TO GO CMD PROMPT OPEN PASTE THE PATH CONFIGURE ENCODE MASTER REP AND SUPERVISOR GIVE YOUR WORK REP NAME AND SAVE IT …NOW C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\agent\bin>agent -Name=TEST_Agent

  6. Hi Bhabani,

    I have installation odi12c(12.1.3)and facing odi agent issue.
    Could you please help me, i will send screen short.

    Regards
    Veun

  7. the issue is:

    <> <Failure occurred in the execution of deployment request with ID "2729430604951802" for task "4". Error is: "weblogic.application.ModuleException: ODI-1405: Agent OracleDIAgent start failure: the agent is not defined in the topology for master repository."
    weblogic.application.ModuleException: ODI-1405: Agent OracleDIAgent start failure: the agent is not defined in the topology for master repository.
    at weblogic.application.internal.ExtensibleModuleWrapper.start(ExtensibleModuleWrapper.java:140)
    at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:124)
    at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:216)
    at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:211)
    at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:42)
    at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:73)
    at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:24)
    at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:729)
    at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:42)
    at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:258)
    at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:61)
    at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:165)
    at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:80)
    at weblogic.deploy.internal.targetserver.operations.AbstractOperation.activate(AbstractOperation.java:587)
    at weblogic.deploy.internal.targetserver.operations.ActivateOperation.activateDeployment(ActivateOperation.java:150)
    at weblogic.deploy.internal.targetserver.operations.ActivateOperation.doCommit(ActivateOperation.java:116)
    at weblogic.deploy.internal.targetserver.operations.StartOperation.doCommit(StartOperation.java:151)
    at weblogic.deploy.internal.targetserver.operations.AbstractOperation.commit(AbstractOperation.java:339)
    at weblogic.deploy.internal.targetserver.DeploymentManager.handleDeploymentCommit(DeploymentManager.java:846)
    at weblogic.deploy.internal.targetserver.DeploymentManager.activateDeploymentList(DeploymentManager.java:1275)
    at weblogic.deploy.internal.targetserver.DeploymentManager.handleCommit(DeploymentManager.java:442)
    at weblogic.deploy.internal.targetserver.DeploymentServiceDispatcher.commit(DeploymentServiceDispatcher.java:176)
    at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.doCommitCallback(DeploymentReceiverCallbackDeliverer.java:195)
    at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.access$100(DeploymentReceiverCallbackDeliverer.java:13)
    at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer$2.run(DeploymentReceiverCallbackDeliverer.java:68)
    at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:548)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)
    Caused By: ODI-1405: Agent OracleDIAgent start failure: the agent is not defined in the topology for master repository.
    at oracle.odi.runtime.agent.servlet.AgentServlet$1.doAction(AgentServlet.java:1053)
    at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:173)
    at oracle.odi.runtime.agent.servlet.AgentServlet.getSnpAgentForAgentInstance(AgentServlet.java:1045)
    at oracle.odi.runtime.agent.servlet.AgentServlet.startup(AgentServlet.java:512)
    at oracle.odi.runtime.agent.servlet.AgentServlet.init(AgentServlet.java

    or

    <Unable to set the activation state to true for the application "oraclediagent-wls".
    weblogic.application.ModuleException: ODI-1405: Agent OracleDIAgent start failure: the agent is not defined in the topology for master repository.
    at weblogic.application.internal.ExtensibleModuleWrapper.start(ExtensibleModuleWrapper.java:140)
    at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:124)
    at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:216)
    at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:211)
    at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:42)
    Truncated. see log file for complete stacktrace
    Caused By: ODI-1405: Agent OracleDIAgent start failure: the agent is not defined in the topology for master repository.
    at oracle.odi.runtime.agent.servlet.AgentServlet$1.doAction(AgentServlet.java:1053)
    at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:173)
    at oracle.odi.runtime.agent.servlet.AgentServlet.getSnpAgentForAgentInstance(AgentServlet.java:1045)
    at oracle.odi.runtime.agent.servlet.AgentServlet.startup(AgentServlet.java:512)
    at oracle.odi.runtime.agent.servlet.AgentServlet.init(AgentServlet.java:330)
    Truncated. see log file for complete stacktrace

  8. Hi Sir,
    Thank you for valuable guidance.

    Please guide me what is the difference among a local, standalone and J2EE agent.
    Can we use same configuration method as you mentioned above for standalone agent as well?
    Secondly please guide to configure J2EE agent.

    Thanks.

  9. we have migrated odi11g to ODI12c 12.1.2 192.168.1.100 then
    we install and upgrade odi 12.1.3 192.168.1.200 using with the same repository ,all mapping are working fine with local agent.. but when I run the mapping using with OarcleDIAgent1 it’s failed.
    when I try to create a domain D:\Oracle\Middleware\Oracle_Home\oracle_common\common\bin\config it’s failed in 12.1.3 because it’s OPSS scema already available. I can not find the agent file in the D:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\bin in 12.1.3.

    but still I can see the OracleDIAgent1 in my odi12.1.3.
    can any one suggest me how to solve this agent issue.

  10. Hi Bhabani,

    My ODI agent is giving me the following error:

    Exception in thread “main” java.lang.NoClassDefFoundError: oracle/odi/runtime/ag
    ent/IAgentLifecycleManager
    at java.lang.ClassLoader.defineClass1(Native Method)
    at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631)
    at java.lang.ClassLoader.defineClass(ClassLoader.java:615)
    at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:14
    1)
    at java.net.URLClassLoader.defineClass(URLClassLoader.java:283)
    at java.net.URLClassLoader.access$000(URLClassLoader.java:58)
    at java.net.URLClassLoader$1.run(URLClassLoader.java:197)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
    Caused by: java.lang.ClassNotFoundException: oracle.odi.runtime.agent.IAgentLife
    cycleManager
    at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
    … 12 more
    Could not find the main class: oracle.odi.Agent. Program will exit.

    I’ve set all the enviroment variables and tried all others tips.
    Could you help me?

  11. thanks bhabani for your wonderful post, i followed all your steps, when i run the agent i get the following error, please help me to solve this :

    2016-11-18 18:59:33.780 ERROR ODI-1131 Agent OracleDIAgent encountered an error: ODI-1404: Agent OracleDIAgent start failure: an authentication error occurred while conne
    cting to the master repository. Caused by: ODI-10199: Incorrect ODI username or password.
    2016-11-18 18:59:33.780 ERROR ODI-1443 Error while starting agent : javax.servlet.ServletException: ODI-1404: Agent OracleDIAgent start failure: an authentication error o
    ccurred while connecting to the master repository.
    Caused by: oracle.odi.core.security.BadCredentialsException: ODI-10199: Incorrect ODI username or password.

    but my username & password is correct, when i test repository connection in ODI STUDIO connection is successfull, cant able to connect ODIAGENT or start ODI AGENT.

    thanks in advance
    SHAZIA

  12. Hi .. can any one tell me…how should i check whether ODI agent is running or not by using command prompt?? i need to run 1 bat file to check for every 1 hour whether Agent is up or not?

  13. Hi .. can any one tell me.. how should i check whether ODI agent is running or not by using command prompt??
    i need to run 1 bat file to check for every 1 hour whether Agent is up or not?

Leave a Reply

Your email address will not be published.


*