Re: ORA 12560: TNS: Protocol Adapter Error

In sounds like a failure to resolve the tnsnames.ora entry.. Try setting another environment variable: set TNS_ADMIN = ( full path to the subdirectory where tnsnames.ora is located - note the subd name not the file name itself) for instance:
set TNS_ADMIN = c:\Orant\network\admin

( does it make any difference if you use SqlPlus in Windows instead of a DOS box?)

Karsten Wutzke <karsten.wutzke_at_starconcept.com> wrote:

>Unfortunately, this has no effect. I set the current Windows user's
>environment variable oracle_sid = orcl, in the MS-DOS box when typing set,
>this line always appears, so the variable is set correctly. When launching
>sqlplus.exe there's no difference however...
>
>Karsten
>
>Gaby Spiessl wrote:
>
>> Hi,
>> it looks like you have more than one oracle instance
>> try to set the oracle sid:
>> at DOS: set oracle_sid=sidname
>> You can set the sid_parameter in the registry
>> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
>> HOME0 - ORACLE_SID
>>
>> --
>> Gaby Spiessl
>> gspiessl_at_gmx.at
>> "Karsten Wutzke" <karsten.wutzke_at_starconcept.com> schrieb im Newsbeitrag
>> news:3B700FF6.E27149D9_at_starconcept.com...
>> > Hi all!
>> >
>> > I have posted a message just a few hours ago, but the problem seems to
>> > be harder to solve than expected. I have searched the net already, but I
>> > couldn't find any useful answers, whereas I found MANY questions
>> > regarding the same issue.
>> >
>> > I have installed Oracle8i Personal on my machine (Windows 2k Pro). The
>> > DB is to be used locally only, at least for now. When I try to log on
>> > with "sys"/"manager"/"" (without the "" of course), the error message
>> > "ORA 12560: TNS: Protocol Adapter Error" appears. Does anyone know
>> > what's going on?
>> >
>> > Thanks for helping a COMPLETE DB NEWBIE...
>> >
>> > Karsten
>> >
>> > PS: Sorry for the X-post, but it's really important to me!
>> >

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Wed Aug 08 2001 - 13:50:58 CDT