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@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@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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
