Home » Developer & Programmer » Forms » unable to connect to my remote database on Oracle 11GR from Forms 6i (Oracle Forms 6i, Windows server 2019)
unable to connect to my remote database on Oracle 11GR from Forms 6i [message #683564] Sun, 31 January 2021 22:18 Go to next message
clor
Messages: 1
Registered: January 2021
Junior Member
Hi,

I could'nt connect to my remote database (Oracle 11GR2) from Forms 6i on my application server, but on the same Application server I installed Oracle client 11G, and it is getting connected without issue on the remote server.
When I type tnsping80, it is ok 1 on 2 time

The error in sqlnet.log is

Fatal NI connect error 12203, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxx)(PORT=1521))(CONNECT_DATA=(SID=xxxxx)(CID=(PROGRAM=E:\orant\BIN\PLUS80.exe)(HOST=xxx xx)(USER=xxxxxx))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.0.6.3.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.0.6.3.0 - Production
Time: 01-FEV-2021 03:49:23
Tracing not turned on.
Tns error struct:
nr err code: 12203
TNS-12203: TNS : connexion à la destination impossible
ns main err code: 12535
TNS-12535: TNS : le délai imparti à l'opération est écoulé
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Temps imparti à l'opération écoulé
nt secondary err code: 60
nt OS err code: 0


Re: unable to connect to my remote database on Oracle 11GR from Forms 6i [message #683566 is a reply to message #683564] Mon, 01 February 2021 00:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You cannot connect a 11.2 database with a 8.0.6 client.

Re: unable to connect to my remote database on Oracle 11GR from Forms 6i [message #683570 is a reply to message #683564] Mon, 01 February 2021 01:40 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Forms 6i uses the 8.0.6 foundation layer and is not supported for use with an 11.2 database, except as part of an E-biz installation. See here,
https://oracle-patches.com/en/is/4071-introduction-to-oracle-e-business-suite?start=13
So you can make it work, but you are on your own. A good start is to go through notes such as this,

Interoperability Notes EBS 11i with RDBMS 12cR1 (Doc ID 1524399.1)

though of course you need a support contract to do that.
Previous Topic: Form error
Next Topic: Alert window Close button [ x ] to be disabled in information/caution type alerts
Goto Forum:
  


Current Time: Thu Mar 28 05:11:23 CDT 2024