Re: How can I delete one of two instances?

Shinyday wrote:
> I have 2 oracle (9i) instances on one linux system (RedHat).
> Say they are test_1 with SID test_1_S and test_2 with SID
> test_2_SID. The problem is now the instance test_1 is not
> active and the instance test_2 is running currently. However
> the system sees test_1_s as the active SID. Therefore I
> must export always the test_2_s for running database if I
> want to connect as sysdba. This is very annoying for me.
> So, I want to delete this inactive instance test_1 without
> touching the active instnance test_2.
> Could someone help me for this issue?
>
> Thanks in advance
> Shin

An instance, technically speaking, can not be deleted. What is it you are actually trying to do?

It strikes me that just redefining ORACLE_SID would solve the problem you appear to have presented.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org