Home » RDBMS Server » Server Administration » Unable to connect Forms 6i and Oracle 12c 12.2.0.1.0 (Oracle Database 12c 12.2.0.1.0)
Unable to connect Forms 6i and Oracle 12c 12.2.0.1.0 [message #686022] Fri, 27 May 2022 07:01 Go to next message
shamsad.khan@gmail.com
Messages: 12
Registered: October 2016
Junior Member
Hi,

My operating system is Windows 7 64 bit Professional. I have installed Oracle Database 12.2.0.1.0 and its working fine.

I am able to connect through sqlplus to my pluggable database users.

I have installed Oracle Virtualbox on Windows 7 64bit Prof. My Operating System is Windows XP service pack 2 on the Virtualbox.

On Windows XP, I have installed Oracle 8i and Forms 6i. They are connecting and working. My old applications are running using them as frontend and backend.


Oracle 8i is able to connect to Oracle 12c through sqlplus 8.1.6. I have modified Oracle 12c sqlnet.ora by adding these lines

SQLNET.ALLOWED_LOGON_VERSION=8

SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

I am unable to connect Oracle 12c through forms 6i. It gives error

Oracle Forms Designer has encountered a problem and needs to close. We are sorry for the inconvenience.

The same error I get if I try to connect to Oracle 12c through SQL Plus 8.0 thats given in submenu menu of Oracle for Windows NT - Forms 6i



My tnsnames.ora for Oracle 8i

  1. TNSNAMES.ORA Network Configuration File: C:\Oracle\Ora81\network\admin\tnsnames.ora
  1. Generated by Oracle configuration tools.
KIC =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.112)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = kic)

)

)

  1. 192.168.1.112 - Windows XP
ORCLPDB =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = orclpdb)

)

)

  1. 192.168.1.105 - Windows 7 64 bit
My tnsnames.ora for Forms 6i

  1. TNSNAMES.ORA Network Configuration File: C:\Oracle\Ora81\network\admin\tnsnames.ora
  1. Generated by Oracle configuration tools.
KIC =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.112)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = kic)

)

)


ORCLPDB =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = orclpdb)

)

)


Please note: Earlier I had Oracle Database 11g R2 on Windows 7 64 bit and the virtualbox OS and softwares were same as its now.

I was able to connect to Oracle 11g R2 through forms6i and was able to run my application on Windows XP

(Frontend as Forms 6i on XP and Oracle 12c as backend on Windows 7 64 bit.


Please guide me how could i connect oracle 12c through forms 6i
Re: Unable to connect Forms 6i and Oracle 12c 12.2.0.1.0 [message #686023 is a reply to message #686022] Fri, 27 May 2022 08:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68257
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Client 8.* <-> Server 12.2 has never been supported.
You have to upgrade to at least 11.2.0.3.

See Compatibility matrices and differences between editions wiki page.

Re: Unable to connect Forms 6i and Oracle 12c 12.2.0.1.0 [message #686024 is a reply to message #686023] Fri, 27 May 2022 09:26 Go to previous messageGo to next message
shamsad.khan@gmail.com
Messages: 12
Registered: October 2016
Junior Member
As per the link Compatibility matrices and differences between editions wiki page provided by,
oracle 8.1.7 client last version to get connected is oracle 10.2.

I have been successfully working on oracle 8.1.7 as client and Oracle 11.2 as server and forms 6i as my front-end for my applications.

[Updated on: Fri, 27 May 2022 09:26]

Report message to a moderator

Re: Unable to connect Forms 6i and Oracle 12c 12.2.0.1.0 [message #686025 is a reply to message #686024] Fri, 27 May 2022 09:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68257
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

There is a difference between "not supported" and "being able to do it".
"Not supported" means Oracle does not guarantee it will work but, unless Oracle code checks it at connect time and returns the famous ORA-03134 error, it may (or not) "work".

As the note specifies:

Quote:
Unsupported combinations may appear to work but can encounter errors for particular operations. The fact that they appear to work should not be relied upon - issues on unsupported combinations will not be investigated.

So you may have been in a case that works.


[Edit: clarify]

[Updated on: Fri, 27 May 2022 10:03]

Report message to a moderator

Re: Unable to connect Forms 6i and Oracle 12c 12.2.0.1.0 [message #686026 is a reply to message #686025] Fri, 27 May 2022 10:07 Go to previous message
shamsad.khan@gmail.com
Messages: 12
Registered: October 2016
Junior Member
Thanks a lot for the clarification
Previous Topic: Unable to connect to pluggable database - Oracle Datase 12.2.0.1.0
Next Topic: Not able to login to database using sqlplus after os patch
Goto Forum:
  


Current Time: Tue Aug 09 00:05:24 CDT 2022