ORA-29771: process string (OSID string) blocks string (OSID string) for more than string seconds ORACLE 报错 故障修复 远程处理

文档解释

ORA-29771: process string (OSID string) blocks string (OSID string) for more than string seconds

Cause: The specified process blocked a global enqueue process for the maximum allowed time.

Action: Check the alert file and relevent trace files and contact Oracle Support Services with the incident information.

官方解释

一般处理方法及步骤

1.检查point string和block string之间的关联；

2.尝试检查point string和block string之间的其他部分；

3.检查系统是否存在异常情况，可能与错误有关；

4.检查是否存在处理时间过长的程序；

5.重新启动block string，看看能否解决该错误；

6.重新启动point string，看看能否解决该错误。