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: Chris Boyle <cboyle_at_no.spam.hargray.com>
Date: Fri, 29 Dec 2000 12:17:07 -0500
Message-ID: <92igvm$d44i$1@news3.infoave.net>

We had the same problem and had to add a line in the registry to declare the SID of the current instance
<user_20017506_at_my-deja.com> wrote in message news:92gpkl$bds$1_at_nnrp1.deja.com...
>
>
> After spending several days on this I have come
> to this, a last cry for help...
>
> I am running Window2000 Professional with Oracle
> 8i Personal Edition. All was going well in my
> efforts to do some testing on running a script to
> build a database; when all of a sudden I began to
> get this ORA-12560 error message when I (either
> manually or my script) tried to use SQL*Plus or
> Server Manager.
>
> I thought it may have been some of the tinkering
> around I had done, so I went as far as
> uninstalling Oracle, restarting the machine and
> then reinstalling it again; but immediately
> received the same error when trying to open
> svrmgrl or sqlplus in command line mode. I have
> checked all of the related files, listener.ora,
> tnsnames.ora, etc.; and all appear in order or at
> their default values.
>
> I've noticed that on several news groups and
> Oracle sites many people seem to be having this
> same problem - but I never see any answers to
> these posts on the issue....
>
> Any ideas? Or can anyone point to a good site
> which will explain how to read the trace files
> generated by the TNSListener?
>
>
> --
> Art Vandelay
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Dec 29 2000 - 11:17:07 CST

Original text of this message

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