Re: oracle service always at starting mode

Vladimir M. Zakharychev wrote:
> skyloon wrote:
> > hi,
> > I've created database in oracle 8i, after created database, the service
> > was started, after i restart the pc, the status for this service is
> > always Starting, it cant start and stop. Is there any setting need to
> > be done?
>
> Isn't this 8i at version 8.1.6 by any chance? I've seen this behavior
> of 8.1.6.0 on Windows 2000 and later, not sure if there's any fix for
> it in 8.1.6.3, but worth trying. The patchset is still available on
> MetaLink. 8.1.7 doesn't exhibit this bevavior afaik. For now, your only
> option seems to be shutting the db down from svrmgrl or sqlplus before
> restarting or shutting down the OS to make sure the database is
> properly closed and dismounted. If you absolutely have to run 8i,
> consider upgrading to 8.1.7.4 at your earliest convenience, otherwise
> skip a couple of releases and go with 10g R2 (10.2).
>
> Hth,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com

I agree, I think you have the service bug.

If all else fails, download the sysinternals tool pskill and kill the service if necessary.
http://www.microsoft.com/technet/sysinternals/default.mspx

Then run oradim to delete and recreate the service. This has no affect on the db.

If all is well, your new service is will run. If not, you probably should upgrade to 8.1.7.4.

There could be a path or registry error if it is not a bug. If you can't oradim -delete the service, you'll have delete it out of the registry or user one of the service pack tools to remove it. The downside to hacking it out is that the machine will have to be restarted for the LEGACY registry entries to go away. Received on Tue Dec 19 2006 - 08:52:59 CST