Highlighted
Member..
Member..
539 views

NNMi 10.50 - Oracle RAC 12c connectivity issue - ORA-28040: No matching authentication protocol

 

Experts,

 

I am doing a fresh installation of NNMi 10.50 on RHEL 7.4 with remote Oracle RAC 12c database. During installation NNMi connection with Oracle RAC 12c we have received following error

 

"Either the Database Server Information or the User Account Information is incorrect."

"Server Configuration validation failed for one or more parameters."

 

Checked the logs , found the error “ORA-28040: No matching authentication protocol”

 

Look like an issue with the JDBC driver. Tried with OJDBC7 and OJDBC8. But received same error.

 

As per the following link changed the authentication protocol SHA-2 to SHA-1 using (sqlnet.allowed_logon_version=8). Same error received again

http://blog.oracle48.nl/ora-28040-no-matching-authentication-protocol-sqlnet-allowed_logon_version_server/

 

Any solution to fix this issue.

 

Note:

NNMi to Oracle RAC port connectivity is working fine. Using Oracle client able to login to the database, it’s not a login issue.

This is a fresh installation of NNMi 10.50

Database: Oracle 12c

Operating System: RHEL 7.4

 

 

Regards

Irshad

0 Likes
2 Replies
Highlighted
Acclaimed Contributor.. Acclaimed Contributor..
Acclaimed Contributor..

Re: NNMi 10.50 - Oracle RAC 12c connectivity issue - ORA-28040: No matching authentication protocol

Can you connect using the Java thin client such as DBvisulizer? Thats the standard that Microfocus is using.

Have a nice day 🙂

Andy Kemp
I've lasted longer in the technology industry than most certifications.
0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: NNMi 10.50 - Oracle RAC 12c connectivity issue - ORA-28040: No matching authentication protocol

One thing to check is how the NNMi DB was created. If it was created with Multitenant support - Pluggable Databases (PDB) in shared Container Databases (CDB) then it will not work.

To verify execute the query

SELECT name,pdb FROM v$services ORDER BY name;

 NAME                          PDB

------------------               ----

SYS$BACKGROUND    null

SYS$USERS                  null

nnm.us.hpecorp.net  null

nnmXDB                      null

 If it shows ‘null’ under PDB column then the DB is supported. If we see not null then it will not work.

 Best regards,

Sergey Pankratov
NNMi Support

The views expressed in my contributions are my own and do not necessarily reflect the views and strategy of HPE
If you find this or any post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember
to give them a KUDOS and show your appreciation
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.