>Hello All
> I have a situation like this: I have two databases, one with instance
>name A and second with instance name B. I have already created an
>ORACLE_SID in the registry with value of A. Now since I have created
>another instance(B) and if I want to use the B instance, do I use the
>set instance command to set my current instance to B. Will this effect
>the users who are currently using A. All the databases are on the server
>
>thanks
>Sunit
>
>
You have to use Listener to access the DB. You have to insert A and B in
"listener.ora" and A and B in "tnsnames.ora". When a client try to access a
DB it must specify a SID. So it 'll connect to that DB
Michele Viviani DBA
Received on Wed Oct 13 1999 - 11:07:28 CDT
