Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I delete one of two instances?
The most simple way to delete an instance is by using GUI Database
Configuration Assistant utility. You can start it from your shell
console using dbca command.
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
Received on Fri Nov 24 2006 - 04:17:41 CST