Re: How can I delete one of two instances?

Hi Vitaliy,
the problem is that I cannot use any gui tools. Unfortunately I must do it in a pure text mode console since I access this system only through putty.

Would you please give me some more helps if you could do?

Thanks
Shin

Vitaliy Vorontsov ÀÛ¼º:

> 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:35:30 CST