Re: How can I delete one of two instances?

Shinyday wrote:
> 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

Instances are not removable ... databases are. If you want to drop a database then the DROP DATABASE command is what you are looking for.

It is documented in Morgan's Library at www.psoug.org under DATABASE.

-- 
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