Re: TNS failure - NT

From: <fgs3124_at_my-deja.com>
Date: Mon, 11 Sep 2000 16:42:27 GMT
Message-ID: <8pj21d$n7c$1@nnrp1.deja.com>

In article <8pirjq$euc$1_at_nnrp1.deja.com>,   mconlin_at_my-deja.com wrote:
> In article <8pipsf$htb$1_at_news.ipartners.pl>,
> "Lukasz Feldman" <lukasz_at_atm.com.pl> wrote:
> >
> > U¿ytkownik <mconlin_at_my-deja.com> napisa³ w wiadomo¶ci
> > news:8pdiqe$o37$1_at_nnrp1.deja.com...
> > >
> > >
> > > "tnsping oradev" and "tnsping oradev.sententia"
> > > results in TNS:packet writer failure
> > >
> > > Here is my tnsname.ora
> > >
> > > ORADEV.SENTENTIA
> > > (DESCRIPTION =
> > > (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(PORT = 1521) (HOST =
 DEV))
> > > (CONNECTION_DATA =
> > > (SERVICE_NAME = ORADEV)))
> > >
> > > here it the entry in listener.ora
> > >
> > > LISTENER =
> > > (DESCRIPTION_LIST = (DESCRIPTION =
> > > (ADDRESS_LIST =
> > > (ADDRESS = (PROTOCOL = IPC)(KEY=EXTPROC0))
> > > )
> > > (ADDRESS_LIST = (ADDRESS =
> > > (PROTOCOL = TCP)(HOST = DEV)(PORT = 1521)))))
> > >
> > >
> > >
> > > When I test the listener using lsnrctl status oradev.sententia
> > >
> > > I get the same error
> > >
> > > TNS:packet writer failure
> > > TNS: protocol adapter error...
> > >
> > > Any ideas ?
> > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.'
> >
> > But what about SID in listner.ora?
> > Mayby you have no sequence?
> >
> > Lukasz

>

> Lukasz, could you elaborate a bit......

>

> Thanks
> Mark

>

> Sent via Deja.com http://www.deja.com/
> Before you buy.

>
Are you multiplexing? If so, you must have defined how many dispatchers are utilized while listening on the host. Try to ping your fully qualified node name address (not the IP address) and see if you get a response. If not, then your oradev init file mts_dispatchers parameter is probably setup like the following which does not define an address to which the client should connect => mts_dispatchers = "(protocol=TCP)(disp=5)". Edit the mts_dispatchers parameter to read something like this => mts_dispatchers = "(address=(host=<ip address>) (protocol=TCP))(disp=5)".
This will supply the client machine an ip address to which it can successfully connect (you can also supply the node name of the host in the event you don't want to use the ip address). Remember to bounce the database to pick up the new init values.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 11 2000 - 11:42:27 CDT