Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: managing two instances on same server
I handled that scenario initially by REMOVING the oracle _sid value from my
registry. if you dont set it manually(in your batch fileor at the command
line), you dont connect to ANY instance (you get the message oracle
unavailable). it gets annoying if your half brain dead like myself and forget
to setit, so i eventually created a neutral instance (and set ORACLE_SID to
it)that does nothing but allow me to connect to preclude damage to my
production instances if i go nuts and forget where i've connected ( a frequent
enough occurance for myself)
In article <86qe79$t1a$1_at_nnrp1.deja.com>, chrisoc_at_ans.net says...
>
>Out of curiosity, what would happen if I
>went into svrmgrl and typed "connect internal"
>and then "shutdown immediate"?
>
>I typically do that rather than sql*plus with
>system/manager -- although I guess I will have
>to change my habits with two SIDs around.
>
>I want to bullet-proof the installation so we
>never accidentally shut down the wrong SID along
>with the one we intended to.
>
>Chris O'Connor
>
>
>
>
>In article <86qcml$rn6$1_at_nnrp1.deja.com>,
> ed.stevens_at_home.com wrote:
>> 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.
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu Feb 03 2000 - 10:48:48 CST