You can define your own registry entry for your chosen database.

Thanks & Keep in touch
Bharat, The Georgian
"Evil Has Its Winning Ways"

-----Original Message-----
From: Chandrasekhar Rao Dharmapurinagaraja
[mailto:oracledba-ezmlmshield-x31692175.[Email address protected]
Sent: Thursday, May 11, 2006 2:46 AM
To: LazyDBA Discussion
Subject: default sid

Hi,



On one of our Windows server, I have 6 oracle databases of version 9i.



When I give set oracle_sid=database_name in the command line, and try to
login as conn / as sysdba in the SQL*PLUS (I was expecting to connect to
the database_name that I have set in the command prompt), but it always
connects to the oracle database that was created last on the server.



On checking the regedit entries I found that the Default_sid=last
database name. I have no clue as to why this has happened. Can I remove
the registry setting of the default_sid, so that I can expect to connect
to the database that I set in the command prompt?



Let me know of your views and ideas.



Regards,

Chandra


Disclaimer:
This email and any files attached hereto are confidential and intended for
the sole use of the individual or entity to
which they are addressed. If the reader of this message is not the intended
recipient, you are hereby notified that any
unauthorized disclosure, dissemination, distribution, copying or the taking
of any action in reliance on the information
herein is strictly prohibited. If you are not the intended recipient, please
contact the sender and delete all copies.




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page