{"id":275,"date":"2011-11-09T23:05:42","date_gmt":"2011-11-09T15:05:42","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=275"},"modified":"2011-11-10T09:13:11","modified_gmt":"2011-11-10T01:13:11","slug":"ora-6002037%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=275","title":{"rendered":"ORA-600(2037)\u9519\u8bef"},"content":{"rendered":"<p>\u6700\u8fd1\u5df2\u7ecf\u78b0\u5230\u591a\u8d77\u5ba2\u6237\u6570\u636e\u5e93\u65e0\u6cd5\u6253\u5f00\u7684\u60c5\u51b5\uff0c\u8fd9\u5c31\u662f\u5176\u4e2d\u4e00\u6b21\u3002<br \/>\n\u8fd9\u662f\u4e00\u4e2a10201 for Windows 64bit\u6570\u636e\u5e93\uff0c\u5728\u4e00\u6b21\u6389\u7535\u540e\uff0c\u6570\u636e\u5e93\u65e0\u6cd5\u542f\u52a8\uff0c\u5728\u540e\u53f0\u544a\u8b66\u65e5\u5fd7\u4e2d\u51fa\u73b0\u4e0b\u5217\u7684\u9519\u8bef\uff1a<\/p>\n<pre lang='SQL'>Mon Oct 31 00:00:28 2011\r\nalter database open\r\nMon Oct 31 00:00:28 2011\r\nBeginning crash recovery of 1 threads\r\nparallel recovery started with 16 processes\r\nMon Oct 31 00:00:28 2011\r\nStarted redo scan\r\nMon Oct 31 00:00:28 2011\r\nCompleted redo scan\r\n12587 redo blocks read, 161 data blocks need recovery\r\nMon Oct 31 00:00:29 2011\r\nStarted redo application at\r\nThread 1: logseq 661, block 34225\r\nMon Oct 31 00:00:29 2011\r\nRecovery of Online Redo Log: Thread 1 Group 3 Seq 661 Reading mem 0\r\nMem# 0 errs 0: D:\\ORACLE\\PRODUCT\\10.2.0\\ORADATA\\YCBG\\REDO03.LOG\r\nMon Oct 31 00:00:29 2011\r\nCompleted redo application\r\nMon Oct 31 00:00:29 2011\r\nErrors in file e:\\oracle\\product\\10.2.0\\admin\\ycbg\\bdump\\ycbg_p002_2196.trc:\r\nORA-00600: internal error code, arguments: [2037], [21598604], [2441871360], [0], [0], [0], [3729260873], [536936448]\r\nMon Oct 31 00:00:29 2011\r\nErrors in file e:\\oracle\\product\\10.2.0\\admin\\ycbg\\bdump\\ycbg_p006_2212.trc:\r\nORA-00600: internal error code, arguments: [2037], [4198106], [249167872], [229], [159], [0], [1456275520], [100740646]\r\n.\r\n.\r\n.\r\nMon Oct 31 00:00:30 2011\r\nErrors in file e:\\oracle\\product\\10.2.0\\admin\\ycbg\\bdump\\ycbg_p002_2196.trc:\r\nORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [kcbs_dump_adv_state+1127] [PC:0x60D4E1] [ADDR:0xFFFFFFFFFFFFFFFF] [UNABLE_TO_READ] []\r\nORA-00600: internal error code, arguments: [2037], [21598604], [2441871360], [0], [0], [0], [3729260873], [536936448]\r\n.\r\n.\r\n.\r\nMon Oct 31 00:00:31 2011\r\nErrors in file e:\\oracle\\product\\10.2.0\\admin\\ycbg\\bdump\\ycbg_p012_2236.trc:\r\nORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [ksl_cleanup+1220] [PC:0x49DA9C] [ADDR:0xFFFFFFFFFFFFFFFF] [UNABLE_TO_READ] []\r\nORA-00081: address range [0x179B63600000, 0x179B63600004) is not readable\r\nORA-00600: internal error code, arguments: [2037], [21649715], [1496514560], [228], [10], [0], [3855679818], [100820580]\r\nMon Oct 31 00:00:31 2011\r\nErrors in file e:\\oracle\\product\\10.2.0\\admin\\ycbg\\bdump\\ycbg_p007_2216.trc:\r\nORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [kslwte_tm+754] [PC:0x49FC16] [ADDR:0x82FD2228AB8] [UNABLE_TO_WRITE] []\r\n.\r\n.\r\n.\r\nMon Oct 31 00:00:35 2011\r\nErrors in file e:\\oracle\\product\\10.2.0\\admin\\ycbg\\udump\\ycbg_ora_2256.trc:\r\nORA-00600: internal error code, arguments: [ksuapc1], [0x110000078], [0x7FFD63F4E90], [131072], [0x7FFD62F4E98], [], [], []\r\n.\r\n.\r\n.\r\nCorrupt block relative dba: 0x014895b9 (file 5, block 562617)\r\nBad header found during crash\/instance recovery\r\nData in bad block:\r\ntype: 91 format: 5 rdba: 0x95b90000\r\nlast change scn: 0x0229.e7210148 seq: 0x0 flg: 0x00\r\nspare1: 0x6 spare2: 0xa2 spare3: 0x8b1d\r\nconsistency value in tail: 0x06010000\r\ncheck value in block header: 0x401\r\nblock checksum disabled\r\n.\r\n.\r\n.\r\nMon Oct 31 00:01:23 2011\r\nErrors in file e:\\oracle\\product\\10.2.0\\admin\\ycbg\\bdump\\ycbg_ora_2164.trc:\r\nORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [ksliwat+3150] [PC:0x4A1D92] [ADDR:0xFFFFFFFFFFFFFFFF] [UNABLE_TO_READ] []\r\n.\r\n.\r\n.\r\nMon Oct 31 00:01:26 2011\r\nErrors in file e:\\oracle\\product\\10.2.0\\admin\\ycbg\\bdump\\ycbg_reco_2148.trc:\r\nORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [kslwte_tm+754] [PC:0x49FC16] [ADDR:0x82FD2228AB8] [UNABLE_TO_WRITE] []\r\n.\r\n.\r\n.\r\nMon Oct 31 00:09:13 2011\r\nUSER: terminating instance due to error 472\r\nMon Oct 31 00:09:13 2011\r\nErrors in file e:\\oracle\\product\\10.2.0\\admin\\ycbg\\udump\\ycbg_ora_2772.trc:\r\nORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [ksuitm+1655] [PC:0x417C41] \r\n.\r\n.\r\n.\r\nMon Oct 31 00:41:26 2011\r\nErrors in file e:\\oracle\\product\\10.2.0\\admin\\ycbg\\bdump\\ycbg_ora_2080.trc:\r\nORA-00600: internal error code, arguments: [kmcpsched:Bad caller], [], [], [], [], [], [], []\r\n.\r\n.\r\n.\r\nMon Oct 31 04:58:05 2011\r\nErrors in file e:\\oracle\\product\\10.2.0\\admin\\ycbg\\bdump\\ycbg_p007_2960.trc:\r\nORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [kksOnErrorMutexCleanup+53] [PC:0x4A7ED5] [ADDR:0xFFFFFFFFFFFFFFFF] [UNABLE_TO_READ] []\r\nORA-00081: address range [0x163A63600000, 0x163A63600004) is not readable\r\nORA-00600: internal error code, arguments: [ksfdrmms1], [0x1111B5080], [], [], [], [], [], []\r\n.\r\n.\r\n.\r\nMon Oct 31 05:04:57 2011\r\nErrors in file e:\\oracle\\product\\10.2.0\\admin\\ycbg\\bdump\\ycbg_p004_3920.trc:\r\nORA-00600: internal error code, arguments: [ksfdchkfob1], [0x1111B8138], [0x1112694580000], [], [], [], [], []\r\n.\r\n.\r\n.\r\nMon Oct 31 05:04:58 2011\r\nErrors in file e:\\oracle\\product\\10.2.0\\admin\\ycbg\\bdump\\ycbg_mmon_2384.trc:\r\nORA-00600: internal error code, arguments: [KSSRMP2], [0x1112697F8], [0], [0], [], [], [], []\r\nORA-27041: unable to open file\r\nOSD-04001: \u903b\u8f91\u5757\u5927\u5c0f\u65e0\u6548 (OS 33554432)\r\n.\r\n.\r\n.\r\nMon Oct 31 05:15:08 2011\r\nErrors in file e:\\oracle\\product\\10.2.0\\admin\\ycbg\\bdump\\ycbg_p013_2484.trc:\r\nORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [kksOnErrorMutexCleanup+53] [PC:0x4A7ED5] [ADDR:0xFFFFFFFFFFFFFFFF] [UNABLE_TO_READ] []\r\nORA-00081: address range [0x17F663600000, 0x17F663600004) is not readable\r\nORA-00600: internal error code, arguments: [545], [0x110563848], [0], [16], [], [], [], []<\/pre>\n<p>\u8fd9\u91cc\u53ea\u662f\u8bb0\u5f55\u4e86\u4e0d\u91cd\u590d\u9519\u8bef\uff0c\u6bcf\u4e2a\u9519\u8bef\u90fd\u4f1a\u51fa\u73b0\u5f88\u591a\u6b21\uff0c\u7b80\u76f4\u662fORA-600\u548cORA-7445\u9519\u8bef\u7684\u5927\u96c6\u5408\u3002\u7531\u4e8e\u4e00\u4e2a\u9519\u8bef\uff0c\u4e00\u6b21\u6027\u5f15\u53d1\u8fd9\u4e48\u591a\u7684\u4e0d\u540cORA-600\u548cORA-7445\uff0c\u6211\u8fd8\u662f\u7b2c\u4e00\u6b21\u78b0\u5230\u3002<br \/>\n\u867d\u7136\u9519\u8bef\u4fe1\u606f\u5f88\u591a\uff0c\u4f46\u662f\u540e\u9762\u7684\u5927\u90e8\u5206\u9519\u8bef\uff0c\u9664\u4e86\u4e2a\u522b\u51e0\u4e2a\u5728MOS\u4e2d\u6ca1\u6709\u8bb0\u5f55\u5916\uff0c\u4e00\u4e9b\u9519\u8bef\u4e0e\u4e0d\u6b63\u5e38\u7684\u542f\u52a8\u6709\u5173\uff0c\u4e00\u4e9b\u9519\u8bef\u4e0e\u5b9e\u4f8b\u5d29\u6e83\u6709\u5173\uff0c\u53e6\u4e00\u4e9b\u662f\u4e0e\u6587\u4ef6\u635f\u574f\u6709\u5173\u3002\u4e5f\u5c31\u662f\u8bf4\uff0c\u8fd9\u4e9b\u9519\u8bef\u7684\u4ea7\u751f\u53ea\u662f\u73b0\u8c61\uff0c\u800c\u95ee\u9898\u7684\u4e3b\u8981\u539f\u56e0\u8fd8\u8981\u4ece\u7b2c\u4e00\u4e2a\u9519\u8bef\u4e0a\u5165\u624b\u3002<\/p>\n<pre lang='SQL'>*** 2011-10-31 00:00:29.259\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [2037], [21598604], [2441871360], [0], [0], [0], [3729260873], [536936448]\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedst+55            CALL???  ksedst1+573          970A00000000 00001D688\r\n                                                   014BBDE10 00001E5F0\r\nksedmp+663           CALL???  ksedst+55            003A750A8 000000000 014BBC888\r\n                                                   000000000\r\nksfdmp+19            CALL???  ksedmp+663           000000003 013EE4650 013A78A88\r\n                                                   003A975A0\r\nkgeriv+184           CALL???  ksfdmp+19            00001E5F0 013EE4010 000AEBD23\r\n                                                   27F00001FA0\r\nkgesiv+102           CALL???  kgeriv+184           000000000 000000000 013EE4010\r\n                                                   000000000\r\nksesic7+125          CALL???  kgesiv+102           7FFD2001EC0 232FBC020\r\n                                                   400000000 000000000\r\nkcoexam+249          CALL???  ksesic7+125          1000007F5 000000000 00149918C\r\n                                                   000000000\r\nkcbtema+647          CALL???  kcoexam+249          01B7C5FA0 10F776000 000000001\r\n                                                   000000007\r\nkcrpap+356           CALL???  kcbtema+647          1A1FBB198 7FF9EFC0B88\r\n                                                   7FF9EFC0604 013A7A558\r\nkcrpdv+1521          CALL???  kcrpap+356           003E5B9A8 00000000B 000000000\r\n                                                   000000000\r\nkxfprdp+1360         CALL???  kcrpdv+1521          000000001 003A7AC60 000000000\r\n                                                   000000000\r\nopirip+1250          CALL???  kxfprdp+1360         30315C740000001E 003A782E8\r\n                                                   014BBFA70 000000000\r\nopidrv+860           CALL???  opirip+1250          000000032 000000004 014BBFDA0\r\n                                                   000000000\r\nsou2o+52             CALL???  opidrv+860           000000032 000000004 014BBFDA0\r\n                                                   0068679D2\r\nopimai_real+272      CALL???  sou2o+52             000000000 0139C0000 000000828\r\n                                                   000000000\r\nopimai+96            CALL???  opimai_real+272      000000000 000000000 000000000\r\n                                                   000000000\r\nBackgroundThreadSta  CALL???  opimai+96            014BBFEF0 000000001 000000000\r\nrt+530                                             000000000\r\n0000000078D3B6DA     CALL???  BackgroundThreadSta  0068675C0 000000000 000000000\r\n                              rt+530               014BBFFA8\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n<p>\u67e5\u8be2MOS\u540e\u53d1\u73b0\uff0c\u6587\u6863During Startup (Open Database) Alert Log Shows ORA-600[2037] and ORA-7445[kcbs_dump_adv_state] [ID 551993.1]\u548c\u5f53\u524d\u63cf\u8ff0\u7684\u73b0\u8c61\u6700\u4e3a\u63a5\u8fd1\uff1a\u4e0d\u4f462037\u9519\u8bef\u548ckcbs_dump_adv_state\u9519\u8bef\u4fe1\u606f\u4e00\u81f4\uff0c\u6570\u636e\u5e93\u7248\u672c\u76f8\u7b26\uff0c\u8fde\u6587\u6863\u4e2d\u63d0\u5230\u7684kcoexam kcbtema kcrpap kcrpdv kxfprdp\u5806\u6808\u4fe1\u606f\u5728TRACE\u4e2d\u4e5f\u53ef\u4ee5\u4e00\u70b9\u4e0d\u5dee\u7684\u627e\u5230\u3002<br \/>\n\u5982\u679c\u5728\u5904\u7406\u5206\u5e03\u5f0f\u4e8b\u52a1\u7684\u65f6\u5019\u4f7f\u7528\u4e86IMU\uff08In Memory Undo\uff09\u6280\u672f\uff0c\u90a3\u4e48\u5982\u679c\u8fd9\u4e2a\u65f6\u5019\u6570\u636e\u5e93\u51fa\u73b0\u4e86\u5d29\u6e83\uff0c\u90a3\u4e48\u5f88\u4e0d\u5e78\uff0c\u5728Oracle\u91cd\u542f\u7684\u65f6\u5019\u5c1d\u8bd5\u5b9e\u4f8b\u6062\u590d\u7684\u8fc7\u7a0b\u4e2d\uff0c\u5c31\u4f1a\u5bfc\u81f4REDO\u6216UNDO\u7684\u635f\u574f\uff0c\u4ece\u800c\u5bfc\u81f4\u6570\u636e\u5e93\u65e0\u6cd5\u6253\u5f00\u3002\u800c\u5f53\u524d\u6570\u636e\u5e93\u7684\u62a5\u9519\u96c6\u4e2d\u53d1\u751f\u5728PNNN\u8fdb\u7a0b\u4e0a\uff0c\u8fd9\u8bf4\u660eOracle\u5728\u542f\u7528\u5e76\u884c\u6062\u590d\uff0c\u800c\u9519\u8bef\u4fe1\u606f\u4e2d\u8fd8\u53ef\u4ee5\u770b\u5230RECO\u8fdb\u7a0b\uff0c\u8bf4\u660eOracle\u5728\u5904\u7406\u5206\u5e03\u5f0f\u4e8b\u52a1\u7684\u6062\u590d\uff0c\u6240\u6709\u7684\u73b0\u8c61\u90fd\u5f88\u597d\u7684\u7b26\u5408\u4e86bug\u7684\u63cf\u8ff0\u3002<br \/>\n\u8fd9\u4e2aBug 4899479\u5f71\u54cd10.2.0.1\u523010.2.0.3\u7248\u672c\uff0c\u572810.2.0.4\u4e2d\u88abFIXED\u3002\u800c\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u7684\u5e38\u89c4\u624b\u6bb5\u53ea\u6709\u901a\u8fc7\u5907\u4efd\u8fdb\u884c\u53ca\u65f6\u70b9\u4e0d\u5b8c\u5168\u6062\u590d\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6700\u8fd1\u5df2\u7ecf\u78b0\u5230\u591a\u8d77\u5ba2\u6237\u6570\u636e\u5e93\u65e0\u6cd5\u6253\u5f00\u7684\u60c5\u51b5\uff0c\u8fd9\u5c31\u662f\u5176\u4e2d\u4e00\u6b21\u3002 \u8fd9\u662f\u4e00\u4e2a10201 for Windows 64bit\u6570\u636e\u5e93\uff0c\u5728\u4e00\u6b21\u6389\u7535\u540e\uff0c\u6570\u636e\u5e93\u65e0\u6cd5\u542f\u52a8\uff0c\u5728\u540e\u53f0\u544a\u8b66\u65e5\u5fd7\u4e2d\u51fa\u73b0\u4e0b\u5217\u7684\u9519\u8bef\uff1a Mon Oct 31 00:00:28 2011 alter database open Mon Oct 31 00:00:28 2011 Beginning crash recovery of 1 threads parallel recovery started with 16 processes Mon Oct 31 00:00:28 2011 Started redo scan Mon Oct &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=275\">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":[201,202,203,204,8,118],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-4r","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/275"}],"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=275"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/275\/revisions"}],"predecessor-version":[{"id":276,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/275\/revisions\/276"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=275"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=275"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}