问题描述:
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
1.杀掉一些可杀除的连接。
2.找出topsql ,创建索引等(这次主要是几条sql对300万左右的表进行全表扫描造成的 )。
3.轮起weblogic server。
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
导致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/
问题解决:1.杀掉一些可杀除的连接。
2.找出topsql ,创建索引等(这次主要是几条sql对300万左右的表进行全表扫描造成的 )。
3.轮起weblogic server。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29863023/viewspace-1571457/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29863023/viewspace-1571457/