ORA-7445 [kglic0]
最近遇到了ORA-7445 [kglic0],这个错误时由于SGA损坏
相关:
Bug 13550185 - Hang / SGA memory corruption / ORA-7445 [kglic0] when using multiple shared pool subpools [ID 13550185.8]
MMON Slave Process Reports ORA-7445 [kglic0]/[kksIterCursorStat] Error, Plus Database Hangs [ID 1487720.1]
可能受到影响的版本:11.2.0.2/3
11.2.0.3.4修复
但是打了补丁后,还是可能报ORA-7445 [kglic0],这是在通过MTS连接时导致(产生PQ子进程时应该也可能造成)
Bug 13853126 - Dispatchers/new PQ slaves can get mutex with same session id - SGA memory corruption [ID 13853126.8]
Instance Hang And Crash With ORA-07445: [kglic0()] Even With Patch 13550185 Installed When Dispatchers Are Being Used [ID 1526720.1]
这2个补丁之间是存在冲突的,在11.2.0.3.3这个版本上
可以打这个PATCH:
Patch 16354807: MERGE REQUEST ON TOP OF Database PSU 11.2.0.3.3 FOR BUGS 11895446 13550185
包含的BUG:
11895446 'VIRTUAL CIRCUIT WAIT' DUE TO INSTANCE LOCKS HELD
13550185 QUERIES ON V$SQLSTATS MAY CAUSE CRASH OR HANG
13853126 DISPATCHERS CAN GET MUTEX WITH SAME SESSION ID
最近遇到了ORA-7445 [kglic0],这个错误时由于SGA损坏
相关:
Bug 13550185 - Hang / SGA memory corruption / ORA-7445 [kglic0] when using multiple shared pool subpools [ID 13550185.8]
MMON Slave Process Reports ORA-7445 [kglic0]/[kksIterCursorStat] Error, Plus Database Hangs [ID 1487720.1]
可能受到影响的版本:11.2.0.2/3
11.2.0.3.4修复
但是打了补丁后,还是可能报ORA-7445 [kglic0],这是在通过MTS连接时导致(产生PQ子进程时应该也可能造成)
Bug 13853126 - Dispatchers/new PQ slaves can get mutex with same session id - SGA memory corruption [ID 13853126.8]
Instance Hang And Crash With ORA-07445: [kglic0()] Even With Patch 13550185 Installed When Dispatchers Are Being Used [ID 1526720.1]
这2个补丁之间是存在冲突的,在11.2.0.3.3这个版本上
可以打这个PATCH:
Patch 16354807: MERGE REQUEST ON TOP OF Database PSU 11.2.0.3.3 FOR BUGS 11895446 13550185
包含的BUG:
11895446 'VIRTUAL CIRCUIT WAIT' DUE TO INSTANCE LOCKS HELD
13550185 QUERIES ON V$SQLSTATS MAY CAUSE CRASH OR HANG
13853126 DISPATCHERS CAN GET MUTEX WITH SAME SESSION ID
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8242091/viewspace-757936/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8242091/viewspace-757936/