Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle hangs, no errors
,Kevin Brand <kevin.brandx_at_tel.gte.com> wrote:
Doc ID 118228.1 at MetaLink.
Experienced this problem with an 8.0.5 database. Once machine rebooted was able to start the database without problems. You could be lucky.
Helen
: That's really scary stuff. Finding the last known, good backup could prove
: difficult depending on how far past the critical number of days the machine
: was running and how far back in time the shop holds on to the backups.
: -Kevin
: "Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message
: news:9u0hk4$hi0$1_at_babylon.agtel.net...
:> This one sounds like the problem they may be hitting. As far as I
:> this bug is connected with control file corruption on normal shutdowns of :> the database which was running non-stop more than 248 days or so. Solaris :> has a ticker counting number of seconds since last restart, this ticker
:> and becomes negative and Oracle goes nuts. The workaround was to reboot :> the system once in a while and if it was up more than said amount of time, :> shutdown abort the oracle instance and reboot the system. They also said
:> if controlfile corruption is already in effect, there is no other way to
:> system back than to reinstall and restore from last known good backup. By
:> way, the bug was not platform-specific, it was confirmed on other unixes
:> though time to failure was different for some of them (where ticker
:> hundredths of a second the failure was coming earlier). :> :> Correct me if I am wrong. :> :> -- :> Vladimir Zakharychev (bob_at_dpsp-yes.com)
:> Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet
:> All opinions are mine and do not necessarily go in line with those of my
:> :> :> "Burt Peltier" <burtpelt_at_bellsouth.net> wrote in message :> news:GREM7.49186$q36.3417177_at_e3500-atl2.usenetserver.com... :> > For Solaris, there is a bug that is related to how long the machine has
:> > up. I thought it was going to be fixed in 8.1.7 , but it causes things
:> > hang and usually a reboot is required. I think the number of days
:> > the hang starts is dependent on some Solaris setting and for most
:> > is around 244 days, but could be a lot lower . Doing this from memory...
:> > don't have my work account handy, but the bug is documented in Metalink. :> > :> > Also, sometimes putting sql_trace = true in the init.ora will cause
:> > to give more messages, especially useful during shutdown or startup .
:> > generates trace files for EVERY process , so I wouldn't let users in
:> > doing this . :> > :> > "Sean Leach" <sleachNOSPAM_at_netlojix.comnospam> wrote in message :> > news:20011126.163450.1295166342.813_at_netlojix.comnospam... :> > > Hi, :> > > :> > > Sorry, but here is a very vague trouble description: :> > > :> > > Platform: Sun Solaris 8 (Sparc), latest patch clusters :> > > DB: Oracle 8.1.7.0.0 :> > > :> > > For some reason, the database will just hang, no errors in any of the :> > > alert or trace logs, and sometimes, it will correct itself, and other,
:> > > can do a "shutdown abort" to stop the instance, but all of the child
:> > > processes are still there, and eventually go to a "<defunct>" state, :> > > such that we have to reboot the machine to fix it. :> > > :> > > Sometimes, we can do a SELECT COUNT(*) FROM table1, and it will
:> > > but then a SELECT COUNT(*) FROM table2 will fail. Sounded like a
:> > > lock issue, but not sure... :> > > :> > > Sometimes, we can restart the listener, and that fixes it, other
:> > > it doesn't. :> > > :> > > The db data is mounted on a NetApp, but we ran for over 200 days with
:> > > problems before, and then this problems just suddenly started
:> > > We have disk_async_io set to false, as we had a problem with
:> > > IO before, and that fixed THAT problem, but now we have this no error :> > > hanging. It sucks as I have no where to start looking. Any tips? :> > > :> > > Thanks, :> > > Sean :> > :> > :> > :>Received on Wed Nov 28 2001 - 04:34:22 CST