Re: safe mode workaround

Delete the service associated with the database/instance, and re-create it. Clearly, something has been munged since the service was first created.

The command-line tool to delete and re-create such services is 'oradim'.

At a command prompt, do oradim /? to see the complete syntax. But the eseential commands are going to be along the lines of...

oradim -DELETE -SERVICE xxxx (where xxxx is the actual service name)

and

oradim -NEW -SID xxxx -PFILE <location of init.ora> -STARTMODE auto

Read the syntax carefully before you start, because the above is done from memory and is missing bits, plus the order of the switches can be important.

The SYSTEM tablespace, by the way, must never be allowed to run out of space, and 98% is cutting it fine. Switch on autoextend for it as a matter of urgency. That's an 'alter database datafile 'c:\blah\blah\system01.dbf' autoextend on'. Normally, I wouldn't recommend autoextend for ordinary datafiles, but system isn't ordinary, and isn't going to need to extend much anyway (I hope -there's not supposed to be anything in there that isn't data dictionary stuff, and the dictionary doesn't tend to grow like crazy, on the whole).

Regards
HJR "Tim Bedford" <timbedford_at_hotmail.com> wrote in message news:a411bafb.0304040824.3cfee795_at_posting.google.com...
> Hi Norman,
>
> I just checked the Service properties and they're all set to use the
> local system account.
> have a nice weekend,
>
> Tim
>
> Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote in message
news:<E2F6A70FE45242488C865C3BC1245DA7038377DB_at_lnewton.leeds.lfs.co.uk>...
> > Morning Tim,
> >
> > in which case I'd have a look in control panel | services and check that
> > there is a lisetener and the database service which are both configured
> > to automatic startup.
> >
> > Then, check that both of them run as the local system user (the default)
> > or if another username has been supplied. If a new username is supplied
> > has that user recently changed his/her password ? If so, you'll need to
> > have the services changed to reflect the user's new password.
> >
> > I'm on Win2K here but :
> >
> > listener service for ORCL92 running from OracleHome named 'OraHome92' is
> > called 'OracleOraHome92TNSListener' and the database service is
> > 'OracleServiceORCL92' - your's may differ. Go to properties for both of
> > these, then click the logon tab. If logon is set to 'local system
> > account' then there is a problem somewhere else. If it is set to 'this
> > account' then I suspect the password has been changed :o)
> >
> > HTH
> >
> > Cheers,
> > Norman.
> >
> > -------------------------------------
> > Norman Dunbar
> > Database/Unix administrator
> > Lynx Financial Systems Ltd.
> > mailto:Norman.Dunbar_at_LFS.co.uk
> > Tel: 0113 289 6265
> > Fax: 0113 289 3146
> > URL: http://www.Lynx-FS.com
> > -------------------------------------
> >
> >
> > -----Original Message-----
> > From: timbedford_at_hotmail.com (Tim Bedford)
> > [mailto:timbedford_at_hotmail.com]
> > Posted At: Friday, April 04, 2003 9:29 AM
> > Posted To: server
> > Conversation: safe mode workaround
> > Subject: Re: safe mode workaround
> >
> >
> > Hi Norman,
> >
> > I have received this information about it:
> >
> > "There is no Oracle error on startup, and no alert that something is
> > wrong. From the command line the database starts fine. It's when the
> > computer reboots and the service starts that the database fails to
> > start."
> >
> > By the way its running on NT 4.0.
> > thanks,
> >
> > Tim
Received on Fri Apr 04 2003 - 14:27:46 CST