Re: Help! ORA-12560 Tns protocol error

In article <smccull1-40A5ED.16242809092000_at_news-server>, Steve McCulloch <smccull1_at_tampabay.rr.com> wrote:

>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

Whoops, that's what happens when you talk on the phone and read a message...
Try this instead: 1. Make sure databse is running (obvious, I know); 2. Issue 'set oracle_sid=<sid>', <sid> being whatever the sid name is, BEFORE starting server manager. 3. Connect as favourite user. If this prevents the error, then you can issue this before starting server manager OR add it to your system registry, under HKEY_LOCAL_MACHINE:SOFTWARE:ORACLE:HOME2 (this assumes your description mentioned the proper home) or for UNIX, set the environment variable (I THINK using 'set oracle_sid=<sid>' then 'export oracle_sid' - these can be added to your .profile file)

Again,

Steve Received on Sat Sep 09 2000 - 16:05:23 CDT