Problem connecting to Oracle 8i using SQL plus

From: magma <djmagma_at_despammed.com>
Date: Fri, 14 Jul 2006 10:47:08 +0200
Message-ID: <khleb2det6t0jpgneu5ka588p38tc8u43q@4ax.com>

Hello there,
I have this problem connecting to a db instance on a remote server via VPN. Using SQL plus, the connection fails after some seconds, returning this error message: "ORA-12535: TNS: Operation time out".

On the two firewalls that realize the VPN connection the policies seem applyed correctly (ANY service passes between the two hosts), in fact when I do a "TNS ping" to the Oracle server, it answers correctly.

I include the log of the error above, maybe it can be helpful:

---

Fatal NI connect error 12535, connecting to:

(DESCRIPTION=(SOURCE_ROUTE=OFF)(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.70.2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORACLE)(SERVER=DEDICATED)(CID=(PROGRAM=C:\Program
Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=FPFDBN1)(USER=fpfr00t))))

  VERSION INFORMATION:

	TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
	Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows:

Version 9.2.0.1.0 - Production
  Time: 14-LUG-2006 10:33:26
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12535
    TNS-12535: TNS: operazione fuori tempo     ns secondary err code: 12560
    nt main err code: 505
    TNS-00505: Operazione fuori tempo
    nt secondary err code: 60
    nt OS err code: 0

---

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\Program
Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=FPFDBN1)(USER=fpfr00t))))

  VERSION INFORMATION:

	TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
	Oracle Bequeath NT Protocol Adapter for 32-bit Windows:

Version 9.2.0.1.0 - Production
  Time: 14-LUG-2006 10:33:26
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12560
    TNS-12560: TNS: errore dell'adattatore del protocollo     ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Errore di adattatore del protocollo     nt secondary err code: 126
    nt OS err code: 0

Any suggestion?

Thanks in advance very much.

Regards.

-- 
When she's walking by the river and the railway line
she can still him whisper
let's go down to the waterline.

Received on Fri Jul 14 2006 - 03:47:08 CDT