Re: Forms 6i vs. rdbms 12.2

 From a previous post

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.

2018-06-26 23:46 GMT-04:00 John Kelly <jckelly_at_aidhm.com>:

> Hi Patrice,
>
> It sounds like you've already found the SQLNET.ALLOWED_LOGON_VERSION
> parameters. Did you try setting these on both the client and
> the server? The other option might be to install both the Oracle 12.1 and
> 12.2 binaries and use a 12.1 listener to communicate with
> the 12.2 database. I did something similar back in Oracle 11 and I believe
> this should still work. The additional advantage to this approach
> is that with the separate oracle home you won't have to downgrade all of
> the SQLNET connections to the older version and you get better
> security.
>
> cheers,
>
> John Kelly
>
> sample syntax:
> SQLNET.ALLOWED_LOGON_VERSION=8
> SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
> SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
>
>
>
> On 6/26/18 3:39 PM, Patrice sur GMail wrote:
>
> (don't laugh; I know Forms 6i is concurrent with Oracle 7.3 and it's not
> secure. The app maintenance people know the apps should have been upgraded
> years ago)
>
> We have a couple of really old intranet apps written using Forms 6i, so
> far we have managed to keep them running without upgrading them. One of
> them is composed of over 200 forms (not counting plls, menus, reports).
>
> I upgraded a dev database from 11.2 to 12.2., did what I could think of to
> allow the old apps to connect, downgraded the listener compatibility mode
> from 12 to 11, then to 8 though I think 9i might have been okay. I even
> turned off mixed case logins in the database but Forms 6i still can't
> connect.
>
> Is there any way to allow Forms 6i apps to connect to 12.2?
> ​One discussion online mentions that Forms 6i could connect to 12.1, but
> as of 12.2. it really is the end of the road for this old version of forms.​
>
> https://www.databaseusers.com/article/5966488/is+forms+6i+
> on+Oracle+Database+12.2+compatible%3F
>
> ​I'll post on the Oracle Forms community forum and log an SR, though I can
> predict what Oracle Support will tell me with their funeral director voice.​
>
> -- Patrice
> My profiles: [image: Facebook]
> <http://www.facebook.com/home.php?#%21/profile.php?id=100000206805521>[image:
> LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9>[image:
> Twitter] <http://www.twitter.com/PatriceBoivin>
>
>
>

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