Re: TNS failure - NT

From: missing <tonal_at_pestilence.net>
Date: Tue, 12 Sep 2000 15:24:32 +0100
Message-ID: <39BE3CA0.9EC33BB6@pestilence.net>

mconlin_at_my-deja.com wrote:
>
> 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
> > > > >
> > > > > TNS:packet writer failure
> > > > > TNS: protocol adapter error...
> > > > But what about SID in listner.ora?
> > > > Mayby you have no sequence?
> > 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.

Is this Windows client to Unix Server?
What version is it?

What do you get on the server from lsnrctl status? If you don't see your SID there then add this to the listener.ora file, shutdown database, stop listener, start listener, start database. IN THAT ORDER. SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME= <sid>)
      (ORACLE_HOME= /u01/app/oracle/product/8.0.5)
      (SID_NAME = <sid>)

    )
    (SID_DESC =

      (SID_NAME = extproc) 
      (ORACLE_HOME = /u01/app/oracle/product/8.0.5) 
      (PROGRAM = extproc) 

    )
  ) Received on Tue Sep 12 2000 - 09:24:32 CDT