rmoff

August 4, 2011

ODI 10g connectivity problem with OCI

Filed under: odi — rmoff @ 11:45

Trying to connect to a repository in ODI using OCI. Target database is Oracle 11.1.0.7.

ODI Repository connection configuration - using OCI, not thin jdbc

Throws this error:

com.sunopsis.sql.l: Oracle Data Integrator Timeout: connection with URL jdbc:oracle:oci8:@ODIPRD and user ODI_USER.
	at com.sunopsis.sql.SnpsConnection.a(SnpsConnection.java)
	at com.sunopsis.sql.SnpsConnection.t(SnpsConnection.java)
	at com.sunopsis.sql.SnpsConnection.connect(SnpsConnection.java)
	at com.sunopsis.tools.connection.DwgRepositoryConnectionsCreator.a(DwgRepositoryConnectionsCreator.java)
	at com.sunopsis.tools.connection.DwgRepositoryConnectionsCreator.a(DwgRepositoryConnectionsCreator.java)
	at com.sunopsis.graphical.l.oi.a(oi.java)
[...]

Normally this error would be caused by a misconfigured Oracle client. For example, a missing or incorrect tnsnames.ora entry. I validated these and got a successful response using tnsping.

It turns out that there are two versions of the /drivers/ojdbc5.jar file, and only one of them would work. The difference in files is this:

Bytes    Date modified  File
-------  -------------  ------------------
2030460  Mar 11 00:22   ojdbc5.notwork.jar
1879924  Jul 25  2007   ojdbc5.works.jar

Extracting the jar files and examining META-INF/manifest shows the difference:

Comparison of manifest files for conflicting versions of ojdbc5.jar

Solution

Use the correct version of ojdbc5.jar.

Looking at the downloads for ojdbc5.jar, there are different versions of ojdbc5.jar for different versions of the database.

The version that worked for me was for 11.1.0.6 (1,879,860 bytes). The version that doesn’t work for me is presumably one for 11.2. I’ve not tested with the 11.1.0.7 one.

Advertisements

2 Comments

  1. Hi Robin.

    Compatibility Matrix For Java Machines And JDBC Drivers Used With ODI and various DB platforms can be found at 807235.1.

    BTW, where did you get the ojdbc5.jar from that did not work.

    Also I would recommend to use JDK 1.6 with ojdbc6.jar

    Cheers
    Uli

    Comment by Uli Bethke — August 4, 2011 @ 19:55

    • Excellent, thank you Uli.

      Comment by rnm1978 — August 5, 2011 @ 07:32


RSS feed for comments on this post.

Sorry, the comment form is closed at this time.

Blog at WordPress.com.

%d bloggers like this: