Re: Service doesn't start the database

From: <fitzjarrell_at_cox.net>
Date: 1 Aug 2005 06:41:43 -0700
Message-ID: <1122903703.292029.242990@g14g2000cwa.googlegroups.com>

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 Received on Mon Aug 01 2005 - 08:41:43 CDT