rac下一节点连接数满导致ORA-12516以及产生Disk file operations I/O等待事件

问题描述：
1.前台客户报数据库操作等错误。                                     
2.weblogic 数据源报overload。    
3.连接数据该节点时 提示 ：    ORA-12516: TNS: 监听程序找不到符合协议堆栈要求的可用处理程。
4.从另一节点进入，查询等待事件，出现大量  Disk file operations I/O 等待 事件。
           
问题分析：

ORA-12516: TNS:listener could not find available handler with matching protocol stack

Cause: None of the known and available service handlers for the given SERVICE_NAME support the client's protocol stack: transport, session, and presentation protocols.

Action: Check to make sure that the service handlers (e.g. dispatchers) for the given SERVICE_NAME are registered with the listener, are accepting connections, and that they are properly configured to support the desired protocols.

导致ORA-12516错误 ，没 有已知的和可用的服务处理程序给予SERVICE_NAME的支持客户端的协议栈，要检查监听器是否注册，当process数满也会导致该问题。                                                                                                

Disk file operations I/O
This event is used to wait for disk file operations (for example, open, close, seek, and resize). It is also used for miscellaneous I/O operations such as block dumps and password file accesses.
Wait Time: The wait time is the actual time it takes to do the I/O
Parameter Description
FileO peration Type of file operation
fileno File identification number
filetype Type of file (for example, log file, data file, and so on)

导致Disk file operations I/O是Oracle 等待磁盘文件操作（例如，打开，关闭，寻求和调整大小）造成的I/O 等待事件。                                                  Disk file operations I/O

Disk file operations I/

问题解决：                                      

1.杀掉一些可杀除的连接。                                                                                
2.找出topsql  ，创建索引等（这次主要是几条sql对300万左右的表进行全表扫描造成的  ）。    
3.轮起weblogic server。                                                             

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

转载于:http://blog.itpub.net/29863023/viewspace-1571457/