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.

0

About the author

Bhabani(http://dwteam.in) - Currently Bhabani is working as Sr Development Engineer at Harman International. He has good expertise on Oracle, Oracle Data Integrator, Pervasive Data Integrator, MSBI, Talend and Java. He is also contributing in ODI-OTN forum for last 5 years. He is from India. If you want to reach him then please visit contact us page. If you have any doubts or concerns on the above article, please put your question here. Dw Team will try to respond it as soon as possible. Also dont forget to provide your comments / suggestions / feedback for further improvement. Thanks for your time.

Similar Posts

30 comments

Thank you incredibly for your exciting post. I have been looking for these type of step by step process. It worked absolutely fine. Thank you.

how to stop the agent?

how to stop a agent?plz guide me

Go to bin folder and use below command. provide the agent name and port number.

agentstop.bat “-NAME=ODIAgent1” “-PORT=20911”

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

when i am start the agent it shows the error that agen1 which is my agent name was unexpected this time

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

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.

Hi Bhabai,

Thanks for solution.

Can you please provide the me steps for getting all files list from source directory to one listing table.

Thanks,
Vasu

Here source directory located in windows box only not on unix.

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)?

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

You are right but when you give ODI name parameter you have to write it Capital like this -NAME .

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

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

Please create agent named as OracleDIAgent in your repository. Then try starting the agent.

Hi Sir,

How to restart the agent ?

Thanks,
Sri

Simple stop and start it. You can see the commands in above post.

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.

HOW TO STOP AGENT

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.

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?

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

Thanks. this helped me a lot !!

Leave a replay to Asad Hussain Cancel reply

required*

Are you a human? *