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...

• Allen

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