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.
[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>
[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>
0 Comment to "ORA-00059: maximum number of DB_FILES exceeded"
Post a Comment