2 Databases on Single Server

[Kashif]

Dear Members.

I have install ORACLE 9.2 on a server machine with OS Windows server 2003,
Then I create 2 databse instance on it with different SID. on client side i can access both the database using the Connect Strings.
But how can i access it both the Instances on the Server using SQL Plus.
because on server side there is no need to Enter Connect strings.

Thanks

[amirtai]

Kashif

Please set the ORACLE_SID env variable before starting sqlplus session.

C:>Set ORACLE_SID=mydb

Amir

[ArrowsolTraining]

set Oracle_SID