ORA-12560 error

From: Vince Laurent <vlaurent_at_NOSPAMPLEASE.networkusa.net>
Date: Thu, 23 Aug 2001 11:54:12 -0500
Message-ID: <b7daotgjfpus200cjdokcrq788b6ebfv9a@4ax.com>

Here is my situation:
Windows 2000 running Oracle 8.1.6

I go to the command prompt and type:

        lsnrctl start
and the listener starts OK

I then issue the command:

	sqlplus /nolog


	>connect internal

at which point I get an ORA-12560 TNS:protocol adapter error

I do a

        tnsping toy
and the ping connects

I try to set a local environment variable (cause a web page gave it as an idea for troubleshooting)

        set LOCAL=NOTTOY

Then I try the sqlplus again

        ORA-12154 TNS:Could not resolve service name

so I

         set LOCAL=TOY

Then I try again

        ORA-12500 TNS: listener failed to start a dedictated server process

I have read and tried trace files but they are greek to me. All I want it oracle to start! I have tried starting the listener AND oracle via the services panel but I get the same thing in the system log files.

Any help would be greatly appreciated!
Thanks!
Vince Received on Thu Aug 23 2001 - 11:54:12 CDT