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: Type of shutdown

Re: Type of shutdown

From: <marjina98_at_hotmail.com>
Date: 25 Aug 2004 22:07:27 -0700
Message-ID: <24bfee06.0408252107.1fa8207@posting.google.com>


Hi Howard,

Could you please explain this little bit more (My WIndows 2000 was not clean or ORacle Patch may cause the registry setting failure? I believe I set the right values to the concerned registry keys but still no affect take place as I discussed earlier.

Thanks

MArjina

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<4128f930$0$10347$afc38c87_at_news.optusnet.com.au>...
> marjina98_at_hotmail.com wrote:
>
> > Hi,
> >
> > It has been nearly four days since I posted me last quetion.
> > Could someone from this forum should give me the
> >
> > the solution?
>
> > marjina98_at_hotmail.com wrote in message
> >> Hi Howard,
> >>
> >> As you mentioned, I set the values in the following registries:
> >>
> >> ORA_SID_SHUTDOWN_TIMEOUT=5
> >> ORA_SID_SHUTDOWNTYPE=n
> >> ORA_SID_SHUTDOWN=true
> >>
> >> And then reboot the machine and then Log in a user to the database,
> >> and leave him logged in. Then stop the service. This process
> >> immediately stops the service and disconnected the user.
> >> So in other words shutdown abort occurred again.
> >> There is only one instance running on machine.
> >> I am using version 8.1.7.0 on Windows 2000 server.
> >>
> >> Regarding the ORA_SID_SHUTDOWN_TIMEOUT registry I tried to set several
> >> values like 5 then 20, then 30, then 100.
> >> Each time after setting the values to this registry, I reboot my
> >> machine, but the result was same every time, as I discussed above.
>
> Having tested it, and gotten the results I posted earlier (that with
> SHUTDOWN_TYPE=n and _TIMEOUT=5, and an ordinary database user logged in, I
> was unable to shutdown the service *at all* -meaning that the TYPE was
> being honoured, but the TIMEOUT wasn't), I can't comment further.
>
> There are too many unknowns. How do I know you're editing the right registry
> keys? There are many hives you could be in. You're running an unpatched
> version of 8i (I was running 8.1.7.3). My Windows 2000 was clean and
> fresh... yours might not be. And so on.
>
> You've also had an answer from another quarter if I remember correctly,
> which solves the problem completely, though you might not like it: don't
> try and close down your databases by starting and stopping services. Use
> SQL*Plus and startup/shutdown commands. Or use oradim to do the job.
>
> Regards
> HJR
Received on Thu Aug 26 2004 - 00:07:27 CDT

Original text of this message

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