R12 Get APP-FND-01564 ORA-01116 ORA-01110 ORA-27041

Concurrent Processing - In R12 Get APP-FND-01564 ORA-01116 ORA-01110 ORA-27041 Errors When Running Concurrent Requests [ID 577291.1]

Applies to:

Oracle Application Object Library - Version 12.0.1 to 12.0.4 [Release 12]
Oracle Concurrent Processing - Version 12.0.4 to 12.1.3 [Release 12 to 12.1]
Linux x86
***Checked for relevance 20-Jun-2011***


Symptoms

When running any concurrent requests or request sets in Oracle Applications Release 12, the following error would appear:

APP-FND-01564: ORACLE error -1116 in SUBMIT: others

Cause: SUBMIT: others failed due to ORA-01116: error in opening database file {number}
ORA-01110: data file {number}: '/{directory path}/{file}.dbf'
ORA-27041: unable to open file
Linux Error: 24: Too many open files
Additional information: 3.

The SQL statement being executed at the time of the error was:
&SQLSTMT and was executed from the file &ERRFILE.

Cause

The error would appear if the output of the lsof command is greater than the value of the ulimit. 
Use the following command to check the number of open files used by applmgr:

$ lsof -u applmgr | wc -l

Compare the result to the value in ulimit:

$ ulimit -n

Solution

Modifying the Number of Open File Descriptors

Open the /etc/security/limits.conf file and change the existing values for "hard" and "soft" parameters as follows. Restart the system after making changes.

Note: 
If the current value for any parameter is higher than the value listed in this document, then do not change the value of that parameter.

  * hard nofile 65535
  * soft nofile 4096
  * hard nproc 16384
  * soft nproc 2047

Note:
* means all users listed in /etc/passwd would inherit the above values.