Re: ORA 12560: TNS: Protocol Adapter Error

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!
> >
Received on Tue Aug 07 2001 - 20:41:16 CDT