Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: ORA 12560: TNS: Protocol Adapter Error

Re: ORA 12560: TNS: Protocol Adapter Error

From: Gaby Spiessl <gspiessl_at_gmx.at>
Date: Tue, 7 Aug 2001 21:19:21 +0200
Message-ID: <9kpf0t02qj2@enews1.newsguy.com>

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 - 14:19:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US