Home » RDBMS Server » Networking and Gateways » Connection problems
icon9.gif  Connection problems [message #199422] Tue, 24 October 2006 03:39 Go to next message
rlucia
Messages: 2
Registered: October 2006
Junior Member
I have a remote server with oracle. In the middle there are 2 firewalls, the port 1521 are open.

I cant connect to BBDD.

Result of tnsping


C:\>tnsping BDHIS

TNS Ping Utility for 32-bit Windows: Version 9.0.1.1.1 - Production on 24-OCT-20
06 10:28:02

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Archivos de parßmetros utilizados:
C:\OraHome1\network\admin\sqlnet.ora
C:\OraHome1\network\admin\tnsnames.ora

Adaptador TNSNAMES utilizado para resolver el alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 10.136.47.42)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = BDHIS)))
Realizado correctamente (30 mseg)

ALL OK

But when I execute the SQLPLUS:

SQL*Plus: Release 9.0.1.0.1 - Production on Mar Oct 24 10:20:21 2006

(c) Copyright 2001 Oracle Corporation. All rights reserved.

ERROR:
ORA-12535: TNS:timeout de la operación


What is the problem??
I must open more ports to connect?



THX

Report message to a moderator

Re: Connection problems [message #200368 is a reply to message #199422] Mon, 30 October 2006 09:36 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
Are You connect from client if yes then 
cmd>ping ip address ( server ip address)

Means ur client and server connection is ok or not.

then try to connect through sqlplus.

Report message to a moderator

Re: Connection problems [message #200378 is a reply to message #199422] Mon, 30 October 2006 10:05 Go to previous messageGo to next message
rlucia
Messages: 2
Registered: October 2006
Junior Member
Quote:
C:\>ping 10.136.47.42

Haciendo ping a 10.136.47.42 con 32 bytes de datos

Respuesta desde 10.136.47.42: bytes=32 tiempo=16ms
Respuesta desde 10.136.47.42: bytes=32 tiempo<10ms
Respuesta desde 10.136.47.42: bytes=32 tiempo<10ms
Respuesta desde 10.136.47.42: bytes=32 tiempo<10ms

Estadísticas de ping para 10.136.47.42:
Paquetes: enviados = 4, recibidos = 4, perdido
Tiempos aproximados de recorrido redondo en milise
mínimo = 0ms, máximo = 16ms, promedio = 4ms



ping --> OK
tnsping --> OK
SQLNET -->ORA-12535: TNS:timeout de la operación


What happens?

Report message to a moderator

Re: Connection problems [message #200379 is a reply to message #200378] Mon, 30 October 2006 10:19 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
Try to set CONNECT_TIMEOUT parameter to be 0.

and try again ur operation.

The requested connection could not be completed within the timeout period specified by the CONNECT_TIMEOUT parameter in LISTENER.ORA. This error arises from the TNSLSNR.
Either reconfigure CONNECT_TIMEOUT to be 0, which means wait indefinitely, or reconfigure CONNECT_TIMEOUT to be some higher value.

--------------------------------------------------------------------------------

http://forums.devshed.com/oracle-development-96/ora-12535-tns-operation-timed-out-194287.html

Report message to a moderator

Previous Topic: SHARED SERVER TO DEDICATED CONNECTIONS
Next Topic: Can't connect to DB
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 09:44:35 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.