\u5728Oracle 10.2.0.4 RAC for Windows\u73af\u5883\u7684\u544a\u8b66\u65e5\u5fd7\u4e2d\u53d1\u73b0\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002<\/p>\n
Windows\u4e0b\u7684Oracle\u7ef4\u62a4\u7684\u4e0d\u591a\uff0c\u800cWindows\u4e0b\u7684RAC\u5c31\u66f4\u5c11\u89c1\u4e86\uff0c\u800c\u5bf9\u5e94\u7684\u8fd9\u4e2a\u9519\u8bef\u4e5f\u662f\u6bd4\u8f83\u5c11\u89c1\u7684\uff1a<\/p>\n
Wed Oct 13 13:00:07 2010\r\nErrors in file c:\\app\\oracle\\product\\10.2.0\\admin\\cam\\bdump\\cam1_arc1_6052.trc:\r\nORA-16038: \u65e5\u5fd7 2 sequence# 508 \u65e0\u6cd5\u5f52\u6863\u3002\r\nORA-19504: \u65e0\u6cd5\u521b\u5efa\u6587\u4ef6\"\"\r\nORA-00312: \u8054\u673a\u65e5\u5fd7 2 \u7ebf\u7a0b 1: '+CAM\/cam\/onlinelog\/group_2.266.724245379'\r\nWed Oct 13 13:00:32 2010\r\nErrors in file c:\\app\\oracle\\product\\10.2.0\\admin\\cam\\bdump\\cam1_m000_3972.trc:\r\nORA-07445: \u51fa\u73b0\u5f02\u5e38\u9519\u8bef: \u6838\u5fc3\u8f6c\u50a8 [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7FEFE115160] [ADDR:0xFFFFFFFFFFFFFFFF] [UNABLE_TO_READ] []<\/pre>\n\u5bfc\u81f4\u8fd9\u4e2aORA-7445\u9519\u8bef\u7684\u662fM000\u8fdb\u7a0b\uff0c\u8bf4\u660e\u662fAWR\u5feb\u7167\u751f\u6210\u65f6\u5bfc\u81f4\u7684\u9519\u8bef\uff0c\u68c0\u67e5\u8be6\u7ec6\u7684\u9519\u8bef\u4fe1\u606f\uff1a<\/p>\n
*** ACTION NAME:(Auto-Flush Slave Action) 2010-10-13 13:00:32.504\r\n*** MODULE NAME:(MMON_SLAVE) 2010-10-13 13:00:32.504\r\n*** SERVICE NAME:(SYS$BACKGROUND) 2010-10-13 13:00:32.504\r\n*** SESSION ID:(48.9158) 2010-10-13 13:00:32.504\r\n*** 2010-10-13 13:00:32.504\r\nksedmp: internal or fatal error\r\nORA-07445: \u51fa\u73b0\u5f02\u5e38\u9519\u8bef: \u6838\u5fc3\u8f6c\u50a8 [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7FEFE115160] [ADDR:0xFFFFFFFFFFFFFFFF] [UNABLE_TO_READ] []\r\nCurrent SQL statement for this session:\r\ninsert into wrh$_comp_iostat (SNAP_ID, DBID, INSTANCE_NUMBER, COMPONENT, FILE_TYPE, IO_TYPE, OPERATION, BYTES, IO_COUNT) select :snap_id, :dbid, :instance_number, 'RMAN', 'DATAFILE', is_sync, type, sum(bytes), sum(io_count) from (select decode(x.type, 1, 'READ', 'WRITE') as type, case when (bitand(x.flags, 2) = 0) then 'SYNC' else 'ASYNC' end as is_sync, x.blocks * x.block_size as bytes, case when (bitand(x.flags, 2) = 0) then (x.sync_count) else (x.async_short_count + x.async_long_count + x.async_ready) end as io_count from x$ksfqp x, v$dbfile df where x.type in (1,2) and df.name = x.filename) group by is_sync, type\r\ncheck trace file c:\\app\\oracle\\product\\10.2.0\\db_1\\rdbms\\trace\\cam1_ora_0.trc for preloading .sym file messages\r\n----- Call Stack Trace -----\r\ncalling call entry argument values in hex \r\nlocation type point (? means dubious value) \r\n-------------------- -------- -------------------- ----------------------------\r\n000007FEFE115160 0000000000000000 000000000 000000000 000000000\r\n 000000000\r\nksfqpcb+289 CALL??? 000007FEFE115160 000000000 000000000 2A2D4F668\r\n 0000003BA\r\nqerfxFetch+1946 CALL??? ksfqpcb+289 021640168 000000000 000000000\r\n 000000001\r\nrwsfcd+109 CALL??? qerfxFetch+1946 2A2D4F868 000007FFF 0239D6210\r\n 2A2D4E7F0\r\nqerhjFetch+569 CALL??? rwsfcd+109 00001F430 005559DD8\r\n 7FF4DBC5C48 7FF0FDB2DC8\r\nqergsFetch+637 CALL??? qerhjFetch+569 02030FCF8 000000108 000000000\r\n 0211452A8\r\nrwsfcd+109 CALL??? qergsFetch+637 7FF4DBC56C0 7FF0E13002E\r\n 000000000 7FF3A922C50\r\ninsfch+132 CALL??? rwsfcd+109 0211452A8 021145350 021144A94\r\n 021145338\r\ninsdrv+762 CALL??? insfch+132 000000000 000000000\r\n 7FF4DBC5C48 0239D6210\r\ninscovexe+470 CALL??? insdrv+762 02030C1D8 000000018 000000000\r\n 000000000\r\ninsExecStmtExecIniE CALL??? inscovexe+470 2A2D53420 2A2D4D3E8 021145D98\r\nngine+99 000000002\r\ninsexe+453 CALL??? insExecStmtExecIniE 000000003 000000031 000000000\r\n ngine+99 0239D6210\r\nopiexe+4991 CALL??? insexe+453 2A2D52DA0 021145D98 000000102\r\n 000000000\r\nkpoal8+2139 CALL??? opiexe+4991 000000049 000000003 021146380\r\n 000000001\r\nopiodr+1136 CALL??? kpoal8+2139 00000005E 000000000 02114A0E8\r\n 0000003C8\r\nkpoodrc+30 CALL??? opiodr+1136 00000005E 000000000 02114A0E8\r\n 000000000\r\nrpiswu2+517 CALL??? kpoodrc+30 0239D69D0 000000000 000000000\r\n 0239D69D0\r\nkpoodr+666 CALL??? rpiswu2+517 2B7048898 000000000 0202E9EF4\r\n 000000002\r\nxupirtrc+2119 CALL??? kpoodr+666 01010CA90 0202F6238 02114A058\r\n 000433555\r\nupirtrc+123 CALL??? xupirtrc+2119 000000000 0101463E7 000000000\r\n 02114A250\r\nkpurcsc+153 CALL??? upirtrc+123 000000000 0056EBE5D 02114B930\r\n 0202F6328\r\nkpuexecv8+1661 CALL??? kpurcsc+153 02114AA10 077338666 0202F6328\r\n 02114C901\r\nkpuexec+1680 CALL??? kpuexecv8+1661 224D2829BFEF 0202FF120\r\n 000000065 0052B55FA\r\nOCIStmtExecute+68 CALL??? kpuexec+1680 000000010 000000001 000000000\r\n 000000000\r\nkewrose_oci_stmt_ex CALL??? OCIStmtExecute+68 020000021 7FF812517B0\r\nec+80 004032B0D 0202FF120\r\nkewrgwxf1_gwrsql_ex CALL??? kewrose_oci_stmt_ex 000000000 000000000 00000004C\r\nft_1+378 ec+80 000000000\r\nkewrgwxf_gwrsql_exf CALL??? kewrgwxf1_gwrsql_ex 000000000 000000000\r\nt+571 ft_1+378 7FFDEADBEEF 000000000\r\nkewrews_execute_wr_ CALL??? kewrgwxf_gwrsql_exf 000000000 02114DEC8 034B245C0\r\nsql+70 t+571 200000015\r\nkewrftbs_flush_tabl CALL??? kewrews_execute_wr_ 003C89940 00001E650 00001E788\r\ne_by_sql+203 sql+70 00001E770\r\nkewrft_flush_table+ CALL??? kewrftbs_flush_tabl 000000000 00001E778 00001F758\r\n260 e_by_sql+203 7FF00000001\r\nkewrftec_flush_tabl CALL??? kewrft_flush_table+ 000000001 000000000 02114E2E0\r\ne_ehdlcx+826 260 000000000\r\nkewrfat_flush_all_t CALL??? kewrftec_flush_tabl 2BCC3004F 02114DEC0 000000000\r\nables+1395 e_ehdlcx+826 000000000\r\nkewrfos_flush_onesn CALL??? kewrfat_flush_all_t 000000001 000000001 000000004\r\nap+191 ables+1395 2B709CC28\r\nkewrfsc_flush_snaps CALL??? kewrfos_flush_onesn 7FF52E5B220 000000006\r\nhot_c+652 ap+191 7FF00000000 224D00000003\r\nkewrafs_auto_flush_ CALL??? kewrfsc_flush_snaps 000000001 000000001 00000002E\r\nslave+838 hot_c+652 0004A89F3\r\nkebm_slave_main+242 CALL??? kewrafs_auto_flush_ 7FF75831318 0004A8075\r\n slave+838 02114E5C0 2B7080C88\r\nksvrdp+1404 CALL??? kebm_slave_main+242 000000000 005273191 000000000\r\n 000000000\r\nopirip+834 CALL??? ksvrdp+1404 656E5C310000001E 003C8B000\r\n 02114FA30 000000000\r\nopidrv+860 CALL??? opirip+834 000000032 000000004 02114FD50\r\n 000000000\r\nsou2o+52 CALL??? opidrv+860 000000032 000000004 02114FD50\r\n 000000003\r\nopimai_real+272 CALL??? sou2o+52 000000000 000000000 000000000\r\n 000000000\r\nopimai+96 CALL??? opimai_real+272 000000000 000000000 000000000\r\n 000000000\r\nBackgroundThreadSta CALL??? opimai+96 02114FEA8 000000001 000000000\r\nrt+633 000000000\r\n00000000770C495D CALL??? BackgroundThreadSta 006CA7B50 000000000 000000000\r\n rt+633 000000000\r\n00000000772C8791 CALL??? 00000000770C495D 000000000 000000000 000000000\r\n 000000000\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n\u4ece\u8be6\u7ec6\u65e5\u5fd7\u4e2d\u53ef\u4ee5\u786e\u5b9a\u8fd9\u4e2aORA-7445\u9519\u8bef\u662f\u53d1\u751f\u5728ksfqpcb\u51fd\u6570\u4e0a\uff0c\u800c\u4e14\u9519\u8bef\u53d1\u751f\u7684SQL\u5728\u63d2\u5165WRH$_COMP_IOSTAT\u8868\u3002
\n\u6839\u636eMOS\u7684\u8bb0\u5f55\uff0c\u8fd9\u4e2a\u9519\u8bef\u4e0eBug 8710008 : ORA-07445 [KSFQPCB+0054] ON INSERT TO WRH$_COMP_IOSTAT IN MMON\u63cf\u8ff0\u7684\u975e\u5e38\u76f8\u4f3c\uff0c\u9664\u4e86\u62a5\u9519\u51fd\u6570\u548c\u62a5\u9519\u8bed\u53e5\u76f8\u540c\u5916\uff0c\u6570\u636e\u5e93\u7684\u7248\u672c\u4e5f\u90fd\u662f10.2.0.4\u3002Oracle\u5728\u8be5\u95ee\u9898\u63cf\u8ff0\u65f6\uff0c\u5c06BUG\u6307\u5411\u4e00\u4e2a\u672a\u516c\u5f00\u7684BUG\uff1a8710249\u3002\u867d\u7136\u8fd9\u4e2abug\u6ca1\u6709\u516c\u5f00\uff0c\u4f46\u662fOracle\u5728\u6587\u6863RMAN produces CORE dump during backup Ora-07445: [__gi_strncpy()+17] [ID 1094624.1]\u4e2d\u5bf9\u8fd9\u4e2a\u95ee\u9898\u8fdb\u884c\u4e86\u63cf\u8ff0\u3002\u8fd9\u4e2a\u9519\u8bef\u5f71\u54cd\u7248\u672c\u4e3a10.2.0.4\u53ca\u4ee5\u540e\u768410.2\u7248\u672c\uff0c\u800c\u8fd9\u4e2abug\u7684\u4fee\u590d\u8981\u523011.2\u4e2d\uff0c\u76ee\u524d\u6ca1\u6709\u572810.2\u4e2d\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u7684\u65b9\u6cd5\u3002
\n\u4e0d\u8fc7\u5ba2\u6237\u7684\u6570\u636e\u5e93\u7684\u544a\u8b66\u65e5\u5fd7\u4e2d\u53ea\u51fa\u73b0\u4e86\u4e00\u6b21\u8fd9\u4e2a\u9519\u8bef\uff0c\u8bf4\u660e\u8fd9\u4e2a\u9519\u8bef\u5e76\u975e\u6bcf\u6b21\u91cd\u73b0\uff0c\u800c\u4e14\u8fd9\u4e2a\u9519\u8bef\u51fa\u73b0\u4e4b\u524d\uff0c\u51fa\u73b0\u4e86\u5927\u91cf\u7684\u5f52\u6863\u9519\u8bef\u7684\u4fe1\u606f\uff0c\u4e0d\u80fd\u6392\u9664\u662f\u7531\u4e8e\u5f52\u6863\u65e0\u6cd5\u5b8c\u6210\uff0c\u4ece\u800c\u5f15\u53d1\u4e86\u8fd9\u4e2aWRH$_COMP_IOSTAT\u8868\u7684\u63d2\u5165\u9519\u8bef\u3002\u5bf9\u5e94\u5f53\u524d\u7684\u73af\u5883\u800c\u8a00\uff0c\u5982\u679c\u53ef\u4ee5\u907f\u514d\u5f52\u6863\u7684\u95ee\u9898\uff0c\u5f88\u53ef\u80fd\u5c31\u4e0d\u4f1a\u5f15\u8d77\u8fd9\u4e2aORA-7445\u9519\u8bef\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5728Oracle 10.2.0.4 RAC for Windows\u73af\u5883\u7684\u544a\u8b66\u65e5\u5fd7\u4e2d\u53d1\u73b0\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002 Windows\u4e0b\u7684Oracle\u7ef4\u62a4\u7684\u4e0d\u591a\uff0c\u800cWindows\u4e0b\u7684RAC\u5c31\u66f4\u5c11\u89c1\u4e86\uff0c\u800c\u5bf9\u5e94\u7684\u8fd9\u4e2a\u9519\u8bef\u4e5f\u662f\u6bd4\u8f83\u5c11\u89c1\u7684\uff1a Wed Oct 13 13:00:07 2010 Errors in file c:\\app\\oracle\\product\\10.2.0\\admin\\cam\\bdump\\cam1_arc1_6052.trc: ORA-16038: \u65e5\u5fd7 2 sequence# 508 \u65e0\u6cd5\u5f52\u6863\u3002 ORA-19504: \u65e0\u6cd5\u521b\u5efa\u6587\u4ef6”” ORA-00312: \u8054\u673a\u65e5\u5fd7 2 \u7ebf\u7a0b 1: ‘+CAM\/cam\/onlinelog\/group_2.266.724245379’ Wed Oct 13 13:00:32 2010 Errors in file c:\\app\\oracle\\product\\10.2.0\\admin\\cam\\bdump\\cam1_m000_3972.trc: ORA-07445: \u51fa\u73b0\u5f02\u5e38\u9519\u8bef: … Continue reading