Re: TNS-12542: TNS:address already in use

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Sat, 9 Apr 2005 00:07:51 +0200
Message-ID: <425700b7$0$30464$ba620e4c@news.skynet.be>

"HARI OM" <hari_om_at_hotmail.com> wrote in message news:1112995159.297395.137510_at_l41g2000cwc.googlegroups.com... Thanks Hans...

The only change I have made since last month is that other folks here installed SAS 9.1 on the same Server. But they are pretty sure it is not using PORT 8080 or PORT 2100...

My LISTENER.TRC file is:
--------------------------------------------------------------
nttcnp: error - address is already in use - may be caused by data remaining in a previous disconnected socket. ntt2err: soc 17 error - operation=1, ntresnt[0]=512, ntresnt[1]=67, ntresnt[2]=0
nserror: nsres: id=0, op=65, ns=12542, ns2=12560; nt[0]=512, nt[1]=67, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nsopen: unable to open transport
--------------------------------------------------------------

What about your application servers ? Are these Windows machines ? Is there a firewall between the db server and the app server ?

Matthias Received on Fri Apr 08 2005 - 17:07:51 CDT