Re: How can I delete one of two instances?

Hi, Shinyday :)

It's not much a problem to run GUI application. The following solution might be helpful:
1. Install X-server software on your windows client machine. This could be XMing software. After XMing installation add in file c:\Program Files\Xming\X0.hosts ip address of your Linux server to allow a connection from server to you windows client. 2. Set environment variable on Linux server like this:   export DISPLAY=_windows_client_ip_address:0.0 3. Start dbca utility

After following steps you should see you GUI DBCA window.

Good luck.

Shinyday wrote:
> 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 - 05:21:44 CST