Skip to Main Content

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:

ORA-01116: error in opening database file

Sun Jun  4 09:21:48 2017

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

ORA-01116: error in opening database file

Sun Jun  4 09:21:49 2017

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

ORA-01116: error in opening database file

Sun Jun  4 09:21:49 2017

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

ORA-01116: error in opening database file

Sun Jun  4 09:21:50 2017

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

ORA-01116: error in opening database file

Sun Jun  4 09:21:50 2017

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

ORA-01116: error in opening database file

Sun Jun  4 09:21:50 2017

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

ORA-01116: error in opening database file

Sun Jun  4 09:21:51 2017

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

ORA-01116: error in opening database file

Instance terminated by DBW1, pid = 5354

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 3 2017
Added on Jun 5 2017
9 comments
860 views