Oracle DBA, How To, Error, Cause and Action

ORA-02789: Maximum number of files reached

ORA-02789: Maximum number of files reached




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.