修改ORACLE DB_FILES

确认DB_FILES数量

SQL> show parameter db_files;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_files                             integer     200

检查是否由SPFILE或PFILE启动

SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> show parameter pfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string

由于不是由SPFILE或PFILE启动，那必定是由INIT启动

这里必须先建立SPFILE

SQL>  create spfile from pfile;

File created.

关闭数据库后重起

SQL> shutdown
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.

Total System Global Area 3.4206E+10 bytes
Fixed Size                  2270360 bytes
Variable Size            3825208168 bytes
Database Buffers         3.0333E+10 bytes
Redo Buffers               45649920 bytes

检查启动参数，这时候看到有SPFILE了，那就可以进行修改了

SQL> show parameter pfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/oracle/product/11.2.0/dbh
                                                 ome_1/dbs/spfilesqmesdb.ora

修改DB_FILES

SQL>  alter system set db_files=1024 scope=spfile;

System altered.

关闭数据库后重起

SQL> shutdown
ORA-01507: database not mounted


ORACLE instance shut down.
SQL>  startup nomount
ORACLE instance started.

Total System Global Area 3.4206E+10 bytes
Fixed Size                  2270360 bytes
Variable Size            3825208168 bytes
Database Buffers         3.0333E+10 bytes
Redo Buffers               45649920 bytes

检查参数

SQL> show parameter db_files;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_files                             integer     1024

 

完成！