cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-28040: No matching authentication protocol after upgrading to Oracle 12c for JAVA systems

Former Member
0 Kudos

Hi everyone,

We have an issue after we upgraded our MCOD databse to from Oracle 11204 to 12102.

The database is distributed and all central instances are installed on server1 (SAP JD1 and PD1) server and database is installed on server2 . All SAP instances are installed as MCOD in G00 database (server2).

The operating system we have on both server1 and server2 is

Linux server1 2.6.32-573.18.1.el6.x86_64 #1 SMP Wed Jan 6 11:20:49 EST 2016 x86_64 x86_64 x86_64 GNU/Linux

Everything was performed successfully, but after the upgrade JAVA for PI (PD1) (release 7.1) and NetWeaver JAVA system (JD1) (701 release) was not able to start as the connection to the database didn't work.

Config tool is not working as well as is getting the same error.

In order to try fixing the issue we tried the following:

1. Implemented the recommendations from SAP Note 2218723 (set SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8 in sqlnet.ora on both database servers G00 (in $ORACLE_HOME/network/admin/sqlnet.ora), JD1 (/sapmnt/JD1/profile/oracle/sqlnet.ora) and PD1 (/sapmnt/PD1/profile/oracle/sqlnet.ora)

After we set this parameter we restarted the listener located on G00 server but the issue was not fixed. In order to be sure the parameter is read, we tried to use other value than 8 and than configtool generated other error so we concluded the parameter from sqlnet.ora is read

2. As the solution from SAP note 2218723 didn't help we upgraded as well oracle client from 11 to 12 but still the same error message

3. We upgrade JVM on JD1 system from 4.1.026 to 4.1.063 but still the same issue

4. We also tried to use JDBC driver ojdbc6.jar instead of ojdbc14.jar just for testing purposes but when we are using ojdbc6.jar the config tool is giving the following error:

Caused by: java.lang.UnsupportedClassVersionError: oracle/jdbc/driver/OracleDriver has been compiled by a more recent version of the Java Runtime (class file version 50.0), this version of the Java Runtime only recognizes class file versions up to 48.0

5. We also re link all Oracle executable using relink all option as user oracle

Could you please help us to fix the issue as we cannot start JD1 system and the JAVA stack from PD1 (ABAP+JAVA).

All other SAP systems which are installed in G00 MCOD database are working correctly.

For your information, we have also one portal system in G00 MCOD which is based on SAP NetWeaver 731 but this system is working correctly. This is using ojdbc6.jar.

Could you please help us to fix the issue as we are not able to start the systems?

Thank you in advance

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

The message error we are getting when we are trying to start SAP System or to open the config tool is:

ORA-28040: No matching authentication

Johan_sapbasis
Active Contributor
0 Kudos

HI,

Check this link and the note mentioned there.

https://scn.sap.com/thread/3741163

Kind Regards,

Former Member
0 Kudos

Hi Nicolaas,

As I mentioned in my previous post we have already implemented the recommendations from SAP Note 2218723 (set SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8 in sqlnet.ora on both database servers G00 (in $ORACLE_HOME/network/admin/sqlnet.ora), JD1 (/sapmnt/JD1/profile/oracle/sqlnet.ora) and PD1 (/sapmnt/PD1/profile/oracle/sqlnet.ora)

After we set this parameter we restarted the listener located on G00 server but the issue was not fixed. In order to be sure the parameter is read, we tried to use other value than 8 and than configtool generated other error so we concluded the parameter from sqlnet.ora is read but the issue still was not fixed.

Do you have other ideas?

THank you in advance

Johan_sapbasis
Active Contributor
0 Kudos

Hi,

Should you not make change in both locations?

G00 (in $ORACLE_HOME/network/admin/sqlnet.ora),

          /sapmnt/G00/profile/oracle/sqlnet.ora


PD1 /sapmnt/PD1/profile/oracle/sqlnet.ora

          $ORACLE_HOME/network/admin/sqlnet.ora


Kind Regards,