Hitachi Vantara Pentaho Community Forums
Results 1 to 9 of 9

Thread: Can i use tnsnames to connect to Oracle DB?

  1. #1
    Join Date
    Mar 2006
    Posts
    17

    Default Can i use tnsnames to connect to Oracle DB?

    is there an option to use tnsnames while creating connections for ORACLE database?

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

    Default RE: Can i use tnsnames to connect to Oracle DB?

    Yes, but as we're using the 10.1 JDBC client driver, you need a version 10 Net8 client.
    In the connection dialog, just put the connection type to OCI.
    Put the Net8 name in place of the database name. You can leave port & hostname blank.

    Hope this helps,

    Matt

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

    Default RE: Can i use tnsnames to connect to Oracle DB?

    Oh, if you want to use (for example) an 8.1.7 client, downgrade the JDBC driver in the libext/ directory (ojdbc14.jar, orai18n.jar) to the version you find in the jdbc directory of $ORACLE_HOME on your server.

    Matt

  4. #4
    Join Date
    Mar 2006
    Posts
    17

    Default RE: Can i use tnsnames to connect to Oracle DB?

    i did as you said but i get the error :

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

    what do i need to do please?

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

    Default RE: Can i use tnsnames to connect to Oracle DB?

    OK, the file "ocijdbc10.dll" (somewhere in your client's Oracle home directory), copy that one in your path somewhere. Or to be really sure, copy it to the libswt/win32 directory of your Kettle distribution.

    Matt

  6. #6
    Join Date
    Mar 2006
    Posts
    17

    Default RE: Can i use tnsnames to connect to Oracle DB?

    thanks,
    i copied it to the kettle directory.

    but now i get a nother error:

    Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
    t2cGetCharSet

    can you help me?

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

    Default RE: Can i use tnsnames to connect to Oracle DB?


  8. #8
    Join Date
    Mar 2006
    Posts
    17

    Default RE: Can i use tnsnames to connect to Oracle DB?

    thanks.

    I copied the "ojdbc14.jar"
    from: oracle_home\jdbc\lib (i have 10g r2)
    to: Kettle\libext
    and replaced the existing file.
    now the connection thru tnsnames works.

    can you tell me what if any might go wrong in other aspects of kettle?

    thanks.

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

    Default RE: Can i use tnsnames to connect to Oracle DB?

    Sure, take a look at the bug trackers for a complete list of open and closed bugs.
    I patched version 2.2.2 to fix the most severe bugs around (backport from development). Knock yourself out.

    I have to say that with the Oracle JDBC drivers you have touched upon one of the biggest problems that Kettle has. However, as you can see from the numerous topics on the subject on the Oracle support Forums, it's really not a Kettle issue. Even Oracle tools suffer from these "connectivity hell" problems.

    Most things should work fine, and if they don't check this Forum or file a bug tracker.

    Good luck!

    Matt

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.