RE: Bizzare behaviour of set oracle_sid=mysid

2002-12-22 Thread Hemant K Chitale
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

Bizzare behaviour of set oracle_sid=mysid

2002-12-19 Thread Bob Metelsky
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

Re: Bizzare behaviour of set oracle_sid=mysid

2002-12-19 Thread Hemant K Chitale
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

RE: Bizzare behaviour of set oracle_sid=mysid

2002-12-19 Thread Bob Metelsky
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