-
Hello,
I created a 8.1.7 database and added 250 new tablespaces. at one point i got ora-00059- maximum DB_FILES exceeded.
I increased the db_files parameter and i again started the database, got the same error, it did not mount.
i tried to alter database backup controlfile to trace to edit the file, but database is not mounted ora 01507
what to do now?
how to proceed?
thanks
-
startup mount
alter database backup controlfile to trace
-
I tried that : alter database backup controlfile to trace, but i get that error that database is not mounted.
if i try startup mount : i get 00059: maximum DB_FILES exceeded.
so, what should i do ? delete the database and recreate all over again ?
-
well from 8i if you increase db_files your controlfile would accommodate more datafiles based on db_files parameter so I dont see why you are getting problems?
-
db_files=500, i increased db_files=800 in the init.ora, then the problems started, i went back to 500, still that exists.
so, what is that i have to do now?
-
Are you absolutely sure you are editing the correct init.ora file? Try STARTUP MOUNT with PFILE=the_file_you_have_edited option.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
also are you sure you have less than 800 files...?
-
yes, i am sure i am editing the correct file and also am sure it has less than 800 files.
i will try to startup mount with pfile=edited_file option and see what happens.
thanks
-
-
i could mount with startup mount with pfile=edited_file option ,
also i changed the maxdatafiles in the trace file.
now,how to proceed?
do i have to delete all the controlfiles,log files etc, and then recreate the database again?
or just run the edited trace file ?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|