Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> # Solaris file descriptors
Oracle 8.1.6 / Solaris 2.6
We initially created a database with 1044 tablespaces and didn't receive any error messages. I had a problem with a file system and had to rebuild several tablespaces and that is when I started receiving the following errors.
ORA-01119: error in creating database file '/a1069/bsw.test' ORA-27040: skgfrcre: create error, unable to create file SVR4 Error: 13: Permission denied
The docs say to up the ulimit for file descriptors and I can not figure out for the life of me how to get this above 1024 and keep it there. Sun support said 1024 is the max hard limit but I'd like to hear that from someone on the list who is familiar with this since there doesn't seem to be a lot of confidence in Sun support. If you've figured this out the exact command and shell you ran the command from would be much appreciated.
I offlined some other tablespaces and created the missing ones and then onlined the other tablespaces and everything appears to be working fine. Does anyone know how Oracle is managing the underlying datafiles if it can only keep 1024 of 1044 datafiles open at one time? Is there any performance issues I should be concerned about? I can see 1023 files open for this instance but I haven't figured out the pfiles display yet to figure out exactly which files it has open and which ones are closed.
Any input would be appreciated.
![]() |
![]() |