Oracle-L: Bizzare behaviour of set oracle

From: Bob Metelsky <bmetelsky_at_cps92.com>
Date: Thu, 19 Dec 2002 06:39:22 -0800
Message-ID: <F001.0051E1DE.20021219063922@fatcity.com>

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). Received on Thu Dec 19 2002 - 08:39:22 CST

Bizzare behaviour of set oracle_sid=mysid