Page 1 of 1

2 Databases on Single Server

Posted: Thu Jun 24, 2010 2:56 am
by 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

Posted: Sun Jun 27, 2010 2:21 am
by amirtai
Kashif

Please set the ORACLE_SID env variable before starting sqlplus session.

C:>Set ORACLE_SID=mydb

Amir

Posted: Thu Aug 09, 2012 9:54 am
by ArrowsolTraining
set Oracle_SID