Re: Help! ORA-12560 Tns protocol error

In article <8jvn2j$ei6$1_at_nnrp1.deja.com>, sjoshi_at_ingr.com wrote:

>Hello All
> This error with Oracle is driving me nuts. I can do a tnsping to the
>service and lsnctrl says 1 listener configured. However if I go to
>server manager, I get an error ORA-12560 TNS protocol adapter error.
>I also the checked the sid under \ORACLE\HOME2 and it does have an
>entry for ORACLE_SID pointing to the correct instance.
>
>Any help is greatly appreciated.
>
>thanks
>Sunit
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

One possible way this can happen is if your sqlnet.ora file contains a 'names.default_domain' entry that is inconsistant with your service alias name that you are using. For example, if this parameter contains "world" (NAMES.DEFAULT_DOMAIN=WORLD is Oracle's default) then if your connecting to a service using the alias "database" (in your tnanames.ora file), Oracle will add ".world" to the service alias name entered, or to what you default if you used 'set oracle_sid=<sid>'. It then looks for an entry in tnsnames.ora called "database.world", when it doesn't find it you get the error you described (this happened to me exactly how you decribe it).
I think you have two options: 1. Remove the 'names.default_domain' if this is your own private database; or 2. Add the value of 'names.default_domain' to the alias name in your tnsnames.ora file, so it looks something like...

database.world =

   (description =

      (address_list =

etc., etc., etc...

Hope I explained this right and it helps.

Steve M Received on Sat Sep 09 2000 - 15:26:00 CDT