Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › trace中大量发现：Waited for process J000 to initiali ...

mdshuo

0 积分	1 好友	5 主题

发消息

[升级] trace中大量发现：Waited for process J000 to initialize for 75 seconds

1^#

发表于 2013-11-7 18:09:29 | 查看: 4408| 回复: 2

生产环境为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文件。