Tuesday, October 28, 2008

ORA-00059: maximum number of DB_FILES exceeded

You do not need to recreate control file. See below:

SQL> sho user
SYS
SQL> select * from v$version;

BANNER
\----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
PL/SQL Release 10.2.0.2.0 - Production
CORE 10.2.0.2.0 Production
TNS for 32-bit Windows: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production

SQL> sho parameter db_files

NAME TYPE VALUE
\------------------------------------ ----------- \------------------------------
db_files integer 200
SQL> alter system set db_files = 256 scope = spfile;

SQL> shutdown immediate
SQL> startup
SQL> sho parameter db_files

NAME TYPE VALUE
\------------------------------------ ----------- \------------------------------
db_files integer 256

No comments: