After adding extents online (addonline) client sessions eventually fail to open a connection to the database having exhausted filehandles
Clients are unable to open a connection to the database as all system file handles had been allocatedClient session connection fails with error 43
errno 24: Too many open filesFile handles are exhausted (
ulimit -n)
Database extents were added online:
prostrct addonline.
Database started with
-directio startup parameter which uses Unbuffered Synchronous I/O (O_RDWR|O_DSYNC)
Strace of the client session shows the added extent(s) are opened with two file handles:
open("../dbname_7.d6", O_RDWR) = 29
open("../dbname_7.d6", O_RDWR|O_DSYNC) = 30
Strace of the client session shows older extents are opened with on file handle:
open("../dbname_7.d5", O_RDWR|O_DSYNC) = 28