ORA-27050 ORA-27077问题的处理

        客户的数据库是Oracle RAC Database 10.2.0.3 for Linux x86_64bit，其中一个实例的告警日志收到大量类似如下的告警日志：

ORA-07445: exception encountered: core dump [opidsa()+386] 

Errors in file /orahome/oracle/admin/PHAM/bdump/pham2_diag_13962.trc: 

ORA-27050: function called with invalid FIB/IOV structure 

Additional information: 2 

ORA-27077: too many files open 

METALINK有文章详细说明了问题的原因：

ORA-07445 opidsa() Followed By ORA-27050 And ORA-27077 [ID 788498.1]
修改时间: 2012-1-31 类型: PROBLEM 状态: MODERATED 优先级: 3

In this Document
  Symptoms
  Cause
  Solution

---

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.5 - Release: 10.2 to 10.2
Information in this document applies to any platform.

Symptoms

***Checked for relevance on 03-NOV-2010*** 

On 10.2.0.3, attempting to execute an SQL statement, the following errors are generated in both the alert.log and trace files: 

ORA-07445: exception encountered: core dump [opidsa()+386] 
Errors in file /orahome/oracle/admin/PHAM/bdump/pham2_diag_13962.trc: 
ORA-27050: function called with invalid FIB/IOV structure 
Additional information: 2 
ORA-27077: too many files open 

Stack is similar to:

ksedst

Cause

This is caused by a lack of OS configuration where ORA-07445 [opidsa()+386] is a result of ORA-27077, which is caused by a low number of files (descriptors). 

Solution

- Run the HCVE script. or the RDA and check if the value of nofiles parameter is set as recommended by Oracle for 10.2 releases.

Increase the ulimit(NOFILES) for the Oracle user to a minimum of 4096.

根据文章提示查看oracle用户的限制值：


上面的显示open files的值是1024，根据提示修改/etc/security/limits.conf的值：

oracle soft nofile 4096

oracle hard nofile 65536
        修改后，将数据库实例重新启动，报错即消失。

--end--

2.jpg

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23135684/viewspace-758998/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23135684/viewspace-758998/