From: TurkBear Newsgroups: comp.databases.oracle.misc Subject: Re: ORA 12560: TNS: Protocol Adapter Error Date: Wed, 08 Aug 2001 13:50:58 -0500 Reply-To: See Message body for real address Message-ID: References: <3B700FF6.E27149D9@starconcept.com> <9kpf0t02qj2@enews1.newsguy.com> <3B7098BC.4E4BA1FB@starconcept.com> X-Newsreader: Forte Agent 1.8/32.548 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 58 X-Authenticated-User: turkbear X-Comments: This message was posted through Newsfeeds.com X-Comments2: IMPORTANT: Newsfeeds.com does not condone, nor support, spam or any illegal or copyrighted postings. X-Comments3: IMPORTANT: Under NO circumstances will postings containing illegal or copyrighted material through this service be tolerated!! X-Report: Please report illegal or inappropriate use to You may also use our online abuse reporting from: http://www.newsfeeds.com/abuseform.htm X-Abuse-Info: Please be sure to forward a copy of ALL headers, INCLUDING the body (DO NOT SEND ATTACHMENTS) Organization: Newsfeeds.com http://www.newsfeeds.com 90,000+ UNCENSORED Newsgroups. 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 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@gmx.at >> "Karsten Wutzke" schrieb im Newsbeitrag >> news:3B700FF6.E27149D9@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! =-----