ORA-02789: Maximum number of files reached



ORA-02789: Maximum number of files reached..

Answer / guest

Cause: The maximum number of files that can be used for
asynchronous I/O has been reached.

Action: Shut down the servers and re-initialize the package
with a higher number.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06192: maximum value for MAXPIECESIZE or MAXSETSIZE must be between 1 Kb and 2048 Gb

1 Answers  


ORA-29665: Java thread deadlock detected

1 Answers  


how to resolve the sqlcode -501 erroe in db2?

2 Answers   Syntel,


QSM-01565: equivalence, string, cannot compute measure, string, in the query

1 Answers  


ORA-00063: maximum number of LOG_FILES exceeded

1 Answers  






ORA-01754: a table may contain only one column of type LONG

1 Answers  


ORA-14078: you may not drop the highest partition of a GLOBAL index

1 Answers  


ORA-22290: operation would exceed the maximum number of opened files or LOBs

1 Answers  


ORA-14009: partition bound may not be specified for a LOCAL index partition

1 Answers  


ORA-08232: smsdes: cannot detach from SGA

1 Answers  


DRG-11123: theme indexing is not supported

1 Answers  


ORA-25534: _MEAN_TIME_TO_CLUSTER_AVAILABILITY is specified

1 Answers  


Categories