ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

Drivers Location in ODI 11g

Hi….

A small but very helpful tip!

Initially when I was scrolling  the documentation there were two location where we would need to place the Drivers one in <WINDOWS_USER_HOME>AppDataRoamingodioraclediuserlib

and the other will be the <ODI_HOME>/agent/oracledi/drivers  Folder.

It confused me why two places and this is not feasible architecture , then I turned my attention towards the Global Architecture of  Server  and Client .  So if my ODI Server  is located on a UNIX server then I would be placing all my drivers under the agent/oracledi/drivers   folder,since Agent will be located on my Server . While my Windows Client machine  would be using the  AppDataRoamingodioraclediuserlib folder for drivers ,as I would be using the Local Agent for reversing and if I in case I need to use  respective RKM automatically Server Agent can be used to connect.

Moreover when we install the ODI Studio namely the ODI client the user wont have the agent folder and so they would have no confusion and would have to use AppDataRoamingodioraclediuserlib for drivers .

image

See you in the next post!

19 Comments

  1. Hi,

    I am trying to invoke an ODI scenario through a java code using pl/sql procedure. The java code is working fine but when I try to load the compiled class into database it is not able to find the odi runtime agent invocation package and giving below error. ORA-29521: referenced name oracle/odi/runtime/agent/invocation/RemoteRuntime
    AgentInvoker could not be found
    ORA-29521: referenced name oracle/odi/runtime/agent/invocation/InvocationExc
    eption could not be found
    ORA-29521: referenced name oracle/odi/runtime/agent/invocation/InvocationExc
    eption could not be found
    ORA-29521: referenced name oracle/odi/runtime/agent/invocation/ExecutionInfo
    could not be found
    ORA-29521: referenced name oracle/odi/runtime/agent/invocation/StartupParams
    could not be found

    Please let me know where should I place the odi sdk jar files in database or any other workaround.

    Thanks,
    Rita

  2. Hi, Is there a way to use RKM in linux? I cant find the equivalent path to

    App\Data\Roaming\odi\oracledi\userlib

  3. If you get message:
    “oracle.odi.core.exception.OdiRuntimeException: java.lang.IllegalArgumentException: Could not load JDBC driver class [weblogic.jdbc.sqlserver.SQLServerDriver]”

    Then (on Windows XP only) copy file wlsqlserver.jar to
    “c:Documents and Settings<LOGIN_NAME>Application Data
    odioraclediuserlibwlsqlserver.jar”

    You can extract wlsqlserver.jar from oracledi-agent-standalone.zip (odi_miscwlsqlserver.jar)

    You can extract oracledi-agent-standalone.zip from
    ofm_odi_companion_generic_11.1.1.3.1_disk1_1of1.zip
    – it is so called “Oracle Data Integrator Companion 11g (11.1.1.3.3)”

    • Dear Aleksei,

      I am facing the same problem i.e. “oracle.odi.core.exception.OdiRuntimeException: java.lang.IllegalArgumentException: Could not load JDBC driver class ” in linux,can you please tell the solution for it in linux.
      Kindly provide the driver class name and URL for ODI_JDBC_EXCEL.

      Waiting for your response
      Raushan Sinha

  4. If you get message:
    “oracle.odi.core.exception.OdiRuntimeException: java.lang.IllegalArgumentException: Could not load JDBC driver class [weblogic.jdbc.sqlserver.SQLServerDriver]”

    Then (on Windows XP only) copy file wlsqlserver.jar to
    “c:Documents and Settings\Application Data
    odioraclediuserlibwlsqlserver.jar”

    You can wlsqlserver.jar get it from oracledi-agent-standalone.zipodi_miscwlsqlserver.jar

    oracledi-agent-standalone.zip
    you can extract from
    ofm_odi_companion_generic_11.1.1.3.1_disk1_1of1.zip
    – it is so called “Oracle Data Integrator Companion 11g (11.1.1.3.3)”

  5. Hi All,

    I have an issue in ODI11g. The Issue description is as follows :
    I have connected SQL Server 2008 to ODI11g. The Connection was successfull. Next, when i try to reverse the tables, ODI is giving me an error as below :
    oracle.odi.jdbc.datasource.ConnectionTimeoutException: A login timeout occured while connecting to the database

    The JDBC used is :
    Driver: weblogic.jdbc.sqlserver.SQLServerDriver
    URL: jdbc:weblogic:sqlserver://XXXXYYYY:1433;selectMethod=cursor;databaseName=ZZZZZ;integratedSecurity=false

    where XXXX is the servername, YYYY is the instancename and ZZZZ is the database name.

    I have also tried to increase the Timeout parameter in ODI-User Parameters-Oracle Data Integrator Timeout. But , the error still persists.

    Any solution to this.?

    Thanks,
    Chary

  6. Hi,
    I have a similar situation as Marco wherein I need to use ojdbc14.jar for one of the projects. Let me know if you were able to get it to work.

    Here is what we have:
    Some of the work repositories already in production have been coded using ojdbc14.jar. With ojdbc6.jar, the queries issued to the database change (related to TIMESTAMP fields) and change the resultset. We will either have to fix old code to work with the new driver or work out a way for different agents to use different jdbc driver versions in ODI 11g install
    I have done the latter in 10g and works perfectly fine (modified Classpath in odiparams to point to a differnet jdbc file for the each of the agents). We have not done the upgrade to 11g yet, but are accessing the impact so we know how much work it is going to be..

    Thanks,
    Pratima Sharma

    • We are facing same issue. Loading a timestamp from source to a staging varchar2 field.
      As it is not too many interfaces in our case, we are likely going to fix/improve the code and make it explicit i.e. by putting this into the column’s mapping: to_char(source_timestamp_field, ‘YYYY-MM-DD HH24:MI:SS.FF1’) and switch this to be on stage or target (Oracle RDBMS).
      HTH

  7. Hello! Thanks for sharing this post! 🙂

    I was wondering, though.. If I were to use an older version of the Oracle JDBC driver (this is because I need to connect to older versions of the DB like 7.3.4 and 8i), where would I need to place the old drivers? (e.g. classes12.jar, ojdbc14.jar) I tried placing them in the locations you specified but while the drivers for the other technologies work (tested JTDS driver for SQLServer), the one for Oracle doesn’t. It might be because the default one that ODI 11g has (ojdbc6.jar, I think) is still the one being used. Is this indeed the case?

    Hope you could help.

    Thanks,
    Marco

  8. Hi there,

    I was wondering if you guys could help me out in some doubts that I’m passing throughout an ODI 11g implementation. I’m not sure if my question is related to this subject but, believing so, I hope you guys could understand it..
    I’ve finished mapping a unique source(SQL Server) and target(Oracle) table to perform a simple E-LT. In that matte,r I was getting error messages while I was trying to execute my interface with LKM-MSSQL to Oracle and IKM-Oracle Incremental Update related to BCP.
    I’m currently using Windows Server 2008 but I coudn’t find where the agent folder is(even though I had followed earlier instructions of this forum). The usage of an Agent to execute the interface so I can populate the Target table is a necessary condition or I can do it without it ?

  9. Installed ODI 11g but cannot find the Drivers folder in ODI_HOME , when i try to connect to MS SQL server i get an error saying driver cannot be loaded.

    Thanks
    Rajesh.

  10. Just one more thing, on Win 7 works perfect, but on Win XP I can´t find the folder AppDataRoamingodioraclediuserlib , Do you know where can I copy the driver in this case?!
    thanx again!

  11. Sorry, I found de local folders and copy the driver file there, works perfect!! Thanx for the tip!

  12. Hi, the folders agent, Appdata, Roaming does not exist!

  13. hi,

    i m unable to find this folder path inside my installed ODI 11g .
    i have this path………….
    C:OracleMiddlewareOracle_ODI1oracledi
    now inside oracledi dere is agent,client log and xml-reference.
    So where to put my java jar file…I m using Windows.
    As i m trying to call java from ODI and getting error “No module named FileWrite”
    File write is the jar file….

    Plz guide me ???

    • If you have an dedicated agent created ,then put the jar file into agent/driver . In case you are using Local agent then go to this path else this path AppDataRoamingodioraclediuserlib and restart the agent or the studio and try connecting now. Also might be you can comment to Uli regarding this FileWrite issue as he might guide you . Did you try contacting him.?

Leave a Reply

Required fields are marked *.