DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, July 5, 2017

ASM Targets Show Down Status in 12c OEM after Grid Infrastructure Upgrade From 12.1.0.2 to 12.2.0.1 With Error: ORA-28040

Solution

Set the SQLNET.ALLOWED_LOGON_VERSION parameters explicitly to 8 in the sqlnet.ora file:

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8

Reloading the listener will fix the issue.

1 comment:

bhavani said...

i upgraded GI from 12.1 to 12.2 but when added targets to OEM 12.1.0.4 it shows down.
test connection successful.

are u saying your recommendation will fix it ?
I have value 11 for both in sqlnet.ora file under $ORACLE_HOME/network/admin and $GRID_HOME/network/admin now.