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@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).
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: [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).
