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 resolve service name, why?

Re: ORA-12154: TNS:could not resolve service name, why?

From: <chandrasekar_at_my-dejanews.com>
Date: Fri, 22 Jan 1999 11:13:09 GMT
Message-ID: <789mg0$i4r$1@nnrp1.dejanews.com>


In article <784dit$p1h$1_at_dragon.infopro.spb.su>,   "Alexander Romanov" <sashar_at_comita.spb.ru> wrote:
>
> Paal Berggreen пишет в сообщении <782nvq$kq7$1_at_readme.online.no> ...
> >I have installed Oracle 8 on NT40 Wks (sp4). However, I get "ORA-12154:
> >TNS:could not resolve service name" when I try to connect to the db using
> >enterprise manager (or any other db tool). I assume this is because the
> >service OracleTNSListener80 is not running. The service has startup mode
> >Automatic, but does not run (after boot). When I start the service
> manually,
> >I get the error "Could not start the ... service on <hostname>, Error 1067:
> >The process terminated unexpectedly".
> >
> >So, my question is: is this service required to run, and if so; what may be
> >(typical?) possible causes for the startup failure of the service? Oracle
> in
> >installed on \ORANT
>
> Required started OracleService<SID> and TNSListener
> If install Oracle with default database this service must by created
> automatic.
>
> Hi,

     I faced the same problem with TNS . Try the following : If oracleTNS listener is in the auto mode and oracleTNS80 is manual , interchange the mode and stop your oracleTNS listener and start TNS80 . Then try to create a service at the host and retry connecting to the database. It worked for me . I suppose it may work for u too . In case of any further clarifications feel free to write .
cheers
G.CHANDRASEKAR -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 22 1999 - 05:13:09 CST

Original text of this message

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