ORA-28040: No matching authentication protocol Oracle

Question

I am trying to connect oracle12C but not able to connect .

i have tried with previous answer : ORA-28040: No matching authentication protocol : Oracle 12c Upgrade?

using ojdbc6.jar . But it is not worked

Next i have added following snippet in sqlnet.ora file

SQLNET.ALLOWED_LOGON_VERSION=10
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10
SQLNET.ALLOWED_LOGON_VERSION_SERVER=10

Here i tried assigning (10,11,12) but neither of them is working.

after update to sqlnet.ora you need to reload the listener. `lsnrctl reload` or restart the server (if you can) — ejazazeem, Dec 02 '20 at 10:18
Also try with the minimum version supported which is 8. You need to do this both on client and server — ejazazeem, Dec 02 '20 at 10:27

score 1 · Answer 1 · answered Oct 11 '19 at 15:35

After Lot of debug ,

Oracle 12c comes all its older version . If you have installed 11g client first upgrade to 12c . Then all set up need to done . Net manager wont throw ORA-28040: No matching authentication protocol Oracle error and will pass successfully .

score 0 · Answer 2 · answered Oct 11 '19 at 10:56

0

Can you try delete the ojdbc14.jar file and use ojdbc6.jar instead

answered Oct 11 '19 at 10:56

CompEng

7,161
16
68
122

1

Yes i have tried even that under Lib folder but didn't worked for me – sampath acharya Oct 11 '19 at 10:59

ORA-28040: No matching authentication protocol Oracle

2 Answers2