trace中大量发现:Waited for process J000 to initialize for 75 seconds
生产环境为REDHAT5.4 + 11201 + RAC最近在TRACE中大量发现下列现象,并且有“ORA-00445: 后台进程 "J000" 在 120 秒之后仍没有启动”的问题:
*** 2013-10-25 22:25:45.277
Waited for process J000 to initialize for 75 seconds
*** 2013-10-25 22:25:45.277
Process diagnostic dump for J000, OS id=13374
-------------------------------------------------------------------------------
loadavg : 0.98 1.02 1.03
Memory (Avail / Total) = 8667.05M / 16026.06M
Swap (Avail / Total) = 32765.38M / 32765.38M
F S UID PID PPID C PRI NI ADDR SZ WCHAN STIME TTY TIME CMD
0 R oracle 13374 1 99 85 0 - 51827 stext 22:24 ? 00:01:15 ora_j000_netdb1
Stack:
/proc/13374/exe: Permission denied.
ptrace: Operation not permitted.
/u01/app/oracle/product/11.2.0/db_1/dbs/13374: No such file or directory.
No stack.
-------------------------------------------------------------------------------
Process diagnostic dump actual duration=0.040000 sec
(max dump time=30.000000 sec)
不清楚到底发生了什么,望专家帮忙分析一下。谢谢!
附件为TRACE文件。 11.2.0.1 + linux
建议 你 升级到11.2.0.4+调整Linux内核参数为最佳实践+调优性能
我严重怀疑这套系统的安装存在问题 包括Linux和Oracle 哦,谢谢刘大
页:
[1]