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: EscVector <Junk_at_webthere.com>
Date: 19 Dec 2006 20:20:49 -0800
Message-ID: <1166588449.025552.175630@f1g2000cwa.googlegroups.com>

EscVector wrote:
> Charles Hooper wrote:
> > 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.
>
> In order to even connect to an unmounted instance, the associated
> OracleService must be started. It is a separate process and container
> for the required oracle process/threads to run. It can be started and
> the database can be down. If the service is really hung, the database
> can't be open. It is required to be started prior to connecting.
>
> Make sure the paths for all the dump files and alert logs exist. This
> can cause a "Hang".
>
> I'm only recommending using PSKILL if the service can't be stopped via
> any other means, as seems to be the case here. There is no reason to
> use it otherwise.
>
> If it is hung, it has to be shutdown aborted anyway. There is nothing
> special about the Oracle Service relative to any other service. It is
> simply a container. PSKILL is the best kill tool out there. I would
> not advice using anything else.
>
> What would you recommend doing in this case where the controls are
> "greyed" out?
>
> Also, since this database is newly created, what is the risk?

As I said, if all else fails and if you have metalink you can read this.

Subject: WINNT/WIN2000: Recreating Oracle Services and Instances from the Command Line

  	Doc ID: 	Note:61621.1 	Type: 	BULLETIN
  	Last Revision Date: 	29-DEC-2004 	Status: 	PUBLISHED
Received on Tue Dec 19 2006 - 22:20:49 CST

Original text of this message

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