Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle service always at starting mode

Re: oracle service always at starting mode

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 19 Dec 2006 16:57:55 -0800
Message-ID: <1166576275.750499.228560@f1g2000cwa.googlegroups.com>


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 believe that 8i, including 8.1.7, on Windows will perform a shutdown abort by default if the service is shut down, as would be the case when the system is restarted. Oracle could be trying to recover from the shutdown abort. This behavior is detailed in one of the Oracle 8i manuals that is specific to the Windows platform. The fix involves changing a registry key.

Paraphrased from the Oracle 8i Administrator's Guide for Windows NT: To enable automatic shutdown of the Oracle service when the server is shut down, set the ORA_SHUTDOWN and ORA_SID_SHUTDOWN registry entries. Set the ORA_SID_SHUTDOWN to 1 to handle the shutdown in immediate mode.

PSKILL, part of the PSTOOLS utilities (recently acquired by Microsoft) can terminate a service or other task that refuses to respond to nice shutdown methods, but I would advise against using it on an Oracle service.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Tue Dec 19 2006 - 18:57:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US