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: Hang when adding/resizing datafile

Re: Hang when adding/resizing datafile

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 18 Aug 2004 08:08:32 -0700
Message-ID: <1092841760.841792@yasure>


miam wrote:

> Hello
>
> I have a problem with Oracle 8i 8.1.6 on Linux Redhat 8.0 when I use :
> alter tablespace ... add datafile '...' size 2000M;
> Or :
> alter tablespace ... add datafile '...' size 100M; (works well)
> then :
> alter database datafile '...' resize 2000M;
>
> In this 2 cases, I have no error, but the statement doesn't return
> control.
> The oracle process on the server takes more and more cpu time, but the
> hdd does nothing and the file has its required size on the disk.
> I can't kill the process (I have tried kill -15, kill -9, and every
> signal)
> The only way : I must reboot the server
>
> But when I restart the server and the database,
> If I was adding the datafile, it is not mounted.
> If I was resizing the datafile, it is not resized.
>
> I have this problem on 2 different machines of my customers
>
> What is this ?
> And Oracle bug ? A Linux bug ?
> I have not find it on internet :((
>
> Thanks for your answers...

I've no idea ... but why would you be in Oracle 8.1.6, unsupported, and one of the buggiest versions of the database ever sold, after the release of so many newer and better versions? Upgrades are free ... upgrade!

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Wed Aug 18 2004 - 10:08:32 CDT

Original text of this message

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