2 Databases on Single Server

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
Kashif
Posts: 137
Joined: Wed Apr 26, 2006 5:57 am
Location: Pakistan
Contact:

2 Databases on Single Server

Post 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
amirtai
Posts: 138
Joined: Sat Apr 08, 2006 5:54 pm
Location: Canada
Contact:

Post by amirtai »

Kashif

Please set the ORACLE_SID env variable before starting sqlplus session.

C:>Set ORACLE_SID=mydb

Amir
ArrowsolTraining
Posts: 17
Joined: Fri Aug 03, 2012 4:26 am
Location: India
Contact:

Post by ArrowsolTraining »

set Oracle_SID
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests