2013年8月29日木曜日

ORA-00059: maximum number of DB_FILES exceeded

This parameter is in the CONTROL FILE,but you do not need to recreate control file. See below:

$sqlplus /nolog
conn / as sysdba

SQL> show parameter db_files;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_files                             integer     200

SQL> alter system set db_files=250 scope=spfile;
System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  268435456 bytes
Fixed Size                  1218892 bytes
Variable Size              75499188 bytes
Database Buffers          188743680 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.

SQL>show parameter db_files
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_files                             integer     250
SQL> exit

0 件のコメント :

コメントを投稿