Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Wrong ORACLE_SID but still able to connect to it. why ?

620942Jul 19 2008 — edited Jul 21 2008
Hi guys,

In my windows XP system, i got 9i and 10g both running.

9I ORACLE_SID = abc
10g ORACLE_SID = oic

I am testing my Logic of ORACLE_HOME+ORACLE_SID = memory of instance.
SO

i explicity set an environment variable ORACLE_SID = abc (9i).
i have no ORACLE_HOME environment variable setup. (The rest of the values are all in registry)

So, i to the exact folder of sqlplus (10g) c:\oracle\product\10.2.0\bin\sqlplusw.exe
By right, once i open the program, IF i am not wrong, it will search for a file call oracle.key in the BIN folder then from there, went to registry to get the ORACLE_HOME value.

and since it is going into the 10g BIN and getting the 10g HOME value.

10g ORACLE_HOME + 9i SID = no such memory exist.
However, i am still able to connect to the oracle 9i database locally.

May i know why ?

Any enlightenments gurus ?
Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 18 2008
Added on Jul 19 2008
15 comments
2,215 views