oracle 更改db files,更改oracle 默认db_files 200（ORA-00059: maximum number of DB_FILES

更改oracle 默认db_files 200(ORA-00059: maximum number of DB_FILES

发布时间：2020-08-10 08:14:45

来源：ITPUB博客

阅读：97

作者：strivechao

ORA-00059: maximum number of DB_FILES exceeded

后查到：

db_files 值设的是 integer 200

RMAN> BACKUP CURRENT CONTROLFILE FORMAT '/home/bak/20150612/cntrl_%s_%p_%t';

RMAN> BACKUP Spfile FORMAT '/home/bak/20150612/spfile_%s_%p_%t';

cat /home/db/oracle10g/product/10.2.0/db_1/network/admin/listener.ora

由于要重启库生效，故先停监听：

lsnrctl stop LISTENER1

netstat -an|grep 11521

SQL> show parameter db_files;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_files integer 200

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

System altered.

SQL> show parameter db_files;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_files integer 200

SQL>

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 6815744000 bytes

Fixed Size 2133456 bytes

Variable Size 3812622896 bytes

Database Buffers 2990538752 bytes

Redo Buffers 10448896 bytes

Database mounted.

Database opened.

SQL>

SQL> show parameter db_files;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_files integer 1024

lsnrctl start LISTENER1起监听 恢复

===========

花絮期间在停库时，观察alert日志：

Stopping background process MMNL

Fri Jun 12 19:15:12 2015

Stopping background process MMON

Fri Jun 12 19:15:13 2015

Shutting down instance (immediate)

License high water mark = 141

Fri Jun 12 19:15:13 2015

Stopping Job queue slave processes, flags = 7

Fri Jun 12 19:15:13 2015

Job queue slave processes stopped

Fri Jun 12 19:20:12 2015

Active call for process 11403540 user 'oracle10g' program

'oracle@XXDB3300'

SHUTDOWN: waiting for active calls to complete.

等了许久于是

ps -ef|grep 11403540

oracle10 11403540 1 100 Mar 18 - 78207:11 oracleecssdb (LOCAL=NO)

kill -9 11403540

后续数据库正常停下来