Re: managing two instances on same server

On the server the value of ORACLE_SID will determine to which instance you connect. Alternatively, you can issue the set instance command in servermanager. This latter solution seems to require a sqlnet setup for 2 instances.
This is something you need to do anyway, as probably you are going to have clients connecting to both instances.
For that to work you need to add the new SID to listener.ora (just copy the first SID definition block and edit it) and the tnsnames.ora (you need to create a new service definition). Net Easy can do that for you, but in V7 you still needed to modify the listener.ora manually. This is all sqlnet stuff and is described in the SqlNet/Net8 manuals.

Hth,

--
Sybrand Bakker, Oracle DBA
<chrisoc_at_ans.net> wrote in message news:86q6nm$mvh$1_at_nnrp1.deja.com...
>
>
> I want the maximum independence in taking down one
> instance, modifying its storage etc. without affecting
> the other one.
>
> If I build the second instance with entirely distinct
> tablespaces and datafiles (including system, temp, rbs,
> redologs) and run the catproc etc. for it, I am still
> not certain how I will be able to connect as system or
> sys to just that instance and manage it without
> affecting the first one.
>
> Point me to a doc if the answer is complicated.
>
> Thank you,
> Chris O'Connor
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jan 27 2000 - 13:58:35 CST