RE: Bizzare behaviour of set oracle_sid=mysid

Humm obivioiously Im missing a few brain cells here.... Yes, I should know there isnt an exe called connect that would be native to the envioriment outside of oracle.

Yes, there was a connect.bat in the path Duh...

Ok, so lets see how many more vacant brain cells I have....  now if I log on to sql+ with a dba account (has all privilidges)

#######################################

LOCDB SQL> connect / as sysdba
Or
LOCDB SQL> connect / internal

ERROR:
ORA-12560: TNS:protocol adapter error

Warning: You are no longer connected to ORACLE.

LOCDB SQL> select * from global_name;
Not connected

#######################################

Why does this happen?

The bottom line is Im trying to connect as internal w/o the password

#######################################

C:\>set oracle_sid=LOCDB

C:\>svrmgrl

Oracle Server Manager Release 3.1.6.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option
JServer Release 8.1.6.0.0 - Production

SVRMGR> connect internal
Password:

I can however connect internal/password

Thanks for being paitent

bob

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  INET: bmetelsky_at_cps92.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).