Oracle Text :: Linux :: "Too many open files"

From: JL <jetlag11235_at_yahoo.com>
Date: 18 Jul 2005 13:29:37 -0700
Message-ID: <1121718576.966558.71800@g44g2000cwa.googlegroups.com>

_ENVIRONMENT_
I am running Oracle 10.1.0.3.0 on a Linux box with a 2.4.27 kernel.

_SUMMARY_
During the "create index" statement for a text index, I encounter a "Too many open files" error. The underlying table has approximately 63,000 documents to be indexed; however, some documents fail immediately due to file permission issues. (This is okay, and leads to entries in ctx_user_index_errors containing "DRG-11609: URL store: unable to open local file specified by file:///Jay/foo.doc".)

I have successfully created the index on several random subsets (approximately 6,000 documents each) of the data set.

I am skeptical that Oracle would try to open all the files simultaneously; however, I am wondering if there may be a bug which prevents files from being closed in a timely way. thanks.

_DETAILS_
The path column of the table to be indexed contains entries of the form "file:///Jay/{path}/{filename}". /Jay is the mount point for a Windows server mounted read-only via smbmount.

_ERROR TEXT_
create index kb_idx01
*
ERROR at line 1:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in dreii0ins_cb
ORA-01116: error in opening database file 5
ORA-01110: data file 5: '/u02/oradata/SDR01/sdr_f02.dbf'
ORA-27041: unable to open file

Linux Error: 24: Too many open files
Additional information: 3
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364

_LINUX INFO_
fruzsina:~# grep nofile /etc/security/limits.conf # - nofile - max number of open files
* soft nofile 1024
* hard nofile 65536
fruzsina:~# ulimit -n
1024
fruzsina:~# cat /proc/sys/fs/file-nr
2791 227 150000
fruzsina:~# cat /proc/sys/fs/inode-nr
52078 10303 Received on Mon Jul 18 2005 - 15:29:37 CDT