Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-28040 – no matching authentication protocol

JJFerradaJan 25 2017 — edited Jan 30 2017

Hello red oracle

Sorry but my english is not very well.

This other day I have had a problem in a single instance oracle version 12c.

I use toad software for work and other program how oracle console enterprise manager 10g version and Insider monitor software

This program shows me this error

ORA-28040 - no matching authentication protocol

Searching the internet I find a solution

This workaround is to edit the sqlnet.ora file and add this parameters in the file

SQLNET.ALLOWED_LOGON_VERSION = 8

SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 8

SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8

Sqlnet.expire_time = 30

My problem is solved but in a single instance, not in my RAC instance.

In my RAC ORACLE I have had this same problem, but the difference of a single instance of my listener is uploaded by the grid user not from the oracle user.

My Rac Oracle have two nodes

users: grid and oracle

Group: asmadmin, asmoper, asmdba, dba, oinstall

Disk group

CRS

DATA

FRA

REDO

FileSystem

/

/boot

/tmp

/var

/opt

/u01

I hope you can help me

Regards

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 27 2017
Added on Jan 25 2017
10 comments
41,709 views