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: 526
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: 20827
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: 526
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: 526
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: 20827
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: 526
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: 20827
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: 6402
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 messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
>to connect to our 12c DB.

V10 SQL*Net is the oldest that can connect to V12 database
how connect forms 6i with oracle 12c [message #654206 is a reply to message #613040] Thu, 28 July 2016 05:16 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 35
Registered: May 2011
Location: pakistan
Member
hi to all masters
dear i install oracle 12c that run fine today i install form and reports 6i
but that not connect with 12c
this is my oracle 12c tnsname.ora file
# tnsnames.ora Network Configuration File: D:\app\OracleHomeUser1\product\12.1.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

PDBORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdborcl)
)
)



and this is my forms tnsname.ora

Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = beq.world)
(PROTOCOL = BEQ)
(PROGRAM = oracle73)
(ARGV0 = oracle73ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Example1.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = SID1)
)
)
Example2.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = spx.world)
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Example3.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = nmp.world)
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)



TEST_DATABASE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = pdborcl)
)
)


Rep60_MFAMDA-PC,Rep60_MFAMDA-PC.world=(ADDRESS=(PROTOCOL=tcp)(HOST=MFAMDA-PC)(PORT=1949))


this is my sqlnet file (i past SQLNET.ALLOWED_LOGON_VERSION=8 this line in oracle 12c sqlnet file)

# sqlnet.ora Network Configuration File: D:\app\OracleHomeUser1\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

SQLNET.ALLOWED_LOGON_VERSION=8



please help me what is the problem in both file
which service name i give to forms tnsname.ora
please give me idea how i connect forms 6i with oracl 12c
regard
Re: how connect forms 6i with oracle 12c [message #654220 is a reply to message #654206] Thu, 28 July 2016 06:41 Go to previous messageGo to next message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The correct parameter is SQLNET.ALLOWED_LOGON_VERSION_CLIENT (which does not mean it will succeed).

Note that "but that not connect with 12c " is not an Oracle error message and help in no way to know why it "not connect with 12c".

Re: how connect forms 6i with oracle 12c [message #654221 is a reply to message #654220] Thu, 28 July 2016 06:46 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 35
Registered: May 2011
Location: pakistan
Member
sir
my global database name is orcl

and i pass in 6i form tnsnames.ora


orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = pdborcl)
)
)


this is right alos i past both line in sqlnet.ora
SQLNET.ALLOWED_LOGON_VERSION=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8

please give me any idea
regard
Re: how connect forms 6i with oracle 12c [message #654231 is a reply to message #654221] Thu, 28 July 2016 08:37 Go to previous messageGo to next message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Give us any idea of what the error is.

[Updated on: Thu, 28 July 2016 09:14]

Report message to a moderator

Re: how connect forms 6i with oracle 12c [message #654233 is a reply to message #654231] Thu, 28 July 2016 08:45 Go to previous message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
Forms 6 can not inter-operate against V12 database; since SQL*Net only inter-operates across two major version.
Forms 6 is either V7 or V8 Oracle DB vintage.
Previous Topic: Input truncated to 1 characters
Next Topic: SQLDEVELOPER Could not copy database
Goto Forum:
  


Current Time: Fri Sep 30 00:05:40 CDT 2016

Total time taken to generate the page: 0.43635 seconds