有人反映业务经常性中断,根据技术人员初步判断是由于应用程序无法连接数据库导致的。
登录数据库查看日志,发现日志有如下错误信息:
02-SEP-2012 14:23:25 * (CONNECT_DATA=(SID=ora10g)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=*.*.*.*)(PORT=2024)) * establish * ora10g * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12549: TNS perating system resource quota exceeded
TNS-12560: TNS rotocol adapter error
TNS-00519: Operating system resource quota exceeded
HPUX Error: 12: Not enough space
······
kkjcre1p: unable to spawn jobq slave process
Thu Dec 27 13:34:15 2012
Errors in file /oracle/app/oracle/admin/ora10g/bdump/ora10g_cjq0_2922.trc:
Thu Dec 27 13:34:20 2012
Process startup failed, error stack:
如何分析:1. 检查cpu占用资源
top cpu空闲率90%多,没有相关oracle进程占用cpu资源
procs memory page
faults cpu
r b w avm free re at pi po fr de sr in
sy