FATAL ERROR IN TWO-TASK SERVER: error = 12152

数据库:9206

今天一DB出现error:

*** 2009-01-13 14:47:37.622
*** SESSION ID:(120.2) 2009-01-13 14:47:37.603
FATAL ERROR IN TWO-TASK SERVER: error = 12152
*** 2009-01-13 14:47:37.622
ksedmp: internal or fatal error
Current SQL statement for this session:
SELECT CHILDID, PARENTID, MESSAGEHANDLE, CHILDCLASS, PRIORITY, ACCESSLEVEL, CREATEDATE, STATUS, ISEROTIC, ISPOLITICAL FROM TB_KONA_P
ARENTCHILD WHERE CHILDID = :1

.....

last wait for 'SQL*Net break/reset to client' blocking sess=0x0 seq=2536 wait_time=3

......

> oerr ora 12152
12152, 00000, "TNS:unable to send break message"
// *Cause: Unable to send break message. Connection probably disconnected.
// *Action: Reestablish connection. If the error is persistent, turn
// on tracing and reexecute the operation.
经过metalink查询,这是oracle一个未公布的bug:3816595。
Cause
The client application died (or dropped the connection) before the server
process could send the break/reset message back, and that prevented the server
process from exiting gracefully. This caused the server trace file to be dumped.
Solution
This issue has been reported and fixed via non-published bug:3816595
This issue is fixed in 9.2.0.8 (Server Patch Set),10.1.0.5 (Server Patch Set),10.2.0.1 (Base Release)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28419/viewspace-604029/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28419/viewspace-604029/