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) ORA-28040: No matching authentication protocol

Pentaho BI Platform Tracking | Emerson Alvim | 3 years ago
  1. 0

    After migrate Oracle Database to version 12c (12.1.0.1.0) Pentaho Data Integrator cannot connect. I receive error below: Error connecting to database [XXX] : 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) ORA-28040: No matching authentication protocol 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) ORA-28040: No matching authentication protocol at org.pentaho.di.core.database.Database.normalConnect(Database.java:415) at org.pentaho.di.core.database.Database.connect(Database.java:353) at org.pentaho.di.core.database.Database.connect(Database.java:306) at org.pentaho.di.core.database.Database.connect(Database.java:294) at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:84) at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2459) at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:541) 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.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123) at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26) at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:121) 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.eclipse.jface.window.Window.runEventLoop(Window.java:820) at org.eclipse.jface.window.Window.open(Window.java:796) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:375) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:301) at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:115) at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:62) at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.editConnection(SpoonDBDelegate.java:88) at org.pentaho.di.ui.spoon.Spoon.doubleClickedInTree(Spoon.java:2900) at org.pentaho.di.ui.spoon.Spoon.access$2300(Spoon.java:332) at org.pentaho.di.ui.spoon.Spoon$27.widgetDefaultSelected(Spoon.java:5657) 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.spoon.Spoon.readAndDispatch(Spoon.java:1227) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7368) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8673) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:625) 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:134) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error connecting to database: (using class oracle.jdbc.driver.OracleDriver) ORA-28040: No matching authentication protocol at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:540) at org.pentaho.di.core.database.Database.normalConnect(Database.java:399) ... 44 more Caused by: java.sql.SQLException: ORA-28040: No matching authentication protocol at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:277) at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:294) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:358) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:453) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:753) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:537) ... 45 more Hostname : xxx Port : 1521 Database name : xxx

    Pentaho BI Platform Tracking | 3 years ago | Emerson Alvim
    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) ORA-28040: No matching authentication protocol
  2. 0

    After migrate Oracle Database to version 12c (12.1.0.1.0) Pentaho Data Integrator cannot connect. I receive error below: Error connecting to database [XXX] : 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) ORA-28040: No matching authentication protocol 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) ORA-28040: No matching authentication protocol at org.pentaho.di.core.database.Database.normalConnect(Database.java:415) at org.pentaho.di.core.database.Database.connect(Database.java:353) at org.pentaho.di.core.database.Database.connect(Database.java:306) at org.pentaho.di.core.database.Database.connect(Database.java:294) at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:84) at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2459) at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:541) 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.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123) at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26) at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:121) 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.eclipse.jface.window.Window.runEventLoop(Window.java:820) at org.eclipse.jface.window.Window.open(Window.java:796) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:375) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:301) at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:115) at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:62) at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.editConnection(SpoonDBDelegate.java:88) at org.pentaho.di.ui.spoon.Spoon.doubleClickedInTree(Spoon.java:2900) at org.pentaho.di.ui.spoon.Spoon.access$2300(Spoon.java:332) at org.pentaho.di.ui.spoon.Spoon$27.widgetDefaultSelected(Spoon.java:5657) 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.spoon.Spoon.readAndDispatch(Spoon.java:1227) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7368) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8673) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:625) 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:134) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error connecting to database: (using class oracle.jdbc.driver.OracleDriver) ORA-28040: No matching authentication protocol at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:540) at org.pentaho.di.core.database.Database.normalConnect(Database.java:399) ... 44 more Caused by: java.sql.SQLException: ORA-28040: No matching authentication protocol at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:277) at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:294) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:358) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:453) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:753) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:537) ... 45 more Hostname : xxx Port : 1521 Database name : xxx

    Pentaho BI Platform Tracking | 3 years ago | Emerson Alvim
    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) ORA-28040: No matching authentication protocol
  3. 0

    Unable to connect Oracle 11g R2

    pentaho.com | 11 months ago
    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) Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    pentaho reporter design error to connect oracle

    Stack Overflow | 3 months ago | Araour Kahy
    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) Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 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) Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor at org.pentaho.di.core.database.Database.normalConnect(Database.java:415)
  6. 0

    ORA-28040: No matching authentication protocol —核心网络

    netfoucs.com | 1 year ago
    java.sql.SQLException: ORA-28040: No matching authentication protocol

  1. Michael 1 times, last 4 months ago
  2. Jeremy 1 times, last 4 months ago
  3. qavid 2 times, last 5 months ago
  4. Kawada 4 times, last 6 months ago
45 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    ORA-28040: No matching authentication protocol

    at oracle.jdbc.driver.DatabaseError.throwSqlException()
  2. Oracle jdbc
    OracleDriver.connect
    1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
    3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:277)
    5. oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:294)
    6. oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:358)
    7. oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:453)
    8. oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)
    9. oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
    10. oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:753)
    10 frames
  3. Java RT
    DriverManager.getConnection
    1. java.sql.DriverManager.getConnection(Unknown Source)
    2. java.sql.DriverManager.getConnection(Unknown Source)
    2 frames
  4. org.pentaho.di
    DatabaseMeta.testConnection
    1. org.pentaho.di.core.database.Database.connectUsingClass(Database.java:537)
    2. org.pentaho.di.core.database.Database.normalConnect(Database.java:399)
    3. org.pentaho.di.core.database.Database.connect(Database.java:353)
    4. org.pentaho.di.core.database.Database.connect(Database.java:306)
    5. org.pentaho.di.core.database.Database.connect(Database.java:294)
    6. org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:84)
    7. org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2459)
    7 frames
  5. org.pentaho.ui
    DataHandler.testDatabaseConnection
    1. org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:541)
    1 frame
  6. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    4. java.lang.reflect.Method.invoke(Unknown Source)
    4 frames
  7. org.pentaho.ui
    SwtButton$4.widgetSelected
    1. org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
    2. org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
    3. org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
    4. org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26)
    5. org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:121)
    5 frames
  8. RWT
    Display.readAndDispatch
    1. org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    2. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    3. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    4. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    5. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    5 frames
  9. JFace
    Window.open
    1. org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
    2. org.eclipse.jface.window.Window.open(Window.java:796)
    2 frames
  10. org.pentaho.ui
    SwtDialog.show
    1. org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:375)
    2. org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:301)
    2 frames
  11. org.pentaho.di
    Spoon$27.widgetDefaultSelected
    1. org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:115)
    2. org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:62)
    3. org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.editConnection(SpoonDBDelegate.java:88)
    4. org.pentaho.di.ui.spoon.Spoon.doubleClickedInTree(Spoon.java:2900)
    5. org.pentaho.di.ui.spoon.Spoon.access$2300(Spoon.java:332)
    6. org.pentaho.di.ui.spoon.Spoon$27.widgetDefaultSelected(Spoon.java:5657)
    6 frames
  12. RWT
    Display.readAndDispatch
    1. org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    2. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    3. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    4. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    5. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    5 frames
  13. org.pentaho.di
    Spoon.main
    1. org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1227)
    2. org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7368)
    3. org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8673)
    4. org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:625)
    4 frames
  14. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    4. java.lang.reflect.Method.invoke(Unknown Source)
    4 frames
  15. org.pentaho.commons
    Launcher.main
    1. org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
    1 frame