Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI Agent - Connection Refused when attempting to test Agent

mfinlayOct 15 2009 — edited Oct 16 2009
Hi gurus,

I've spent a couple of days trying to start an Agent in ODI. I've read several posts/blogs, and I think I'm happy with what needs doing. I've created an agent in ODI, called odi_demo_agent, assigned it to a logical agent via a context.

I've setup the ODIparams.bat as follows:

set ODI_SECU_DRIVER=oracle.jdbc.driver.OracleDriver
set ODI_SECU_URL=jdbc:oracle:thin:@192.168.66.103:1521:XXXDW
set ODI_SECU_USER=XXX_MASTERREP
set ODI_SECU_ENCODED_PASS=fDyXpiLtQBGJZRvrD4wr
set ODI_SECU_WORK_REP=WORKREP
set ODI_USER=SUPERVISOR
set ODI_ENCODED_PASS=LELKIELGLJMDLKMGHEHJDBGBGFDGGH

the Agent seems to startup successfully using:

agentscheduler "-port=20910" "-name=odi_demo_agent" "-V=5"

But when I click on Test Agent within ODI, I get:

java.net.ConnectException: Connection refused: connect

I've amended each of the parameters in ODIParams.bat in turn, and checked each time whether that the agent starts succesfully, so I'm happy that the ODI_SECU_DRIVER, ODI_SECU_URL, ODI_SECU_USER, ODI_SECU_ENCODED_PASS and ODI_SECU_WORK_REP are all set correctly. The problem therefore seems to be with the ODI_USER and ODI_ENCODED_PASS parameters - the agent always seems to start successfully regardless of what I have in these two parameters. Our SUPERVISOR password is the default SUNOPSIS. I've tried changing the password to something else and back again (each time including the new encoded password in ODIParams.bat), and I've tried taking the SUPERVISOR encoded password from the snps_login_security.xml file, again with no joy.

I'm not so sure this is the problem, no-one else seems to have had the issue i'm having - Is there something else I need to set for the agent to work? Everything else in ODI seems to be working as I would expect.

TIA for any help that can be given
Matt
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 13 2009
Added on Oct 15 2009
4 comments
2,305 views