Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Trouble running spoon with Oracle XE

  1. #1
    Join Date
    Mar 2008
    Posts
    22

    Default Trouble running spoon with Oracle XE

    I am having connection issues running a job via spoon on my local PC using the devleoper version of Oracle i.e Oracle Database Express Edition. The job runs fine if I use an existing Oracle server but seems to experience random connection problems when run locally. I have set my database connection to shared. Here is therror message from the log file. If anyone knows how to address this problem it would be most appreciated.

    Code:
     
    2009/07/25 13:58:32 - Add FEED_Listing sequence.0 - ERROR (version 3.1.0, build 826 from 2009/04/28 17:12:17) : Step couldn't connect to the database: 
    2009/07/25 13:58:32 - Add FEED_Listing sequence.0 - ERROR (version 3.1.0, build 826 from 2009/04/28 17:12:17) : Error occured while trying to connect to the database
    2009/07/25 13:58:32 - Add FEED_Listing sequence.0 - ERROR (version 3.1.0, build 826 from 2009/04/28 17:12:17) : 
    2009/07/25 13:58:32 - Add FEED_Listing sequence.0 - ERROR (version 3.1.0, build 826 from 2009/04/28 17:12:17) : Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
    2009/07/25 13:58:32 - Add FEED_Listing sequence.0 - ERROR (version 3.1.0, build 826 from 2009/04/28 17:12:17) : Listener refused the connection with the following error:
    ORA-12519, TNS:no appropriate service handler found
    The Connection descriptor used by the client was:
    localhost:1521:XE
    2009/07/25 13:58:32 - Add FEED_Listing sequence - ERROR (version 3.1.0, build 826 from 2009/04/28 17:12:17) : Error initializing step [Add FEED_Listing sequence
    ]

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    This is not a PDI problem. My first hunch would be that you somehow changed the Oracle configuration (or something in Oracle is failing to start).

    Use your favorite java based tool (non-PDI) to connect to your Oracle database. I would suggest SQL Developer which you can download from the Oracle website. Using that tool you should normally get the same error and then you can debug from there, search e.g. on the internet for the ORAcle error.

    If you don't get the error using the other tool, come back to us

    Regards,
    Sven

  3. #3
    Join Date
    Mar 2008
    Posts
    22

    Default Oracle SQL Developer can connect

    Sven,

    Thanks for the reply but I can use SQL Developer with no problem and the job actually connects on some steps but then fails on others. Could it possibly be that Oracle XE has a limited n umber of simultaneous connections available and since the PDI job is threading it is reaching this limit in connections?


  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    Of course there is ... else no-one would buy the real thing

    Edit... no specific connection restrictions... other restrictions on database size, instance, and cpu usage.

    But try "ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;" from http://ksevindik.blogspot.com/2008/0...oracle-xe.html

    Regards,
    Sven
    Last edited by sboden; 07-27-2009 at 08:55 AM.

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.