Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database going down with ORA-27301

Girish SunkaraJun 5 2017 — edited Jun 5 2017

The instance is being terminated with ORA-27301: OS failure message: Too many open files in system. Below is a snippet from the log file,

Tried increasing the soft nofile for all users in limits.conf,

* soft nofile 65535

But still after a few days, instance is getting terminated with same error.

Errors in file /u01/PROD/db/tech_st/10.2.0/admin/PROD_gtx-odbsvr/bdump/prod_dbw1_5354.trc:

ORA-27300: OS system dependent operation:open failed with status: 23

ORA-27301: OS failure message: Too many open files in system

ORA-27302: failure occurred at: skgpstime2

ORA-27144: attempt to kill process failed

ORA-01116: error in opening database file 74

ORA-27041: unable to open file

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

Additional information: 3

Sun Jun 4 09:21:48 2017

Errors in file /u01/PROD/db/tech_st/10.2.0/admin/PROD_gtx-odbsvr/bdump/prod_lgwr_5360.trc: