Database - RAC/Scalability (MOSC)

MOSC Banner

ora-28040 encounter after upgrade grid infrastructure from 18c to 19c

in Database - RAC/Scalability (MOSC) 3 commentsAnswered

Hi

We recently upgraded our GI from 18.7 to 19.16, when we were still in 18c, we are able to connect to our DB in sqlplus with Oracle client 11.2.0.1 via the default listener started in GI home at port 1521 after we configure the sqlnet.ora in the database home with the below info

SQLNET.ALLOWED_LOGON_VERSION=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

however, after the GI upgraded to 19c, we found that sqlplus with Oracle client 11.2.0.1 encounter error "ora-28040 , no matching authentication protocol" when login to the database with the default listener at port 1521, we have to start another listener at the same IP with port 1522 with below listener configuration in GI home

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center