RE: How to change the value of MAXDATAFILES of a running instance

From: ALEMU Abiy <abiy.alemu_at_criltechnology.com>
Date: Wed, 31 May 2000 14:29:52 +0200
Message-Id: <10514.107262@fatcity.com>

I have to recreate the control file but even by editing the generated = file
and modifying the necessary things, it doesn't work. I think that I've = to
do something else too. I don't know what !!!!

-----Message d'origine-----
De: Stephen J Palmer [mailto:spalmer_at_brk.photronics.com] Date: mardi 30 mai 2000 22:14
=C0: Multiple recipients of list ORACLE-L Objet: Re: How to change the value of MAXDATAFILES of a running = instance
?

This may not be my place.... but can't you just make the change in the init.ora
file
and bounce the instance. I don't believe you have to recreate the controlfile...
but
I believe you will have to bounce the instance to have the new setting = take
effect.?

Please let me know if this is not correct.

Thanks
Steve

Steve Boyd wrote:

> I'm surprised that nobody else has answered this one yet, so I'll go =
ahead
> and post.
>
> You need to recreate the controlfile. Do the good old ALTER DATABASE
BACKUP
> CONTROLFILE TO TRACE;
>
> Up the parameter in the script this generates, and recreate the
controlfile.
> Of course, you will need to take down your database to do this.
>
> >From: ALEMU Abiy <abiy.alemu_at_criltechnology.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: How to change the value of MAXDATAFILES of a running =
instance ?
> >Date: Tue, 30 May 2000 07:56:04 -0800
> >
> >Is there somebody who knows how to change the MAXDATAFILES parameter
value
> >of a running database ? If so, I'm really very grateful to anyone =
who
can
> >explain me.
> >
> >Thank you friends !!!
> >--
> >Author: ALEMU Abiy
> > INET: abiy.alemu_at_criltechnology.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing =
Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
> =

________________________________________________________________________=

> Get Your Private, Free E-mail from MSN Hotmail at =
http://www.hotmail.com
>
> --
> Author: Steve Boyd
> INET: pimaco_oracle_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing =
Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

Stephen Palmer
Junior Database Administrator
Photronics Inc.
15 Secor Road
Brookfield, Conn.
203.740.5331
Pager 203-830-0306 or 1-800-706-7109
mailto:spalmer_at_brk.photronics.com
Home Number 203.270.8159
Alpha Pager mailto:spalmer.pager_at_brk.photronics.com

--=20
Author: Stephen J Palmer
  INET: spalmer_at_brk.photronics.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Wed May 31 2000 - 07:29:52 CDT