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 Go to next message](/forum/theme/orafaq/images/down.png) |
![](//www.gravatar.com/avatar/906d045f8df9679d3a00a137b4af245d?s=64&d=mm&r=g) |
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
|
|
|
|
|