Find in this Blog

Wednesday, June 26, 2019

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

jvmbootstrap.ou0  


As Java process getting failed  after oracle upgrade to 12c..


INFO: Loading tool launcher...
   INFO: [OS: Windows Vista] [VM vendor: SAP AG] [VM version: 1.5.0_14] [VM type: SAP Java 64-Bit Server VM]
   INFO: Main class to start: "com.sap.engine.bootstrap.Bootstrap"
   INFO: Loading 23 JAR files: [D:\usr\sap\GPQ\SYS\global\security\lib\tools\iaik_smime.jar, D:\usr\sap\GPQ\SYS\global\security\lib\tools\iaik_jsse.jar, D:\usr\sap\GPQ\SYS\global\security\lib\tools\iaik_jce.jar, D:\usr\sap\GPQ\SYS\global\security\lib\tools\iaik_ssl.jar, D:\usr\sap\GPQ\SYS\global\security\lib\tools\w3c_http.jar, .\bootstrap\iaik_jce.jar, .\bootstrap\jdbc.jar, .\bootstrap\jperflib.jar, .\bootstrap\sap.com~tc~bl~config~impl.jar, .\bootstrap\sap.com~tc~bl~deploy~offline~impl.jar, .\bootstrap\sap.com~tc~bl~iqlib~impl.jar, .\bootstrap\sap.com~tc~bl~jdsr~jdsr.jar, .\bootstrap\sap.com~tc~bl~offline_launcher~impl.jar, .\bootstrap\sap.com~tc~bl~opensql~implStandalone.jar, .\bootstrap\sap.com~tc~exception~impl.jar, .\bootstrap\sap.com~tc~je~bootstrap~impl.jar, .\bootstrap\sap.com~tc~je~cfs~container~standalone_impl.jar, .\bootstrap\sap.com~tc~je~extramile.jar, .\bootstrap\sap.com~tc~je~flightrecorder.jar, .\bootstrap\sap.com~tc~je~offlineconfiguration~impl.jar, .\bootstrap\sap.com~tc~logging~java~impl.jar, .\bootstrap\sap.com~tc~sapxmltoolkit~sapxmltoolkit.jar, .\bootstrap\sap.com~tc~sec~secstorefs~java~core.jar]
   INFO: Start
 * Configuring bootstrap...
      Found bootstrap properties file [D:\usr\sap\GPQ\DVEBMGS00\j2ee\cluster\bootstrap\bootstrap.properties]
 * Done for 140 ms
 * Memory available to the bootstrap JVM: 2 GiB / 2863333376 bytes
-----[Bootstrap Module started]--------[Wed Jun 26 16:59:42 GST 2019]-------
+------------[Bootstrap synchronization activities information]-----------+
| Runtime Binaries: [X]        Native files: [X] Instance Properties: [X] |
|  Nodes Structure: [X] Cluster File System: [X]    Online bootstrap: [ ] |
+-------------------------------------------------------------------------+
None of the startup parameters passed: [-DSAPSTART=1, -DSAPSYSTEM=00, -DSAPSYSTEMNAME=GPQ, -DSAPMYNAME=GEEPASPIQUA_GPQ_00, -DSAPPROFILE=D:\usr\sap\GPQ\SYS\profile\GPQ_DVEBMGS00_GEEPASPIQUA, -DFRFC_FALLBACK=ON, -DFRFC_FALLBACK_HOST=localhost] is known to the bootstrap. Activating the default mode - synchronize all (-all).
 * Properties used for initialization: {element.resynch=detect, Logging properties = {log[defaultTrace]=FileLog, .logs=log[defaultTrace],log[consoleLog], log[defaultTrace].pattern=..\..\work\log_bootstrap.log, /.severity=Info, log[consoleLog].formatter=formatter[ConsoleFormatter], formatter[ConsoleFormatter]=TraceFormatter, log[consoleLog]=com.sap.engine.bootstrap.logging.BootstrapConsoleLog, log[defaultTrace].cnt=3, formatter[BootstrapFormatter]=TraceFormatter, log[defaultTrace].formatter=formatter[BootstrapFormatter], formatter[ConsoleFormatter].pattern=%m, log[defaultTrace].limit=5242880, .severity=Info, formatter[BootstrapFormatter].pattern=[%24d] %m}, debug=no, Watchdog properties = {watchdog.timeout=90000, watchdog.check_interval=2000}}
 * Bootstrap initialized for 203 ms
 * Watchdog [90000 ms] checking every [2000 ms] started.
 * Initializing DB connection...
SecStoreFS object initialized.
setDefaultFilenames () called, filename = "D:\usr\sap\GPQ\SYS\global/security/data/SecStore.properties".
File version = "7.00.000.001", software version = "7.00.000.001".
File version = "7.00.000.001", software version = "7.00.000.001".
setDefaultKeyFilename () called, filename = "D:\usr\sap\GPQ\SYS\global/security/data/SecStore.key".
Check record okay.
Existing store opened.
File version = "7.00.000.001", software version = "7.00.000.001".
Entering setDefaultsFromProperties()
com.sap.sql.trace.j2ee.cnt is 10
com.sap.sql.trace.j2ee.limit is 10000000
Exiting setDefaultsFromProperties()
Component: [internal/unkown] of type [unkown]
Message: [Exception occurred:]
com.sap.engine.bootstrap.SynchronizationException: Database connection initialization failed. Check if the database is running and the database properties.
 at com.sap.engine.bootstrap.Synchronizer.<init>(Synchronizer.java:114)
 at com.sap.engine.bootstrap.Bootstrap.initializeSynchronizer(Bootstrap.java:74)
 at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:229)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:156)
----------==[ Caused by: ]==----------
com.sap.engine.frame.core.configuration.ConfigurationException: Error while connecting to DB.
 at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:432)
 at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.<init>(DBConnectionPool.java:178)
 at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.<init>(PersistenceHandler.java:48)
 at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.<init>(ConfigurationCache.java:127)
 at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.init(ConfigurationManagerBootstrapImpl.java:262)
 at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.<init>(ConfigurationManagerBootstrapImpl.java:39)
 at com.sap.engine.bootstrap.HelperImpl.getConfigurationHandlerFactory(HelperImpl.java:38)
 at com.sap.engine.bootstrap.Synchronizer.<init>(Synchronizer.java:111)
 at com.sap.engine.bootstrap.Bootstrap.initializeSynchronizer(Bootstrap.java:74)
 at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:229)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:156)
Caused by: java.sql.SQLException: ORA-28040: No matching authentication protocol
 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
 at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:295)
 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:359)
 at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:463)
 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:802)
 at com.sap.sql.connect.factory.DriverPooledConnectionFactory.createVendorConnection(DriverPooledConnectionFactory.java:50)
 at com.sap.sql.connect.factory.DriverPooledConnectionFactory.getPooledConnection(DriverPooledConnectionFactory.java:37)
 at com.sap.sql.connect.datasource.DBDataSourceImpl.createPooledConnection(DBDataSourceImpl.java:674)
 at com.sap.sql.connect.datasource.DBDataSourceImpl.newPooledConnection(DBDataSourceImpl.java:624)
 at com.sap.sql.connect.datasource.DBDataSourceImpl.getPooledConnection(DBDataSourceImpl.java:164)
 at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java:208)
 at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:376)
 ... 14 more

[Bootstrap]> Problem occurred while performing synchronization. For more details see the logs above.



Solution:


Add the following entries to the SQLNETora file in


<ORA_HOME> NETWORK /ADMIN  and
usr/sap/sys/profile/oracle


SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8

SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 8


Thanks
Yoonus