Re: Service doesn't start the database

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 01 Aug 2005 08:57:34 -0700
Message-ID: <1122911836.280250@yasure>

fitzjarrell_at_cox.net wrote:
> DA Morgan wrote:
>

>>fitzjarrell_at_cox.net wrote:
>>
>>>DA Morgan wrote:
>>>
>>>
>>>>fitzjarrell_at_cox.net wrote:
>>>>
>>>>
>>>>>DA Morgan wrote:
>>>>>
>>>>>
>>>>>
>>>>>>astalavista wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>>Hi,
>>>>>>>
>>>>>>>After upgrading 8.1.7  to 9.2.0.5
>>>>>>>the service doesn't start the database.
>>>>>>>The register is OK
>>>>>>>
>>>>>>>Can you help me ???
>>>>>>>
>>>>>>>Thanks in advance
>>>>>>>
>>>>>>>Windows 2000 SP4
>>>>>>>Oracle 9.2.0.5
>>>>>>
>>>>>>Use oradim (oradim.exe) to drop the Oracle service and recreate it.
>>>>>>--
>>>>>>Daniel A. Morgan
>>>>>>http://www.psoug.org
>>>>>>damorgan_at_x.washington.edu
>>>>>>(replace x with u to respond)
>>>>>
>>>>>
>>>>>Such advice is quite severe,
>>>>>
>>>>>David Fitzjarrell
>>>>
>>>>But effective. And best of all ... can't damage the data if they
>>>>make a mistake: Just delay getting it working again.
>>>>--
>>>>Daniel A. Morgan
>>>>http://www.psoug.org
>>>>damorgan_at_x.washington.edu
>>>>(replace x with u to respond)
>>>
>>>
>>>Yet my reponse does not require a reboot to clear the service entry;
>>>yours does.  Which would the OP rather experience: correcting the
>>>existing service without a reboot or dropping and recreating a service
>>>requiring one?  I know which option I'd choose.
>>>
>>>
>>>David Fitzjarrell
>>
>>I'd use oradim ... but perhaps only because I find Windows so flaky that
>>I have given up on anything less drastic.
>>--
>>Daniel A. Morgan
>>http://www.psoug.org
>>damorgan_at_x.washington.edu
>>(replace x with u to respond)

>
>
> Funny, so would I, but not in the fashion you suggest. Please read my
> post again, as it clearly uses oradim to MODIFY the existing service
> rather than replace it (I've emphasized the references to oradim.exe:
>
> "Such advice is quite severe, as the service can be modified with
> *oradim.exe* to autostart both the service and the instance using the
> starttype=srvc,inst parameter:
>
> *oradim -startup sid=<sid> starttype=srvc,inst ...*
>
> Please consult the oradim help by issuing the oradim command at the
> prompt; a full list of available options will be presented, with the
> correct syntax. I am a bit rusty on my Windows Oracle admin as it's
> been several years since I've worked in that environment."
>
> Now, what was this about you using oradim and I not?
>
>
> David Fitzjarrell

It was about not having access to your original post. But still ...

oradim -delete
oradim -new

vs

oradim -startup

Not sure I see a difference worth this such effort on either of our parts.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Mon Aug 01 2005 - 10:57:34 CDT