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: Database hangs during shutdown immediate

Re: Database hangs during shutdown immediate

From: Wayne Straughn <Wstraughn_at_hotmail.com>
Date: Sat, 21 Jul 2001 21:27:45 GMT
Message-ID: <tk716k8ncupc8a@corp.supernews.com>

ok, I've heard of this happening, but in my environment I don't use the Intelligent agent.....
Hieraklion <hieraklion_at_spray.fr> wrote in message news:3B43063F.DC07F286_at_spray.fr...
> "Bonjour" from Paris,
>
> This problem can occur when the Intelligent Agent is started and
 recognizes the
> database (two connection). Try to stop the IA before to do a shutdown
 immediate
> in order to test this.
>
> "Au revoir" from Paris
> Hieraklion
>
> Wayne Straughn a écrit :
>
> > I'm running two production Oracle 8.0.6 DBs on a COMPAQ proliant 7000
> > server with NT 4.0 sp3.
> > Ram: 1GB
> > Processors: 2 Pentium II 500 mhz
> >
> > My problem is:
> >
> > I had been performing a cold backup every night and every few days
 (perhaps
> > 3 - 4 times a month one
> > DB would hang during the shutdown immediate process without any entry
 in
> > the alert_log to
> > give a clue as to WHY!
> >
> > To recover from this, I had to either reboot the server or more recently
 I
> > used
> > TLIST to find which Oracel80.exe process corresponds to the crashed
 database
> > and terminate it.
> > Then I can start the database normally...
> >
> > I experimented with using Oradim80 and svrmgr30 in my shutdown process
> > to see if one or the other could be the culprit, but the freeze has
 occurred
> > with both.
> >
> > I tried changing my Temporary Tablespace from type "temporary" and
> > "permanent" to no avail...
> >
> > We were having this problem with Oracle 8.0.5 which was getting obsolete
 so
> > I upgraded to 8.0.6 in hopes it
> > might resolve this problem... it didn't. ( The two applications I
 support
> > are packages which interface with
> > each other and one has not been certified on 8i. The interface uses
 DBLINKS
> > and so I'm forced to maintain
> > the two databases at the same Oracle version.)
> >
> > At one point I decided to try rebooting the NT server once a week, to
> > eliminate any potential memory leaks etc.
> > this also didn't have any impact on the problem...
> >
> > I queried just before shutdown for any active sessions which could be
> > causing the database to wait...
> > but have found none.
> >
> > My Oracle support has not been able to supply a solution besides "reboot
 the
> > server when the problem occurs"
> >
> > At that point, I decided to give up trying for a bit and switch to hot
> > backups during the week...
> >
> > My question:
> >
> > Has anyone else experienced a similar problem to mine? Any idea what
 causes
> > it? How did you resolve it?
> > (Please don't tell me anything about doing shutdown aborts on a regular
> > basis... lol )
>
Received on Sat Jul 21 2001 - 16:27:45 CDT

Original text of this message

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