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: ORA-12154 : TNS: could not reslove service name

Re: ORA-12154 : TNS: could not reslove service name

From: abc <cv_at_wd.mn>
Date: 19 Jan 2000 13:59:01 GMT
Message-ID: <01bf6285$d1e23ae0$a76746a8@default>


Are you running on NT.
I have previous problem when same ethernet card of NT have configured with two different addresses and netmask. The order of the addresses affect Oracle connection. The client shall be in the same LAN segment of the first address. Otherwise, you can connect at the server via sqlplus but not from client.

Emmanuel <zouzou_at_yahoo.com> wrote in article <01bf5e7b$a9079ce0$3601017e_at_EHM.cirra.fr>...
> Could it be that you have SQL*NET V1 running on the server and SQL*NET V2
> running on the client or vice-versa ?
>
> Or on the client : a 16 bit software trying to access Oracle via a 32 bit
> SQL*NET ?
> Or a TCP/IP driver not properly installed on the client ?
>
> Sybrand Bakker <postmaster_at_sybrandb.demon.nl> a écrit dans l'article
> <947839935.25698.0.pluto.d4ee154e_at_news.demon.nl>...
> > Sorry, both that would result in either 'No listener' or 'Unable to
> connect
> > to destination'
> >
> > Regards
> >
> >
> > --
> > Sybrand Bakker, Oracle DBA
> > Emmanuel <zouzou_at_yahoo.com> wrote in message
> > news:01bf5e74$b4d46960$3601017e_at_EHM.cirra.fr...
> > > Or maybe the listener on the server is not started.
> > >
> > > Sybrand Bakker <postmaster_at_sybrandb.demon.nl> a écrit dans l'article
> > > <947835406.24005.0.pluto.d4ee154e_at_news.demon.nl>...
> > > > Should be an incorrect tnsnames.ora on the client and nothing more.
> > > >
> > > > Hth,
> > > >
> > > > --
> > > > Sybrand Bakker, Oracle DBA
> > > > Narayana Mahankali <nmahankali_at_acm.org> wrote in message
> > > > news:387EC831.CD07BA05_at_acm.org...
> > > > > hi ,
> > > > > i was trying to logon to server containing Oracle 8i from a
> > > client
> > > > > machine containing 8.0.5 client software. i was getting the
> following
> > > > > error.
> > > > >
> > > > > " ORA : 12154 : TNS: Could not resolve the service name"
> > > > >
> > > > > I checked the host name and the instance name. they were correct.
> > > > >
> > > > > Can someone tell me as to what the problem might be and how
i'm
> > > > > supposed to configure the client system. do i need to reinstall
> > client
> > > > > 8.1.5 s/w on that machine?
> > > > >
> > > > > -roopa.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >
>
Received on Wed Jan 19 2000 - 07:59:01 CST

Original text of this message

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