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.



Oracle LazyDBA home page