6 Replies Latest reply: Jan 31, 2011 8:01 AM by 811537 RSS

    encoded password was not correct to start agent!

    811537
      hi all,
      i want to deploy an agent in the target db.
      The processes are:
      1) create agent in physical topology
      2) create agent in logical topology
      3) modify odiparam.sh in agent/bin by encode the password
      Every time i ran "encode <mypassword>", the result string was different and was not correct. i can't access the ODI_MASTER_URL by the name and the encoded password.
      greate thanks for your help.


      Jun
        • 1. Re: encoded password was not correct to start agent!
          Guru Sankar
          Hi Jun,

          Its normal.

          Every time ODI uses a password algorithm and generate a "new" encoded password. It should be different but eventually ODI can recognize ur clean password using encoded password.

          Makes sense?

          Thanks,
          Guru
          • 2. Re: encoded password was not correct to start agent!
            811537
            The encoded password was useful in win 7, but failed in RHEL 64bit and the agent failed to start finally.
            what does these info mean?

            The followings are the error info in win7:
            WARNING failed AgentServlet
            java.lang.ClassLoader.loadLibrary(ClassLoader.java:1709)
            java.lang.Runtime.loadLibrary0(Runtime.java:823)
            java.lang.System.loadLibrary(System.java:1030)
            oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3178)
            java.security.AccessController.doPrivileged(Native Method)
            oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3174)
            oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:233)
            oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
            oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:133)
            oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53)
            oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
            oracle.ucp.jdbc.DriverConnectionFactoryAdapter.createConnection(DriverConnection
            FactoryAdapter.java:129)
            oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.cr
            eateOnePooledConnectionInternal(UniversalConnectionPoolImpl.java:1570)
            oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.ac
            cess$600(UniversalConnectionPoolImpl.java:1378)
            oracle.ucp.common.UniversalConnectionPoolImpl.createOnePooledConnection(Universa
            lConnectionPoolImpl.java:445)
            oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionWithoutCountingReq
            uests(UniversalConnectionPoolImpl.java:302)
            oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnection(UniversalConnecti
            onPoolImpl.java:129)
            oracle.ucp.jdbc.JDBCConnectionPool.borrowConnection(JDBCConnectionPool.java:119)

            oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:655)
            oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:613)
            oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:607)
            oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run
            (LoginTimeoutDatasourceAdapter.java:217)
            java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
            java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
            java.util.concurrent.FutureTask.run(FutureTask.java:138)
            java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:8
            86)
            java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
            java.lang.Thread.run(Thread.java:619)

            2011-01-31 14:31:27.643 WARNING failed oracle.odi.Agent$1@d7b7d9{/oraclediagent,
            file:/F:/oracle/agent/lib/oraclediagent.war}
            java.lang.ClassLoader.loadLibrary(ClassLoader.java:1709)
            java.lang.Runtime.loadLibrary0(Runtime.java:823)
            java.lang.System.loadLibrary(System.java:1030)
            oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3178)
            java.security.AccessController.doPrivileged(Native Method)
            oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3174)
            oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:233)
            oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
            oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:133)
            oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53)
            oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
            oracle.ucp.jdbc.DriverConnectionFactoryAdapter.createConnection(DriverConnection
            FactoryAdapter.java:129)
            oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.cr
            eateOnePooledConnectionInternal(UniversalConnectionPoolImpl.java:1570)
            oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.ac
            cess$600(UniversalConnectionPoolImpl.java:1378)
            oracle.ucp.common.UniversalConnectionPoolImpl.createOnePooledConnection(Universa
            lConnectionPoolImpl.java:445)
            oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionWithoutCountingReq
            uests(UniversalConnectionPoolImpl.java:302)
            oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnection(UniversalConnecti
            onPoolImpl.java:129)
            oracle.ucp.jdbc.JDBCConnectionPool.borrowConnection(JDBCConnectionPool.java:119)

            oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:655)
            oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:613)
            oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:607)
            oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run
            (LoginTimeoutDatasourceAdapter.java:217)
            java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
            java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
            java.util.concurrent.FutureTask.run(FutureTask.java:138)
            java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:8
            86)
            java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
            java.lang.Thread.run(Thread.java:619)

            2011-01-31 14:31:27.654 WARNING Error starting handlers
            java.lang.ClassLoader.loadLibrary(ClassLoader.java:1709)
            java.lang.Runtime.loadLibrary0(Runtime.java:823)
            java.lang.System.loadLibrary(System.java:1030)
            oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3178)
            java.security.AccessController.doPrivileged(Native Method)
            oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3174)
            oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:233)
            oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
            oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:133)
            oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53)
            oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
            oracle.ucp.jdbc.DriverConnectionFactoryAdapter.createConnection(DriverConnection
            FactoryAdapter.java:129)
            oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.cr
            eateOnePooledConnectionInternal(UniversalConnectionPoolImpl.java:1570)
            oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.ac
            cess$600(UniversalConnectionPoolImpl.java:1378)
            oracle.ucp.common.UniversalConnectionPoolImpl.createOnePooledConnection(Universa
            lConnectionPoolImpl.java:445)
            oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionWithoutCountingReq
            uests(UniversalConnectionPoolImpl.java:302)
            oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnection(UniversalConnecti
            onPoolImpl.java:129)
            oracle.ucp.jdbc.JDBCConnectionPool.borrowConnection(JDBCConnectionPool.java:119)

            oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:655)
            oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:613)
            oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:607)
            oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run
            (LoginTimeoutDatasourceAdapter.java:217)
            java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
            java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
            java.util.concurrent.FutureTask.run(FutureTask.java:138)
            java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:8
            86)
            java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
            java.lang.Thread.run(Thread.java:619)
            -------------------------------------------------------------------------------------------------------------------------

            Edited by: 808534 on 2011-1-30 下午10:34
            • 3. Re: encoded password was not correct to start agent!
              Guru Sankar
              Hi Jun,

              Quick questions,

              1. In win 7, can you let me know how u are starting/executing the agent?

              2. Did u "installed" standalone agent while ODI 11g installation? If so can u let me know what are the files avalible in ..\Oracle_ODI_1\oracledi\agent\bin with AGENT_* suffix?

              3. Also, u would have see the "exact" error message before the WARNING in the log starting with ODI-* , whats that?

              FYR:

              http://odiexperts.com/standalone-agent-part-611g

              Thanks,
              Guru
              • 4. Re: encoded password was not correct to start agent!
                811537
                1. In win7,i just ran this command "agent.bat -NAME=remoteagent -port=8002".
                2. I just copy the agent folder(ODI installed machine) to win7.
                There are just agent_localagent.bat in the bin folder.
                3. translated from local language, maybe not correct. The info is:
                OracleDI: Starting Agent ...
                2011-01-31 14:47:47.393 NOTIFICATION ODI-1128 Agent remoteagent is starting。application server: STANDALONE。proxy edition: 11.1.1.3.0 - 23/06/2010。port: 8002。JMX port: 9002


                Did i need to install 'ODI' in win7? i read some docs that told me that i just need to copy the agent folder.
                • 5. Re: encoded password was not correct to start agent!
                  Guru Sankar
                  Hi,

                  In ODI 10g yes, u just need to copy Agent folder but in ODI 11g No i suppose. You need to install "ODI Standalone Agent" only in win 7.

                  While installing ODI u have an option of installing Only Standalone agent. Select that installation type and provide ur agent name and port which is of TCP/IP type , then update ur odiparams.bat and proceed to start the agent.

                  Thanks,
                  Guru
                  • 6. Re: encoded password was not correct to start agent!
                    811537
                    thanks a lot:)
                    i'll try it!