Re: Can't delete Bad Instance

From: Jason Salter <jason_at_seahorse.demon.co.uk>
Date: Wed, 14 Oct 1998 11:03:24 GMT
Message-ID: <36248472.4602768@news.demon.co.uk>

On Thu, 08 Oct 1998 15:04:35 +0100, Nick Parsons <edl.nospamedlnsps_at_mesmtpse.ericsson.se> wrote:

>Nebojsa Petrovic wrote:
>>
>> Helmut Hahn wrote in message <360250EC.3C481EA0_at_bitoek.uni-bayreuth.de>...
>snip deleting instances
>> >Open a command shell and type
>> >
>> >oradim80 -h
>> >
>> >and you will get the options.
>> >
>> >oradim80 -DELETE BADSID
>> >
>> >should do it. (I think it does not look for anything like passwords etc.
>> but only removes the Service).
>> >It worked already sometimes for me!
>> >
>> >Helmut
>>
>> Is there something like oradim80 -DELETE BADSID for ORACLE 7.3.2 on AIX4.1
>> and AIX4.2
>>
>> Thanks
>
>I think 'oradim80' may be an NT specific command.
>
>Wouldn't running SHUTDOWN ABORT and then deleting all *appropriate*
>'dbf', 'log' and 'ctl' files using rm get rid of the instance for you?
>
>Nick..

You'd need to stop the OracleServiceSID and OracleStartSID services too. A sledgehammer method of getting rid of the instances would be to delete the reg keys
\SYSTEM\CurrentControlSet\Services\OracleServiceSID etc...

I've found this useful before.

Regards,
Jason. Received on Wed Oct 14 1998 - 06:03:24 CDT