We faced an issue during Request Set run of DBI Initial load .
Current setup :
Database :10.2.0.3
Application : 12.0.4
OS : Redhat Advanced server 5 (Tikanga)
Error:
APP-FND-01564: ORACLE error - 1116 in SUBMIT: others
Cause: SUBMIT: others failed due to ORA-01116: error in opening database file 13
ORA-01110: data file 13: '
ORA-27041: unable to open file
SVR4 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 :
Refer metalink Note-id :397119.1 for more details
Solution :
(before proceeding with the solution , we should always check for the following parameter at OS level)
cat /etc/security/limits.conf
* hard nofile 65535
* soft nofile 4096
* hard nproc 16384
* soft nproc 2047
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
If you do not have these parameters required values ; then make the changes accordingly ; followed by server bounce.
1) Apply the opatch 5257698 on to ur Application database. [Make sure all your Application/Database services are down]
2) cd $ORACLE_HOME/nls/data/old
3) perl cr9idata.pl [This will recreate the *.nlb file in $ORACLE_HOME/nls/data] Set the environment as mentioned.
4) Start your database and applications services.
5) Retest your issue.
Happy Reading !! :)
