Re: TNS failure - NT

From: missing <tonal_at_pestilence.net>
Date: Tue, 12 Sep 2000 13:42:45 +0100
Message-ID: <39BE24C5.891CC93A@pestilence.net>

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

Some things to check:

1. unix /etc/hosts - is there an alias DEV with correct IP address?
2. windows c:\winnt\system32\drivers\etc\hosts as above
3. You only need ADDRESS_LIST once.
4. What server version? If 8.0 you need SID=ORADEV

   (that is unless it's oradev) Received on Tue Sep 12 2000 - 07:42:45 CDT