{"id":533,"date":"2012-01-31T23:54:23","date_gmt":"2012-01-31T15:54:23","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=533"},"modified":"2012-02-01T16:55:42","modified_gmt":"2012-02-01T08:55:42","slug":"ora-60012333%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=533","title":{"rendered":"ORA-600(12333)\u9519\u8bef"},"content":{"rendered":"<p>\u524d\u4e0d\u4e45\u624d\u5904\u7406\u4e86\u4e00\u4e2aORA-600[12333]\u9519\u8bef\uff0c\u4e0d\u8fc7\u90a3\u4e2a\u95ee\u9898\u662f9i\u4e0a\u7684\u3002<br \/>\nORA-600(12333)\u9519\u8bef\u548cORA-600(ttclxx1)\u9519\u8bef\uff1a<a href=\"http:\/\/yangtingkun.itpub.net\/post\/468\/526078\">http:\/\/yangtingkun.itpub.net\/post\/468\/526078<\/a><br \/>\n\u800c\u8fd9\u4e2a\u9519\u8bef\u662f\u53d1\u751f\u572810.2.0.3\u73af\u5883\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Tue Jan 31 15:31:14 2012\r\nErrors in file \/oracle\/admin\/ORCL\/udump\/orcl_ora_40960504.trc:\r\nORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []\r\n\u8be6\u7ec6TRACE\u6587\u4ef6\u5982\u4e0b\uff1a\r\nDump file \/oracle\/admin\/ORCL\/udump\/orcl_ora_40960504.trc\r\nOracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP and Data Mining options\r\nORACLE_HOME = \/oracle\/orcl\/10.2.0\r\nSystem name:\tAIX\r\nNode name:\tporcl2\r\nRelease:\t1\r\nVersion:\t6\r\nMachine:\t00F67AD94C00\r\nInstance name: ORCL\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 36\r\nUnix process pid: 40960504, image: oracleORCL@porcl2\r\n*** ACTION NAME:() 2012-01-31 15:31:14.454\r\n*** MODULE NAME:(TOAD 10.5.1.3) 2012-01-31 15:31:14.454\r\n*** SERVICE NAME:(SYS$USERS) 2012-01-31 15:31:14.454\r\n*** SESSION ID:(5422.6391) 2012-01-31 15:31:14.454\r\n--------------------\r\n PROTOCOL VIOLATION \r\n--------------------\r\n-----Page before-----\r\n1108880E0 00 00 00                                         [...]             \r\n-----Current Page-----\r\nnsbfdbpt 1108880e0\r\nifccrcp = 1108880e3, ifccrcl = 1108888d5\r\nbuffer length = 2034\r\n1108880E0          00 00 00 00 00 00 00 00 00 00 00 00 00     [.............]\r\n1108880F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]\r\n110888100 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]\r\n110888110 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]\r\n110888120 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]\r\n110888130 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]\r\n110888140 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]\r\n110888150 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]\r\n110888160 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]\r\n.\r\n.\r\n.\r\n110888890 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]\r\n1108888A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]\r\n1108888B0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]\r\n1108888C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]\r\n1108888D0 00 00 00 00 00                                   [.....]           \r\nhstflg:  0x40002991\r\nhstcflg: 0x00000000\r\nhstpro:  5\r\nhstccs:  (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.0.27)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)(CID=(PROGRAM=C:\\Program Files\\Quest Software\\Toad for Oracle 10.5\\Toad.exe)(HOST=HOST9)(USER=8000130559))))\r\n--- dump of hsttti ---\r\n1100C9E20 00 04 01 0C 0E 09 0B 0F 04 0A 03 03 01 00 00 0A  [................]\r\n1100C9E30 00 00 00 00 00 00 00 01 01 05 05 01 05 05 05 05  [................]\r\n1100C9E40 06 06 00 00 00 00 00 07 03 03 00 00 00 00 00 00  [................]\r\n1100C9E50 00 00 00 00 00 00 00 00 00 00 13 00 00 00 00 00  [................]\r\n1100C9E60 00 00 00 00 0C 00 00 00 00 00 14 00 00 00 00 00  [................]\r\n1100C9E70 00 00 00 00 00 00 00 00 00 00 00 0D 00 00 11 11  [................]\r\n1100C9E80 04 09 00 00 00 00 05 00 22 00 12 00 13 13 15 15  [........\".......]\r\n1100C9E90 17 17 17 17 21 03 00 00 03 13 13 13 00 00 00 00  [....!...........]\r\n1100C9EA0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]\r\n1100C9EB0 00 00 04 2E 00 00 00 00 0F 0F 0F 1F 20 00 00 00  [............ ...]\r\n1100C9EC0 00 00 00 00 00 00 00 00 00 00 00 00 0F 00 00 00  [................]\r\n1100C9ED0 00 00 00 00 00 00 00 00 2A 00 00 00 00 00 00 00  [........*.......]\r\n1100C9EE0 00 00 00 23 23 23 00 00 00 00 00 00 00 00 00 00  [...###..........]\r\n1100C9EF0 22 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [\"...............]\r\n1100C9F00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]\r\n1100C9F10 00 13 00 00 00 00 00 00 00 00 00 00 00 00 00 35  [...............5]\r\n1100C9F20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]\r\n1100C9F30 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]\r\n1100C9F40 00 00 03 01 03 03 03 00 00 00 03 03 03 03 03 03  [................]\r\n1100C9F50 03 03 03 03 03 03 03 03 03 03 00 03 03 03 03 03  [................]\r\n1100C9F60 03 03 03 03 00 00 00 03 03 03 00 03 00 03 03 03  [................]\r\n1100C9F70 03 03 03 03 03 03 03 01 00 03 03 00 03 03 00 00  [................]\r\n1100C9F80 00 00 03 03 00 00 00 03 00 00 00 03 00 00 00 00  [................]\r\n1100C9F90 00 00 00 00 00 00 00 00 00 00 00 00 03 03 03 03  [................]\r\n1100C9FA0 03 03 03 03 03 03 03 03 00 03 03 03 03 03 03 03  [................]\r\n1100C9FB0 03 03 00 00 03 03 03 03 00 00 00 00 00 03 03 03  [................]\r\n1100C9FC0 03 03 03 03 03 03 03 03 03 03 03 03 00 03 03 03  [................]\r\n1100C9FD0 03 03 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]\r\n1100C9FE0 00 00 1C 00 00 00 00 00 00 00 24 25 26 27 28 1E  [..........$%&'(.]\r\n1100C9FF0 00 00 00 2D 00 00 03 03 03 03 03 03 03 03 03 03  [...-............]\r\n1100CA000 03 03 03 2C 00 00 00 00 00 00 00 00 00 00 00 00  [...,............]\r\n1100CA010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]\r\n1100CA020 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]\r\n1100CA030 00 00 00 00 1A 00 00 00 00 00 00 00 00           [.............]   \r\nttclxlccst:     871\r\nttclxrccst:     871\r\nttclxlncst:     2000\r\nttclxrncst:     2000\r\nttclxccl2nr:    1\r\nttclxccn2lr:    1\r\nttclxncl2nr:    1\r\nttclxncn2lr:    1\r\nttclxrccminbpc: 1\r\nttclxrccmaxbpc: 3\r\nttclxrncminbpc: 2\r\nttclxrncmaxbpc: 2\r\nttclxflags:     0x23\r\nprev funcode: 0x5e\r\n*** 2012-01-31 15:31:14.470\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []\r\nCurrent SQL statement for this session:\r\nSelect CREATED, LAST_DDL_TIME, OBJECT_ID, STATUS, TIMESTAMP\r\nFROM SYS.ALL_OBJECTS\r\nWHERE object_name = :nm\r\nAND   object_type = :t\r\nAND   owner = :o\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedst+001c          bl       ksedst1              900000000312A74 ? 000000000 ?\r\nksedmp+0290          bl       ksedst               1048E2120 ?\r\nksfdmp+0018          bl       03F34B6C             \r\nkgeriv+0108          bl       _ptrgl               \r\nkgesiv+0080          bl       kgeriv               000000013 ? 1100D1010 ?\r\n                                                   000000000 ? 00000000A ?\r\n                                                   1100C9B50 ?\r\nksesic3+0060         bl       kgesiv               104F4E830 ? 000000023 ?\r\n                                                   11025E118 ?\r\n                                                   800000000000F032 ?\r\n                                                   3FFC000000000003 ?\r\nopitsk+0ec0          bl       01FA62EC             \r\nopiino+0990          bl       opitsk               000010860 ? 000000000 ?\r\nopiodr+0adc          bl       _ptrgl               \r\nopidrv+0474          bl       opiodr               3C1028E590 ? 4102909B0 ?\r\n                                                   FFFFFFFFFFFF490 ? 0A0082608 ?\r\nsou2o+0090           bl       opidrv               3C02AB579C ? 4A0071248 ?\r\n                                                   FFFFFFFFFFFF490 ?\r\nopimai_real+01bc     bl       01FA4A34             \r\nmain+0098            bl       opimai_real          000000000 ? 000000000 ?\r\n__start+0070         bl       main                 000000000 ? 000000000 ?\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n<p>\u8fd9\u4e2a600\u9519\u8bef\u548c\u5176\u4ed6\u7684\u9519\u8bef\u5e76\u4e0d\u76f8\u540c\uff0c\u4e0a\u6765\u4e0d\u662f\u9519\u8bef\u4fe1\u606f\u548c\u9519\u8befSQL\uff0c\u800c\u662f\u76f4\u63a5\u7684\u9875\u9762DUMP\u4fe1\u606f\uff0c\u800c\u4e14\u4e00\u5f00\u59cb\u5c31\u5305\u542b\u4e86\u534f\u8bae\u51b2\u7a81\u7684\u9519\u8bef\u4fe1\u606f\u3002<br \/>\n\u7ecf\u5206\u6790\uff0c\u95ee\u9898\u7684\u63cf\u8ff0\u53ef\u4ee5\u53c2\u8003\u6587\u6863Bug 8625762  ORA-3137 [12333] due to bind data not read from wire\u3002\u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\u5728\u4e8e\u7f51\u7edc\u8fde\u63a5\u4e2d\u5305\u542b\u7684\u7ed1\u5b9a\u53d8\u91cf\u4fe1\u606f\u672a\u88ab\u8bfb\u53d6\u3002<br \/>\n\u8fd9\u4e2abug\u5f71\u54cd\u8303\u56f4\u6bd4\u8f83\u5e7f\uff0c10.2.0.4\u300110.2.0.5\u300111.1.0.6\u548c11.1.0.7\u90fd\u53ef\u80fd\u5b58\u5728\u8fd9\u4e2a\u95ee\u9898\uff0c\u800c\u5982\u679c\u8981\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\uff0c\u9700\u8981\u5c06\u7248\u672c\u5347\u7ea7\u523011.2.0.1\u621611.1.0.7.3\uff0c\u5982\u679c\u662f10.2\u7248\u672c\u60f3\u8981\u901a\u8fc7\u4e13\u95e8\u7684\u8865\u4e01\u6765\u4fee\u6b63\u8fd9\u4e2a\u95ee\u9898\uff0c\u90a3\u4e48\u81f3\u5c11\u8981\u5148\u5c06\u6570\u636e\u5e93\u7248\u672c\u5347\u7ea7\u523010.2.0.4.3\u3002<br \/>\n\u9664\u4e86\u6253\u8865\u4e01\u548c\u5347\u7ea7\u4e4b\u5916\uff0c\u8fd8\u53ef\u4ee5\u5c1d\u8bd5\u901a\u8fc7\u8bbe\u7f6e\u9690\u542b\u53c2\u6570&#8221;_optim_peek_user_binds&#8221;\u4e3afalse\u6765\u907f\u514d\u8fd9\u4e2abug\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u524d\u4e0d\u4e45\u624d\u5904\u7406\u4e86\u4e00\u4e2aORA-600[12333]\u9519\u8bef\uff0c\u4e0d\u8fc7\u90a3\u4e2a\u95ee\u9898\u662f9i\u4e0a\u7684\u3002 ORA-600(12333)\u9519\u8bef\u548cORA-600(ttclxx1)\u9519\u8bef\uff1ahttp:\/\/yangtingkun.itpub.net\/post\/468\/526078 \u800c\u8fd9\u4e2a\u9519\u8bef\u662f\u53d1\u751f\u572810.2.0.3\u73af\u5883\u4e0b\uff1a Tue Jan 31 15:31:14 2012 Errors in file \/oracle\/admin\/ORCL\/udump\/orcl_ora_40960504.trc: ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], [] \u8be6\u7ec6TRACE\u6587\u4ef6\u5982\u4e0b\uff1a Dump file \/oracle\/admin\/ORCL\/udump\/orcl_ora_40960504.trc Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 &#8211; 64bit Production With &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=533\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[413,8,426],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-8B","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/533"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=533"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/533\/revisions"}],"predecessor-version":[{"id":534,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/533\/revisions\/534"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=533"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=533"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}