ORA-00059: maximum number of DB_FILES exceeded
Answers were Sorted based on User's Feedback
Answer / guest
Cause: The value of the DB_FILES initialization parameter
was exceeded.
Action: Increase the value of the DB_FILES parameter and
warm start.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / prasant
When u are facing this type of error,as a DBA point of view
step-1:Show parameter db_files;
Step-2:U can increase the db_files size by executing
alter system set db_files=750 scope=spfile;
step-3:shutdown immediate;
step-4:start up;
As simple U can now crate tablespace.
byeee
| Is This Answer Correct ? | 3 Yes | 2 No |
ORA-02809: Jump buffer not valid
TNS-04013: CMCTL timed out waiting for Oracle Connection Manager to start
QSM-02080: mv log must have primary key
ORA-16785: The database is not in ARCHIVELOG mode
ORA-07495: spwat: lm_wait failed.
RMAN-08042: channel string: copied standby controlfile
ORA-07392: sftcls: fclose error, unable to close text file.
ORA-06137: NETTCP: error during connection handshake
ORA-26036: subpartition load specified but table string is not subpartitioned
ORA-09362: Windows 3.1 Two-Task driver unable to deallocate context area
PLS-00315: Implementation restriction: unsupported table index type
ORA-09754: sppst: invalid process number passed to sppst.