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!

Conected idle instance if i set oracle_sid=orcl which is not actual my sid

923095Nov 19 2012 — edited Nov 20 2012
Hello Team,

My original ORACLE_SID=PROD

ENV:- UNIX sOLARIS

NOW IF I SET oracle_sid=orcl (which is wrong) and connect to sqlplus...--Connected to idle instnace--agreed!!

since sid is different so how it did connected to sqlplus (i mean having wrong sid means wrong oracle_home/no oracle_home, so how did sqlplus got launched).
Any other OS level file is accessed to get connected to sqlplus??
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 18 2012
Added on Nov 19 2012
15 comments
3,821 views