Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Oracle DB connect error: TNS does not know SID

  1. #1

    Default Oracle DB connect error: TNS does not know SID

    I am getting a TNS error when trying to create a new Oracle database connection:
    TNS: listener does not currently know of SID given in connect descriptor

    Pentaho: pdi-ee 5.0.2
    Using Oracle 10g
    Native (JDBC)
    Entered SID in the Database Name field.
    From the Database Connection/Feature list window:
    Driver class: oracle.jdbc.driver.OracleDriver
    URL: jdbcracle:thin@server_ip:1521:my_SID

    I have copied the ojdbc14.jar file into data-integration/lib, which I believe is the correct version for Oracle 10g.

    Please advise,
    Last edited by Luke2; 04-16-2014 at 04:32 PM.

Tags for this Thread

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.