Re: Problem when WIndows 2000 Server is rebooted

From: joel garry <joel-garry_at_home.com>
Date: 15 Aug 2006 15:45:58 -0700
Message-ID: <1155681958.622231.162900@m79g2000cwm.googlegroups.com>

Chuck Whealton wrote:
> dbaplusplus_at_hotmail.com wrote:
> > DA Morgan wrote:
> > > dbaplusplus_at_hotmail.com wrote:
> > > > I am running Oracle 10.1.0.3 on Windows 2000 server. I have a few
> > > > database instances. I have noticed that when Windows server is
> > > > rebooted, once in a while (every 3 month or so). a database instance
> > > > will not start properly. There are no error messages in alert.log file,
> > > > however when one connects to database instance, it gives some error
> > > > message.
> > > >
> > > > As I stated problem happens only once in a while and it is also not
> > > > tied to a specific database instance (I have 3 instances). Has anyone
> > > > seen similar problem and knows how to fix it in Windows 2000
> > > > environment (I cannot move to UNIX, LINUX ...).
> > > >
> > > > Thanks.
> > >
> > > Good advice from Sybrand and Chuck.
> > >
> > > But 10.1.0.3? Why? There is a patch to 10.1.0.4 that should be applied.
> > > And as Sybrand points out: "some error message" is far from useful
> > > information.
> > > --
> > > Daniel A. Morgan
> > > University of Washington
> > > damorgan_at_x.washington.edu
> > > (replace x with u to respond)
> > > Puget Sound Oracle Users Group
> > > www.psoug.org
> >
> > 1. Reason I cold not provide the error message is because no error
> > message was written to alert.log file, so I could not emember the exact
> > error message. Message probably was "databse recovery is in
> > porgress....", but then I just shutdown the service and then restarted
> > the service and instance started fine.
> >
> > 2. I cannot move to 10.1.0.4 because third party application was
> > certfied only with 10.1.0.3.
> >
> > 3. I am not using ASM.

> Alright, even though I kind of doubt this is your problem, if your
> database is coming up requiring recovery that is somehow interfering
> with it's startup (I'm surmising because I haven't had this particular
> problem), perhaps it's not going down cleanly. Maybe you should check
> some of your Windows registry settings. In particular, I'd look at
> this URL:
> http://www.databasejournal.com/features/oracle/article.php/3373301

> There are a couple Oracle registry entries in particular called
> ORA_SID_AUTOSTART, ORA_SID_SHUTDOWN, ORA_SID_SHUTDOWNTYPE and
> ORA_SID_SHUTDOWN_TIMEOUT that you may want to pay attention to.

> Remember that both Microsoft and Oracle advise you NOT to edit the
> registry. You may be able to use the ORADIM utility (I assume it's
> also in 10g) to make any changes you might need, but hopefully somebody
> will correct me if I'm wrong.

> Good luck...

> Charles R. Whealton
> Charles Whealton @ pleasedontspam.com

You (dbaplusplus) should poke around on metalink and find where they describe how to shutdown with scripts rather than the registry entries (if you don't already know how to do such things). There is simply no way to get the timing right and shutdown within a predictable time with the registry entries. Beyond everything else, you may be waiting for some transactional rollback.

"the dll security.dll is unregistered before the 'net stop' command is given time to execute properly. Oracle has no control
over the algorithm used by Microsoft when Windows is shutdown and thus cannot
force adherence to the values of registry parameter 'ORA_SID_SHUTDOWN' and by
extension 'ORA_SID_SHUTDOWNTYPE'at Windows shutdown time."

Hopefully someone will correct me and point to the evidence if Microsoft has fixed that.

--
@home.com is bogus.
"1.  A robot will not harm authorized Government personnel but will
terminate intruders with extreme prejudice.
2.  A robot will obey the orders of authorized personnel except where
such orders conflict with the Third Law.
3.  A robot will guard its own existence with lethal antipersonnel
weaponry, because a robot is bloody expensive. " -  David Langford

Received on Tue Aug 15 2006 - 17:45:58 CDT