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: TNS failure - NT

Re: TNS failure - NT

From: <mconlin_at_my-deja.com>
Date: Tue, 12 Sep 2000 13:57:50 GMT
Message-ID: <8plcoi$f14$1@nnrp1.deja.com>

In article <39BE24C5.891CC93A_at_pestilence.net>,   missing <tonal_at_pestilence.net> wrote:
> 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)

>

Okay, no problem with alias for DEV, I can "ping DEV" and get results. I have been able to get named pipes connections working no problem, however the TCP/IP connection will not work.

Is there Anything that could cause this ? I am setting up the connections with the Net8 Assistant and I still have not succefully gotten a TCP/IP connection up.

?!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 12 2000 - 08:57:50 CDT

Original text of this message

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