Re: How can I delete one of two instances?

Hi all,
thanks for advices. I just make some considerations for installing X utility on my desktop.
Maybe just test with a test database on another pc... and what I want to do is just a deletion
of a instance. The constellation is just that as I wrote above. I always redefine SID with 'export ORACLE_SID' when I work there. And I also think it may be easier that I make the change of SID permanently. However the question is how I could delete (or say 'remove') one unneeded instance and then I want to delete the data files which belongs to that unneeded instance also. Is it impossible?

Thanks
Shin

DA Morgan ÀÛ¼º:

> 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
Received on Sat Nov 25 2006 - 02:35:54 CST