Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Set up Oracle datasource when Oracle is in a Docker container

  1. #1
    Join Date
    Sep 2017
    Posts
    13

    Exclamation Set up Oracle datasource when Oracle is in a Docker container

    Hi,

    I'm on a mac, and I couldn't just install Oracle (Oracle doesn't support mac), so I'm using it in a Docker container. It's happily running there, I can get to it via sqldeveloper. However, when I hook it up to sqldeveloper, I have to do it via sid. "SID = xe". I don't see how to do that from PRD. When I try and just get there, I get an error message:

    ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

    Here is what I have for my Oracle JDBC dialog that is giving me that error:

    Name:  Screen Shot 2017-10-20 at 11.38.40 AM.png
Views: 367
Size:  38.6 KB

    I'm running PRD version 7.1 and Oracle 12c.

    I'm thinking this is a mac issue since I can't just run the db, but we *just* switched to oracle from mysql and I'm the first one trying to figure these kinds of things out. Eventually I'll parameterize the credential information and send it in through a PDI transform to a step that will run the report (which is working for mysql).

    Thank you all kindly,
    Valeri

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Perhaps try a DB name of XE.

    databaseName String Name of the particular database on the server. Also known as the service name (or SID) in Oracle terminology. For Oracle Database XE, this is XE.

    https://docs.oracle.com/cd/B25329_01...20/getconn.htm

  3. #3
    Join Date
    Sep 2017
    Posts
    13

    Default

    Yes, this worked, thanks!!

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.