ORA-1116, ORA-1110 and ORA-27092 Errors in oracle database

In alert log file below error are reported.

ERROR:- 

Enter Password:

REP-1401: 'cf_policyformula': Fatal PL/SQL error occurred.

ORA-01116: error in opening database file 95

ORA-01110: data file 95: '/data03/db/apps_st/data/a_txn_data47.dbf'

ORA-27041: unable to open file

Linux-x86_64 Error: 23: Too many open files in system

Additional information: 3

REP-0069: Internal error

REP-57054: In-process job terminated:Terminated with error: 

REP-1401: 'cf_policyformula': Fatal PL/SQL error occurred.

ORA-01116: error in opening database file 95

ORA-01110: data file 95: '/data03/db/apps_st/data/a_txn_data47.dbf'

ORA-27041: unable to open file

Linux-x86_64 Error: 23: Too many open files in system

Additional information: 3

ORA-01122: database file 154 failed verification check
ORA-01110: data file 154: '/data05/db/apps_st/data/a_queue07.dbf'
ORA-01565: error in identifying file '/data05/db/apps_st/data/a_queue07.dbf'
ORA-27041: unable to open file
Linux-x86_64 Error: 23: Too many open files in system
Additional inf

 ulimit -Sa

core file size          (blocks, -c) 0

data seg size           (kbytes, -d) unlimited

scheduling priority             (-e) 0

file size               (blocks, -f) unlimited

pending signals                 (-i) 1031260

max locked memory       (kbytes, -l) 125829120

max memory size         (kbytes, -m) unlimited

open files                      (-n) 4024

pipe size            (512 bytes, -p) 8

POSIX message queues     (bytes, -q) 819200

real-time priority              (-r) 0

stack size              (kbytes, -s) 1024

cpu time               (seconds, -t) unlimited

max user processes              (-u) 16384

virtual memory          (kbytes, -v) unlimited

file locks                      (-x) unlimited

Increase the user resource limits for the Unix user that owns the third party application

To do this, use the ulimit command

For example, to set the soft 'data' and 'stack' limits to unlimited use the commands:

% ulimit -d unlimited

% ulimit -s unlimited

To set the hard 'data' and 'stack' limits to unlimited use the commands:

% ulimit -Hd unlimited

% ulimit -Hs unlimited

To set permanently at user level .

$vi /etc/security/limits.conf

# oracle-rdbms-server-11gR2-preinstall setting for stack soft limit

oracle   soft   stack    unlimited

# oracle-rdbms-server-11gR2-preinstall setting for stack hard limit

oracle   hard   stack    unlimited

$sysctl -p

Finally verify the value.

 ulimit -Sa

core file size          (blocks, -c) 0

data seg size           (kbytes, -d) unlimited

scheduling priority             (-e) 0

file size               (blocks, -f) unlimited

pending signals                 (-i) 1031260

max locked memory       (kbytes, -l) 125829120

max memory size         (kbytes, -m) unlimited

open files                      (-n) 4024

pipe size            (512 bytes, -p) 8

POSIX message queues     (bytes, -q) 819200

real-time priority              (-r) 0

stack size              (kbytes, -s) unlimited

cpu time               (seconds, -t) unlimited

max user processes              (-u) 16384

virtual memory          (kbytes, -v) unlimited

file locks                      (-x) unlimited