RE: Bizzare behaviour of set oracle_sid=mysid

You would be getting the TNS protocol adapter error if the instance hasn't been started -- it is configured to start as a service. Hemant
At 08:45 AM 19-12-02 -0800, you wrote:
>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).

Hemant K Chitale
My web site page is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

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).