Introduction: – In this article, we will discuss how to fix ‘ ORA 1116 ORA 1110 and ORA-27092 Errors in oracle database’. Enter Password: REP-1401: ‘cf_policyformula’: Fatal PL/SQL error occurred. ORA-01116: error in opening database file 95.
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 infCheck the current status of ulimit.
#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) unlimitedReferences/Related:-