Home » RDBMS Server » Networking and Gateways » Oracle networking problem
Oracle networking problem [message #553548] Sun, 06 May 2012 13:38 Go to next message
Messages: 1
Registered: May 2012
Junior Member
Hi all,

I installed oracle XE 10.2 and I am not able to establish network connection. I can connect with sqlplus (Oracle works) but not with SQLdevelpoer (listener doesn't work). I described my problems at oracle forum but I didn't get any answer (forums.oracle.com/forums/thread.jspa?threadID=2380717&tstart=15). That is why i try here.

As far as I see from tracing logs, server receives connection request, but it never responds:

Fatal NI connect error 12170.

TNS for 32-bit Windows: Version - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version - Production
Time: 04-MAY-2012 21:45:16
Tracing to file: D:\progs\oracle\app\oracle\product\10.2.0\server\network\trace\svr_3424.trc
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: <unknown>

I attached svr_3424.trc.

I've been struggling with this for days and it looks to me that there is no way to make this work. Any ideas, is there anything I could try.


Re: Oracle networking problem [message #553551 is a reply to message #553548] Sun, 06 May 2012 13:51 Go to previous message
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>TNS-12535: TNS:operation timed out
most common cause is that Window Firewall is enabled & blocking packet exchange.
I suggest as just a test to stop the FireWall & see if you can then connect to the DB
Previous Topic: error ORA-12154
Next Topic: TNS-03505: Failed to resolve name
Goto Forum:

Current Time: Tue May 24 11:06:19 CDT 2022