OraFAQ Forum: Client Tools » ora-28040 no matching authentication protocol

Home » Other » Client Tools » ora-28040 no matching authentication protocol (oracle 12c - Windows server 2012)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-28040 no matching authentication protocol [message #613040]

Tue, 29 April 2014 01:36

muktha_22
Messages: 527
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

Report message to a moderator

Re: ora-28040 no matching authentication protocol [message #613046 is a reply to message #613040]

Tue, 29 April 2014 02:26

Littlefoot
Messages: 21823
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).

Report message to a moderator

Re: ora-28040 no matching authentication protocol [message #613049 is a reply to message #613046]

Tue, 29 April 2014 02:48

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi Littlefoot,

Ok thanks

Report message to a moderator

Re: ora-28040 no matching authentication protocol [message #613114 is a reply to message #613049]

Wed, 30 April 2014 03:09

muktha_22
Messages: 527
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

Report message to a moderator

Re: ora-28040 no matching authentication protocol [message #613116 is a reply to message #613114]

Wed, 30 April 2014 03:13

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

OK, so - what exactly did you do? Future readers might benefit from it.

Report message to a moderator

Re: ora-28040 no matching authentication protocol [message #613118 is a reply to message #613116]

Wed, 30 April 2014 04:17

muktha_22
Messages: 527
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

Report message to a moderator

Re: ora-28040 no matching authentication protocol [message #613120 is a reply to message #613118]

Wed, 30 April 2014 04:31

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Thank you!

Report message to a moderator

Re: ora-28040 no matching authentication protocol [message #613122 is a reply to message #613118]

Wed, 30 April 2014 04:57

John Watson
Messages: 8964
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?

Report message to a moderator

Re: ora-28040 no matching authentication protocol [message #613135 is a reply to message #613122]

Wed, 30 April 2014 08:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>to connect to our 12c DB.

V10 SQL*Net is the oldest that can connect to V12 database

Report message to a moderator

how connect forms 6i with oracle 12c [message #654206 is a reply to message #613040]

Thu, 28 July 2016 05:16

mfahimaamirgmailcom
Messages: 64
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

Report message to a moderator

Re: how connect forms 6i with oracle 12c [message #654220 is a reply to message #654206]

Thu, 28 July 2016 06:41

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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".

Report message to a moderator

Re: how connect forms 6i with oracle 12c [message #654221 is a reply to message #654220]

Thu, 28 July 2016 06:46

mfahimaamirgmailcom
Messages: 64
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

Report message to a moderator

Re: how connect forms 6i with oracle 12c [message #654231 is a reply to message #654221]

Thu, 28 July 2016 08:37

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Previous Topic:	Input truncated to 1 characters
Next Topic:	SQLDEVELOPER Could not copy database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 19:52:29 CST 2025