Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Failure to connect to Oracle database using OCI

  1. #1

    Default Failure to connect to Oracle database using OCI

    I have a working Oracle 64bit full client installed on the 2008R2 server where Pentaho is installed. I downloaded the 11.2.0.3.0 ojdbc5.jar and ojdbc6.jar files and put them in the \libext\JDBC directory.
    The ocijdbc11.dll file exists in the Oracle installation path in the BIN directory

    I try to create an OCI connection from within Kettle , but keep running into:

    Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
    no ocijdbc11 in java.library.path

    JDBC connection does work and is mighty quick


    Edit:

    Additional attempt:

    Copied OCIJDBC11.dll to the libswt\win64 directory which changes the error message to:

    oracle.jdbc.driver.T2CConnection.getLibraryVersionNumber()I
    Last edited by blom0344; 09-05-2012 at 03:52 AM.

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    The java library path for Spoon is in libswt/win64 so you could copy your dll there.
    For pan/kitchen it's not set (even though you could easily edit the bat files).
    Alternatively I think you can copy the DLL to $JAVA_HOME/jre/lib/amd64

  3. #3
    Join Date
    Feb 2012
    Posts
    16

    Default

    I'm not completely sure why but I had a problem like that when I placed both ojdbc5.jar and ojdbc6.jar in ../libext/jdbc... right now I'm only using ojdbc5.jar try that

  4. #4

    Default

    After many hours of testing combinations I quit the OCI path. We got JDBC working and it looks promising. Prior to testing Pentaho we installed both Oracle 32 and 64 bit full clients on the server. This was mandatory for testing SSIS , so perhaps this is a complicating factor.

    Sidenote:

    I am a bit worried about the posting procedure on this forum though. I checked this post for some days after my initial posting and no reactions showed. Then Matt's reaction appeared with a timestamp indicating that he answered the same day. So, there seems to be some sort of lag?

  5. #5
    Join Date
    Oct 2006
    Posts
    9

    Default

    I managed to create an oci connection by installing oracle instant client (oci.dll, ociw32.dll, oraociei11.dll etc....) on the pc where pdi is installed.
    In this folder I created the folder 'network' with subfolder 'admin' holding the tnsnames.ora.
    Also edited spoon.bat and added the following lines:
    set ORACLE_HOME=c:\instantclient
    set TNS_ADMIN=c:\instantclient\network\admin
    set PATH=c:\instantclient;%PATH%

    tnsnames.ora contains:
    t10utf8 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ora10db01)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = t10utf8)
    (SERVER = DEDICATED)
    )
    )

    and the pdi connection is:
    <name>test</name>
    <server/>
    <type>ORACLE</type>
    <access>OCI</access>
    <database>t10utf8</database>
    <port>-1</port>
    <username>scott</username>
    <password>secret</password>

  6. #6
    Join Date
    Jun 2013
    Posts
    2

    Default

    Seeing this as well with PDI 5.10 - was not an issue in PDI 4.40. OCI connections not working with old or new ocijdbc11.dll

    "Additional attempt:

    Copied OCIJDBC11.dll to the libswt\win64 directory which changes the error message to:

    oracle.jdbc.driver.T2CConnection.getLibraryVersionNumber()I"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.