Re: ORA-12560 error

From: Vince Laurent <vlaurent_at_NOSPAMPLEASE.networkusa.net>
Date: Thu, 23 Aug 2001 16:40:24 -0500
Message-ID: <gvtaot41d43jldiipq1bfcl6b4ctu3m5ij@4ax.com>

As I mentioned in my first note:

"so I

set LOCAL=TOY

Then I try again"

The SID is also in the tnsnames.ora file.

Sorry I wasn't clear that TOY was the SID.

Thanks for your help.
Vince

ORA-12500 TNS: listener failed to start a dedictated server On Thu, 23 Aug 2001 17:53:38 GMT, plovmand_at_hotmail.com (Kenneth Koenraadt) wrote:

>2 solutions :
>
>set oracle_sid=<MYSID
>sqlplus /nolog
>
>That will connect directly to the <MYSID> database on your local machine.

>
>When connecting through NET*8, as you try to, you also need to add
><MYSID> to your TNSNAMES.ORA file, either directly in the file or via
>NET assistant.
Received on Thu Aug 23 2001 - 16:40:24 CDT