Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: tnsping is working but connect gives ORA-12535: TNS:operation timed out

Re: tnsping is working but connect gives ORA-12535: TNS:operation timed out

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sun, 14 Jan 2007 03:45:15 +0100
Message-ID: <eodff9$ksu$1@news5.zwoll1.ov.home.nl>


oracle dba schreef:
> hi,
>
> I made new database, one server. On client I did tns entry. Now
> tnsping <database_name>
> is working but when i try to connect to that database, first it took
> lots of time then it is giving time out error.
>
> ORA-12535: TNS:operation timed out.
>
> But when I switch both means make client as server and server as
> client, it is working.
> please tell me what can be the problem here.
>
> Oracle Database : 9.2.0.8
> Server OS : Windows XP
>

Firewall issue - remote connections are made using a random port, unless you are using Connection Manager, or you have dispatchers configured in the database. Looks like a stateful FW, as the reverse works.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Sat Jan 13 2007 - 20:45:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US