ODI Agent wont start
Guys,
i am trying to define a ODI Agent for Hyperion. i have edited the ODIPARAMS.bat . i have initially changed the SUPERVISOR\SUNOPSIS password. so i used
agent encode ODI_ENCODED_PASS
and obtained the password -added to odiparams
now when i try to start the agent - i am getting a invalid Username/password ORA01017 Error. but within the tology manager- master rep-connections i have tested the connection and it is succesful. can any one tell me what mistake i am making. here is my ODIPARAMS
rem
rem Repository Connection Information
rem
set ODI_SECU_DRIVER=oracle.jdbc.driver.OracleDriver
set ODI_SECU_URL=jdbc:oracle:thin:@hyplite:1521:HYPLITE
set ODI_SECU_USER=odiuser
set ODI_SECU_ENCODED_PASS=aogpgrlJh2EP27mUMpcnJpMZlmrKwq6zYnlZJqp
set ODI_SECU_WORK_REP=WORKREPHYP
set ODI_USER=SUPERVISOR
set ODI_ENCODED_PASS=eCfH.49R8UFkHeUykwd5YrC,L9d4W95y
here is the error
racleDI: Starting Scheduler Agent ...
Starting Oracle Data Integrator Agent...
Version : 10.1.3.5 - 10/11/2008
com.sunopsis.tools.core.exception.SnpsRuntimeException: java.sql.SQLException: O
RA-01017: invalid username/password; logon denied
at com.sunopsis.dwg.cmd.n.a(n.java)
at com.sunopsis.a.f.run(f.java)
at com.sunopsis.dwg.cmd.i.y(i.java)
at com.sunopsis.dwg.cmd.i.run(i.java)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon de
nied
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:277)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthentica
te.java:647)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
361)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:151)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio
n.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:595)
at com.sunopsis.sql.SnpsConnection.u(SnpsConnection.java)
at com.sunopsis.sql.SnpsConnection.c(SnpsConnection.java)
at com.sunopsis.sql.i.run(i.java)
Caused by:
java.sql.SQLException: ORA-01017: invalid username/password; logon denied
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:277)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthentica
te.java:647)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
361)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:151)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio
n.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:595)
at com.sunopsis.sql.SnpsConnection.u(SnpsConnection.java)
at com.sunopsis.sql.SnpsConnection.c(SnpsConnection.java)
at com.sunopsis.sql.i.run(i.java)