Re: Newbie question: Installing SP5 on oracle server machine

I would definitely do a shutdown normal or shutdown immediate of the database first, and then you can either go into the control panel and stop the services, or you can issue the 'net stop <servicename>' command.

And like the others said, set the services to manual instead of automatic, so they don't try and start when the machine reboots. You can set them back to automatic after the service pack is applied and you are happy with everything.

As always, a cold backup beforehand and/or a full export is always a good idea.

good luck.

Scott

"Sybrand Bakker" <postmaster_at_sybrandb.demon.nl> wrote in message news:946328993.12909.0.pluto.d4ee154e_at_news.demon.nl...
> Which (the reboot) makes it necessary to make sure the Oracle service is
> started manual instead of automatic.
> BTW svrmgr<xx> (for 80 svrmgr30) doesn't stop the service.
>
> Cheers,
>
> --
> Sybrand Bakker, Oracle DBA
> GC <johnny_sanga_at_hotmail.com> wrote in message
> news:3867D559.85A22562_at_hotmail.com...
> > Just a quick addendum, if you shutdown the database with the
> > Services/Stop option, make sure you have the string 'ORA_SHUTDOWN =
> > TRUE' in your NT registry under HKEY_LOCAL_MACHINE/Software/Oracle.
> > Otherwise, it will crash the database.
> >
> > And you should shut the database down, as you will have to reboot NT
> > after applying the service pack.
> >
> > Cheers,
> > GC
> >
> > Andreas Michler wrote:
> > >
> > > start servermanager (svrmgr23) and :
> > >
> > > connect internal/INTERNALPASSWORT
> > > shutdown immediate
> > >
> > > or Stop the services. in the Control Panel -> Services.
> > >
> > > Olaf Lange wrote:
> > >
> > > > Dear Oracle experts,
> > > >
> > > > we are running oracle 7.3.4.0 on a nt server. Do You recommend
> shutting down the
> > > > oracle engine (running as a service) before installing SP5? And if
> yes, how do
> > > > you shut down the engine (running as a service)?
> > > >
>
>
>
Received on Tue Dec 28 1999 - 14:28:52 CST