Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12154 : TNS: could not reslove service name
Check your sqlnet.ora to see if you have the "default_domain" defined. It
typically is enabled (uncommented) and is set to ".world". Therefore if you
have a TNSNAMES.ORA entry of "mydb" with NO domain specified (an example of
a service name with a domain would be "mydb.world"), the default domain is
appended by oracle. If you enter "mydb" as the service name in an
application, the error you are getting will occur since it cannot find an
entry of "mydb" (remember, the entry is now "mydb.world" since oracle has
appended the default domain to the tnsnames.ora entry). If you place a #
sign at the beginning of the "default_domain" line, the default domain is
not used and will not be appended and the service name should be found. The
other way to fix it is to enter the entire service name (e.g. mydb.world)
in the application if you do not comment out the default_domain line.
Hope this helps...
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 Sun Jan 16 2000 - 15:17:04 CST
![]() |
![]() |