| Unable to connect Forms 6i and Oracle 12c 12.2.0.1.0 [message #686022] |
Fri, 27 May 2022 07:01  |
 |
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
- TNSNAMES.ORA Network Configuration File: C:\Oracle\Ora81\network\admin\tnsnames.ora
- Generated by Oracle configuration tools.
KIC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.112)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = kic)
)
)
- 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)
)
)
- 192.168.1.105 - Windows 7 64 bit
My tnsnames.ora for Forms 6i
- TNSNAMES.ORA Network Configuration File: C:\Oracle\Ora81\network\admin\tnsnames.ora
- 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 #686025 is a reply to message #686024] |
Fri, 27 May 2022 09:57  |
 |
Michel Cadot
Messages: 68641
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
