Re: managing two instances on same server

From: <ed.stevens_at_home.com>
Date: Thu, 27 Jan 2000 21:18:19 GMT
Message-ID: <86qcml$rn6$1@nnrp1.deja.com>

Create entries for the second sid in your LISTENER.ORA and TNSNAMES.ORA files and refresh the listener. Say your first instance was ORC1 and your new, second is ORC2. Whenever you connect, use the connect string in the form 'CONNECT userid/pwd_at_alias' where 'alias' is the alias in TNSNAMES.ORA that specifies the sid you want to connect to. That will be the sid you connect to and that will be the sid any commands you issue will be performed against.

In article <86q6nm$mvh$1_at_nnrp1.deja.com>, chrisoc_at_ans.net wrote:
>
>
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jan 27 2000 - 15:18:19 CST