Wednesday, September 9, 2015

ORA-00059: maximum number of DB_FILES exceeded

Problem
[oracle@PTUD-SingleSignOn oradata]$ oerr ora 59
00059, 00000, "maximum number of DB_FILES exceeded"
// *Cause:  The value of the DB_FILES initialization parameter was exceeded.
// *Action: Increase the value of the DB_FILES parameter and warm start.
Solution:
[oracle@PTUD-SingleSignOn oradata]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Wed Sep 9 10:54:48 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

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

System altered.

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

Total System Global Area 2488635392 bytes
Fixed Size    2291424 bytes
Variable Size  671090976 bytes
Database Buffers 1795162112 bytes
Redo Buffers   20090880 bytes
Database mounted.
Database opened.
SQL> show parameter db_files;

NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
db_files     integer 256
SQL> 

Share this

0 Comment to "ORA-00059: maximum number of DB_FILES exceeded"

Post a Comment