Re: ***UNCHECKED*** Aparently Oracle forms 6i client server, will notwork with 12.2, the last is 12.1.0.2

I think I can confirm that's the answer. This explains the setting to use:

12c Database Alert.log File Shows The Message: Using Deprecated SQLNET.ALLOWED_LOGON_VERSION Parameter (Doc ID 2111876.1)

Regards,

JT

On Mon, 29 Jan 2018 at 14:51 TJ Kiernan <tkiernan_at_pti-nps.com> wrote:

> I ran into something similar, albeit not with Forms, just with older
> clients (10.2 and earlier). It could be worth a shot. The solution we
> found was to add the following to sqlnet.ora on the db server.
>
>
>
> SQLNET.ALLOWED_LOGON_VERSION=8
>
>
>
> Now our alert log gets spammed about a deprecated parameter, as there’s
> now a parameter that specifies client –
>
>
>
> SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
>
>
>
> - but we found that the deprecated parameter would allow the clients to
> connect. IIRC, this has to do with the algorithm that is used to
> hash/encrypt the password. 12.2 is fairly restrictive by default.
>
>
>
>
>
>
>
>
>
>
> [image: image001.jpg]
>
>
> T. J. Kiernan
>
> Lead Database Administrator
> National Pharmaceutical Services
> P.O. Box 407 Boys Town, NE 68010
> Direct: (402) 965-8800 extn. 1039
> Toll Free: (800) 546-5677 extn. 1039
>
> E-Mail: tkiernan_at_pti-nps.com
>
>
>
> The information contained in this message is privileged and confidential
> information intended only for the use of the individual or entity
> identified above. If the receiver of this message is not the intended
> recipient, you are hereby notified that any dissemination, distribution,
> use or copying of this message is strictly prohibited. If you have received
> this message in error, please immediately notify the sender by replying to
> his/her e-mail address noted above and delete the original message,
> including any attachments. Thank you.
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Juan Carlos Reyes Pacheco
> *Sent:* Friday, January 26, 2018 12:03 PM
> *To:* ORACLE-L <oracle-l_at_freelists.org>
> *Subject:* ***UNCHECKED*** Aparently Oracle forms 6i client server, will
> notwork with 12.2, the last is 12.1.0.2
>
>
>
> Hello,
>
> Aparently Oracle forms 6i, will not work with 12.2, the last is 12.1.0.2
>
> In oracle 12c didn't work reports, but someone found a dll an replacing it
> he got to work, but now is different, client oracle 8 is not supported and
> there is no way to patch it.
>
>
>
> ORA-3137* [kpoal8Check-5] From Incompatible Client Version Connecting To
> 12.2 Database (Doc ID 2296523.1)*
>
>
> Solution
>
> *Unlike previous version, Oracle has added some strict checks on RDBMS
> 12.2.0.1 and client apps must comply with these checks.*
>
> *In order to resolve this, upgrade client version to compatible level. *
>

-- 

Regards,

John





--
http://www.freelists.org/webpage/oracle-l






(image/jpeg attachment: image001.jpg)