Re: Urgent. Max Datafiles exceed. Please Help.

hello
you must do that:
svrmgrl
>connect internal
>alter database backup controlfile to trace;
>shutdown immediate;
>exit;

modify the file generated before (in directory <udump>) maxdatafiles
after that
rm or rename your controlfiles

svrmgrl
>connect internal
>startup nomount pfile=.......
>@your file modified
>alter database open;
>exit;

good luck

<markp7832_at_my-deja.com> a écrit dans le message : 83arcj$u26$1_at_nnrp1.deja.com...
> In article <83ap90$se5$1_at_nnrp1.deja.com>,
> alan_psb_at_yahoo.com wrote:
> >
> >
> > I want to add tablespace (Oracle 7.3.3, Solaris 2.5). However, I got
> the
> > following error:
> >
> > ORA-01118: cannot add any more datafiles, limit of 30 exceed.
> >
> > Then I change the db_files from 30 to 100 in initORACLE.sql. However,
> > after shutdown and restart the database, I still got the above message
> > when I add tablespace. But the db_files has changed to 100 when I show
> > parameter in SVRMGR. I then ask my friend and he told me that I need
> to
> > recreate the control files. However, he don't know how to do that.
> Could
> > anyone tells me how can I recreate the control file such that I can
> add
> > more datafile to Oracle? Could anyone shows the steps of doing this?
> >
> > Thanks,
> > Alan
> >
> The procedure to recreate the control file is in the DBA Administration
> manual. You will want to read it and follow it rather than a post. In
> the ver 8 manual it is ch 6 topic New Control Files. There is a 9 item
> list to follow. Also look in the SQL manual at the 'create controlfile
> command' and the alter database backup control to trace command'. You
> will want to make a copy of your control file using the trace option so
> you do not have to type everything by hand when creating your create
> controlfile script.
>
> Good luck.
> --
> Mark D. Powell -- The only advice that counts is the advice that
> you follow so follow your own advice --
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Dec 17 1999 - 17:44:50 CST