Re: Problem connecting to Oracle 8i using SQL plus

magma wrote:
> 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.

Please *ALWAYS* search Google. Don't think your error is unique. It isn't. I have posted the solution at least a 1000 times.

-- 
Sybrand Bakker
Senior Oracle DBA