How to Fix ora 1116 ora 1110 and ORA-27092 Errors in oracle database

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 inf

Check 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) unlimited
 
 
 

References/Related:-

Intermittent ORA-1116, ORA-1110 and ORA-27092 Errors

Leave a Comment