Re: Bizzare behaviour of set oracle_sid=mysid

Are you executing "connect internal" at the CMD C:> prompt ? Shouldn't it be in the sqlplus prompt ?
See if you've somehow got a CONNECT.BAT file in your path. If you are executing C:> connect internal, you are probably executing CONNECT.BAT [or CONNECT.EXE or CONNECT.COM]
Hemant
At 06:39 AM 19-12-02 -0800, you wrote:
>Only in my office can this happen....
>
>Im checking into connecting to the db under the internal account
>
>from a cmd prompt I set oracle_sid=mysid
>C:> set
>oracle_sid=my_sid
>
>C:> connect internal
>
>I see cmd issuing
>
>sqlplusw system/password_at_othersid
>
>So, I add a permanent env_variable called ORACLE_SID I set the value to
>a bogus name eg mysid
>
>go to cmd
>C:>set
>ORACLE_SID=mysid
>then I set ORACLE_sid=LOCDB
>set
>ORACLE_sid=LOCDB
>
>then connect internal
>I see cmd doing sqlplusw system/password_at_othersid
>
>It fails because I dont have a tns entry for othersid
>
>
>Where the heck is cmd getting the values for othersid??
>any ideas?
>
>thanks
>bob
>######################################
>LOCDB SQL> select version from v$instance;
>
>VERSION
>-----------------
>8.1.6.0.0
>######################################
>
>Below is my output of set
>
>C:\>set
>ALLUSERSPROFILE=C:\Documents and Settings\All Users APPDATA=C:\Documents
>and Settings\bmetelsky\Application Data CI_HOLOS_CLI=C:\Program
>Files\Seagate Software\Open Olap\
>CLASSPATH=D:\Programs\;C:\gnupg;C:\Oracle\Ora81\orb\classes\yoj.jar;C:\O
>racle\Ora81\orb\classes\share.zi
>CommonProgramFiles=C:\Program Files\Common Files COMPUTERNAME=CPS109
>ComSpec=C:\WINNT\system32\cmd.exe
>HOMEDRIVE=e:
>HOMEPATH=\bob
>LOGONSERVER=\\A_LOGON
>NUMBER_OF_PROCESSORS=1
>oracle_home=C:\Oracle\Ora81
>ORACLE_SID=LOCDB
>OS=Windows_NT
>Os2LibPath=C:\WINNT\system32\os2\dll;
>Path=D:\Oracle\Ora81\bin;C:\vim\vim\vim60;D:\Perl\bin\;C:\Oracle\Ora81\b
>in;C:\Oracle\Ora81\bin\bin80;C:\
>am
>Files\Oracle\jre\1.1.7\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\
>Wbem;C:\Oracle\Ora81\orb\bin;
>ULTRAE~1 PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
>PERLDB_OPTS=RemotePort=127.0.0.1:2000
>PROCESSOR_ARCHITECTURE=x86
>PROCESSOR_IDENTIFIER=x86 Family 15 Model 0 Stepping 10, GenuineIntel
>PROCESSOR_LEVEL=15 PROCESSOR_REVISION=000a ProgramFiles=C:\Program Files
>PROMPT=$P$G
>SystemDrive=C:
>SystemRoot=C:\WINNT
>TEMP=C:\
>TMP=C:\
>USERDNSDOMAIN=MYDOMAIN
>USERDOMAIN=MYDOMAIN
>USERNAME=bmetelsky
>USERPROFILE=C:\Documents and Settings\bmetelsky
>windir=C:\WINNT
>--
>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).