Home » SQL & PL/SQL » Client Tools » ora-28040 no matching authentication protocol (oracle 12c - Windows server 2012)
ora-28040 no matching authentication protocol [message #613040] Tue, 29 April 2014 01:36 Go to next message
muktha_22
Messages: 375
Registered: December 2009
Senior Member
Hello All,

Need help

We are having installed oracle 12c.
The client is using Toad (Version 9) and Forms and Repports (version 6i), to connect to our 12c DB.

We made entry of SQLNET.ALLOWED_LOGON_VERSION=(8') in the server's SQL NET and Clients SQL Net files, also restarted the Listner service.

But we are getting the error of "ora-28040 no matching authentication protocol". By connecting through Forms.

But no problem occured while connecting through TOAD.


Thanks and regards.
Muktha
Re: ora-28040 no matching authentication protocol [message #613046 is a reply to message #613040] Tue, 29 April 2014 02:26 Go to previous messageGo to next message
Littlefoot
Messages: 19329
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Smart people on OTN say that the reason might be Forms 6i client version which is trying to connect to your 12c database. As Forms 6i uses 8.x client (8.0.6?), regarding Client / Server / Interoperability Support Matrix For Different Oracle Versions (Doc ID 207303.1) (on My Oracle Support), this was never supported so ... it seems that you are out of luck.

Hopefully, someone else will know the workaround (I don't, sorry).
Re: ora-28040 no matching authentication protocol [message #613049 is a reply to message #613046] Tue, 29 April 2014 02:48 Go to previous messageGo to next message
muktha_22
Messages: 375
Registered: December 2009
Senior Member
Hi Littlefoot,

Ok thanks
Re: ora-28040 no matching authentication protocol [message #613114 is a reply to message #613049] Wed, 30 April 2014 03:09 Go to previous messageGo to next message
muktha_22
Messages: 375
Registered: December 2009
Senior Member
Hi All,

I have found the soulution,
that the parameter SQLNET.ALLOWED_LOGON_VERSION is depricated in 12c with SQLNET.ALLOWED_LOGON_VERSION_server and SQLNET.ALLOWED_LOGON_VERSION_client.

Thanks
Re: ora-28040 no matching authentication protocol [message #613116 is a reply to message #613114] Wed, 30 April 2014 03:13 Go to previous messageGo to next message
Littlefoot
Messages: 19329
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK, so - what exactly did you do? Future readers might benefit from it.
Re: ora-28040 no matching authentication protocol [message #613118 is a reply to message #613116] Wed, 30 April 2014 04:17 Go to previous messageGo to next message
muktha_22
Messages: 375
Registered: December 2009
Senior Member
Hi Littlefoot,

Add those parameters in server and client's machine with the value of 8.

eg:-
SQLNET.ALLOWED_LOGON_VERSION_server=8
Re: ora-28040 no matching authentication protocol [message #613120 is a reply to message #613118] Wed, 30 April 2014 04:31 Go to previous messageGo to next message
Littlefoot
Messages: 19329
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Thank you!
Re: ora-28040 no matching authentication protocol [message #613122 is a reply to message #613118] Wed, 30 April 2014 04:57 Go to previous messageGo to next message
John Watson
Messages: 4403
Registered: January 2010
Location: Global Village
Senior Member
muktha_22 wrote on Wed, 30 April 2014 10:17
Hi Littlefoot,

Add those parameters in server and client's machine with the value of 8.

eg:-
SQLNET.ALLOWED_LOGON_VERSION_server=8
Muktha, I was under the impression that it is 100% impossible to connect an 8.x client to a 12.x database. I can't test this right now, please can you do a demonstration for me? You don't have to, but it might be helpful for other people.
Can you launch SQL*Plus from your Forms and Reports home and logon to the database? Use the character version (sqlplus.exe, not sqlplusw.exe) and copy/paste it, to show both the client version and the DB version?
Re: ora-28040 no matching authentication protocol [message #613135 is a reply to message #613122] Wed, 30 April 2014 08:02 Go to previous message
BlackSwan
Messages: 22526
Registered: January 2009
Senior Member
>to connect to our 12c DB.

V10 SQL*Net is the oldest that can connect to V12 database
Previous Topic: How to save time format to 24 hour while importing data from xls file
Next Topic: ER Diagram to pdf
Goto Forum:
  


Current Time: Wed Jul 30 00:10:33 CDT 2014

Total time taken to generate the page: 0.19328 seconds