Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: ORA 12560: TNS: Protocol Adapter Error
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...Received on Tue Aug 07 2001 - 14:19:21 CDT
> 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!
>