java.sql.SQLException: ORA-28040: No matching authentication protocol

Oracle Community | 966383 | 4 years ago
  1. 0

    Error during creation of datasource using BI publisher

    Oracle Community | 4 years ago | 966383
    java.sql.SQLException: ORA-28040: No matching authentication protocol
  2. 0

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

    netfoucs.com | 1 year ago
    java.sql.SQLException: ORA-28040: No matching authentication protocol
  3. 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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
  6. 0

    How to set the timezone region for JDBC Connection and avoid the SqlException timezone region not found?

    Stack Overflow | 2 years ago | AndreaNobili
    java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found

  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:138)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
    3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:277)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
    5. oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:243)
    6. oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:304)
    7. oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:430)
    8. oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:151)
    9. oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
    10. oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:608)
    10 frames
  3. Java RT
    DriverManager.getConnection
    1. java.sql.DriverManager.getConnection(DriverManager.java:525)
    2. java.sql.DriverManager.getConnection(DriverManager.java:171)
    2 frames
  4. oracle.apps.xdo
    UpdateConnectionServlet.doPost
    1. oracle.apps.xdo.servlet.data.JDBCDataSource.testConnection(JDBCDataSource.java:268)
    2. oracle.apps.xdo.servlet.ui.admin.datasource.UpdateConnectionServlet.doConnectionTest(UpdateConnectionServlet.java:411)
    3. oracle.apps.xdo.servlet.ui.admin.datasource.UpdateConnectionServlet.doPost(UpdateConnectionServlet.java:151)
    3 frames
  5. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    2 frames
  6. com.evermind.server
    ResourceFilterChain.doFilter
    1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
    1 frame
  7. oracle.apps.xdo
    SecurityFilter.doFilter
    1. oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:100)
    1 frame
  8. com.evermind.server
    HttpRequestHandler.run
    1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
    2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368)
    3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866)
    4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448)
    5. com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:216)
    6. com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)
    7. com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)
    7 frames
  9. oracle.oc4j.network
    ServerSocketReadHandler$SafeRunnable.run
    1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
    1 frame
  10. com.evermind.util
    ReleasableResourcePooledExecutor$MyWorker.run
    1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
    1 frame
  11. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:595)
    1 frame