Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: error in Oracle connectivity

  1. #1

    Default error in Oracle connectivity

    I am new to the pentaho tool. I am facing following connectivity problem can any one guide in this issue. While connected to the oracle database, I have given connection information
    But it is encountering the following error:


    Error connecting to database [ORACLE] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
    Io exception: The Network Adapter could not establish the connection


    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
    Io exception: The Network Adapter could not establish the connection


    at org.pentaho.di.core.database.Database.normalConnect(Database.java:315)
    at org.pentaho.di.core.database.Database.connect(Database.java:264)
    at org.pentaho.di.core.database.Database.connect(Database.java:226)
    at org.pentaho.di.core.database.Database.connect(Database.java:216)
    at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:54)
    at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2478)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:1919)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:1901)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog$4.handleEvent(DatabaseDialog.java:293)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:368)
    at org.pentaho.di.ui.repository.dialog.RepositoryDialog$2.widgetSelected(RepositoryDialog.java:197)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.repository.dialog.RepositoryDialog.open(RepositoryDialog.java:292)
    at org.pentaho.di.ui.repository.dialog.RepositoriesDialog$3.widgetSelected(RepositoriesDialog.java:311)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.repository.dialog.RepositoriesDialog.open(RepositoriesDialog.java:425)
    at org.pentaho.di.ui.spoon.Spoon.openRepositoryDialog(Spoon.java:5385)
    at org.pentaho.di.ui.spoon.Spoon.selectRep(Spoon.java:5449)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5613)
    at org.pentaho.di.ui.spoon.Spoon.run(Spoon.java:5739)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:371)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.commons.launcher.Launcher.main(Launcher.java:116)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
    Io exception: The Network Adapter could not establish the connection

    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:432)
    at org.pentaho.di.core.database.Database.normalConnect(Database.java:299)
    ... 37 more
    Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:427)
    ... 38 more






    Regards
    Naren

  2. #2
    pstoellberger Guest

    Default

    This means Kettle can't even reach the Oracle DB Server.
    Are you sure the network setup is alright?
    Can you ping your Oracle server?

    -paul

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.