| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: How to change the value of MAXDATAFILES of a running
Well, this has become one very interesting thread. OK, Now that I've got a
couple of terms in my head straight, my apologies to others on the list I did
confuse MAXDATAFILES with DB_FILES.
The init.ora parameter DB_FILES sets the number of datafiles that the database can have at a particular run instance. If you change it you need to bounce the database for the new value to take effect. It can be just about any value allowed by your OS from 1 on upwards. It may also exceed the control file parameter MAXDATAFILES. Doing so is harmless, until you try to add that one additional file above MAXDATAFILES. Then you'll get an error that you have exceeded MAXDATAFILES.
To change MAXDATAFILES requires a rebuild of the control file since it's going to get bigger. This can be done either with the 'create controlfile' command or by rebuilding the database from scratch.
One point to remember though, some OS's like HP-UX have a 'max files per user' or 'max files per process' parameter. In this case MAXDATAFILES and/or DB_FILES may exceed this setting without trouble, until you add that one additional file above & beyond the OS limit.
____________________Reply Separator____________________Subject: RE: How to change the value of MAXDATAFILES of a running ins Author: ALEMU Abiy <abiy.alemu_at_criltechnology.com> Date: 5/31/00 5:42 AM
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
A: 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
-- 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 also send the HELP command for other information (like subscribing). -- 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-LReceived on Wed May 31 2000 - 10:00:08 CDT
 |
 |