{"id":45,"date":"2011-08-28T23:58:21","date_gmt":"2011-08-28T15:58:21","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=45"},"modified":"2011-09-22T18:37:45","modified_gmt":"2011-09-22T10:37:45","slug":"ora-600krvxdds-duplicated-session-not%ef%bc%89%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=45","title":{"rendered":"ORA-600(krvxdds: duplicated session not\uff09\u9519\u8bef"},"content":{"rendered":"<p>\u5728\u5ba2\u6237\u7684\u544a\u8b66\u65e5\u5fd7\u4e2d\u53d1\u73b0\u8fd9\u4e2a\u9519\u8bef\u4fe1\u606f\u3002<br \/>\n\u8fd9\u4e2a\u9519\u8bef\u4fe1\u606f\u662f\u7b2c\u4e00\u6b21\u770b\u5230\uff0c\u800c\u4e14\u5728metalink\u4e2d\u4e5f\u6ca1\u6709\u627e\u5230\u4efb\u4f55\u76f8\u5173\u7684\u63cf\u8ff0\uff0c\u8be6\u7ec6\u7684\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Fri Nov 19 11:47:47 2010\r\n<krvrd.c:krvrdqgov>: Invalid dictionary process cntxt.\r\nFri Nov 19 11:47:47 2010\r\nErrors in file \/oracle\/db\/admin\/B1MODDB\/udump\/b1moddb1_ora_4488.trc:\r\nORA-00600: internal error code, arguments: [krvxdds: duplicated session not ], [], [], [], [], [], [], []\r\nORA-01334: invalid or missing logminer dictionary processes context\r\nFri Nov 19 11:48:05 2010\r\nTrace dumping is performing id=[cdmp_20101119114805]\r\nFri Nov 19 11:48:05 2010\r\nErrors in file \/oracle\/db\/admin\/B1MODDB\/udump\/b1moddb1_ora_4488.trc:\r\nORA-07445: exception encountered: core dump [lsfcln()+49] [SIGSEGV] [Address not mapped to object] [0x4200757400696D65] [] []\r\nORA-00600: internal error code, arguments: [krvxdds: duplicated session not ], [], [], [], [], [], [], []\r\nORA-01334: invalid or missing logminer dictionary processes context<\/pre>\n<p>\u5728ORA-600\u9519\u8bef\u51fa\u73b0\u4e4b\u524d\uff0c\u62a5\u4e86\u4e00\u4e2aC\u8bed\u8a00\u7684\u9519\u8bef\uff0c\u663e\u7136\u8fd9\u662f\u5bfc\u81f4ORA-600\u9519\u8bef\u7684\u539f\u56e0\u3002\u5206\u6790ORA-600\u9519\u8bef\u968f\u540e\u7684ORA-1334\u9519\u8bef\uff0c\u57fa\u672c\u53ef\u4ee5\u786e\u5b9a\uff0c\u6839\u672c\u9519\u8bef\u539f\u56e0\u662fORA-1334\uff0c\u800c600\u9519\u8bef\u662f\u8fd9\u4e2a\u9519\u8bef\u6240\u5f15\u53d1\u7684\u3002<\/p>\n<pre lang='SQL'>ORA-01334: invalid or missing logminer dictionary processes context\r\nCause: Unexpected internal error condition\r\nAction: None<\/pre>\n<p>\u800c\u8fd9\u4e2aORA-1334\u540c\u6837\u662f\u4e00\u4e2a\u5185\u5bb9\u9519\u8bef\uff0c\u65e2\u6ca1\u6709\u89e3\u91ca\u9519\u8bef\u539f\u56e0\uff0c\u4e5f\u6ca1\u6709\u8bf4\u660e\u89e3\u51b3\u65b9\u6cd5\u3002<br \/>\n\u7ee7\u7eed\u68c0\u67e5\u5bf9\u5e94\u7684TRACE\u4fe1\u606f\uff1a<\/p>\n<pre lang='SQL'>\/oracle\/db\/admin\/B1MODDB\/udump\/b1moddb1_ora_4488.trc\r\nOracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Oracle Label Security, Data Mining\r\nand Real Application Testing options\r\nORACLE_HOME = \/oracle\/db\r\nSystem name: HP-UX\r\nNode name: MODDB1\r\nRelease: B.11.23\r\nVersion: U\r\nMachine: ia64\r\nInstance name: B1MODDB1\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 0\r\nUnix process pid: 4488, image: oracle@MODDB1\r\n\r\nIoctl ASYNC_CONFIG error, errno = 1\r\n\/oracle\/db\/admin\/B1MODDB\/udump\/b1moddb1_ora_4488.trc\r\nOracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Oracle Label Security, Data Mining\r\nand Real Application Testing options\r\nORACLE_HOME = \/oracle\/db\r\nSystem name: HP-UX\r\nNode name: MODDB1\r\nRelease: B.11.23\r\nVersion: U\r\nMachine: ia64\r\nInstance name: B1MODDB1\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 159\r\nUnix process pid: 4488, image: oracle@MODDB1\r\n*** ACTION NAME:() 2010-11-19 11:47:47.799\r\n*** MODULE NAME:(TOAD 9.7.0.51) 2010-11-19 11:47:47.799\r\n*** SERVICE NAME:(B1MODDB) 2010-11-19 11:47:47.799\r\n*** SESSION ID:(473.17735) 2010-11-19 11:47:47.799\r\n*** 2010-11-19 11:47:47.799\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [krvxdds: duplicated session not ], [], [], [], [], [], [], []\r\nORA-01334: invalid or missing logminer dictionary processes context\r\nCurrent SQL statement for this session:\r\nSELECT * FROM V$LOGMNR_CONTENTS \r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedst()+64          call     ksedst1()            000000000 ? 000000001 ?\r\nksedmp()+2176        call     ksedst()             000000000 ?\r\n                                                   C000000000000C9F ?\r\n                                                   4000000003EDCDE0 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ?\r\nksfdmp()+48          call     ksedmp()             000000003 ?\r\nkgerinv()+304        call     ksfdmp()             C000000000000612 ?\r\n                                                   000000003 ?\r\n                                                   400000000938F250 ?\r\n                                                   00001603B ? 000000000 ?\r\n                                                   000000000 ?\r\nkgeasnmierr()+144    call     kgerinv()            6000000000031370 ?\r\n                                                   40000000018E6B10 ?\r\n                                                   6000000000032428 ?\r\n                                                   40000000018E6B10 ?\r\n                                                   9FFFFFFFFFFF62E0 ?\r\nkrvxdds()+368        call     kgeasnmierr()        6000000000031370 ?\r\n                                                   60000000001CF510 ?\r\n                                                   60000000001CF520 ?\r\n                                                   60000000000327A0 ?\r\n                                                   40000000012AFBB0 ?\r\nkrvfpsc_PostSelectC  call     krvxdds()            9FFFFFFFBF3AABB0 ?\r\nleanup()+432                                       9FFFFFFFFFFF6318 ?\r\n                                                   C000000000000896 ?\r\n                                                   4000000007161A50 ?\r\n                                                   9FFFFFFFFFFF6308 ?\r\nkrvfcact()+4496      call     krvfpsc_PostSelectC  9FFFFFFFBF37A0B8 ?\r\n                              leanup()             C0000000000013AE ?\r\n                                                   4000000007162EC0 ?\r\n                                                   0000160FB ?\r\n                                                   9FFFFFFFBC8044A8 ?\r\n                                                   9FFFFFFFFFFF6320 ?\r\n                                                   9FFFFFFFFFFF6310 ?\r\nqerfxFetch()+1040    call     krvfcact()           9FFFFFFFFFFF6930 ?\r\n                                                   9FFFFFFFBEF80500 ?\r\n                                                   9FFFFFFFFFFF6330 ?\r\n                                                   C0000000000015B3 ?\r\n                                                   0000000CA ?\r\n                                                   9FFFFFFFBD480738 ?\r\n                                                   4000000002D65350 ?\r\n                                                   9FFFFFFFFFFF6330 ?\r\nopifch2()+9632       call     qerfxFetch()         C0000002D9618B28 ?\r\n                                                   4000000001AD7CF0 ?\r\n                                                   9FFFFFFFFFFF6B90 ?\r\n                                                   0000001F4 ?\r\n                                                   60000000000AAC20 ?\r\n                                                   C000000000001F46 ?\r\n                                                   4000000002D43740 ?\r\n                                                   000018371 ?\r\nopifch()+112         call     opifch2()            9FFFFFFFFFFF7B50 ?\r\n                                                   4000000002DBFA70 ?\r\n                                                   000018287 ?<\/pre>\n<p>\u53ef\u4ee5\u770b\u5230\uff0c\u5bfc\u81f4\u9519\u8bef\u4ea7\u751f\u7684SQL\u662f\u67e5\u8be2V$LOGMNR_CONTENTS\u89c6\u56fe\u7684\u8bed\u53e5\u3002\u9664\u4e86\u8fd9\u4e2a\u9519\u8bef\u4fe1\u606f\u5916\uff0c\u8fd8\u53d1\u73b0\u6267\u884c\u8fd9\u4e2a\u8bed\u53e5\u7684\u5ba2\u6237\u7aef\u5de5\u5177\u662fTOAD\uff1a<\/p>\n<pre lang='SQL'>   (FOB) flags=2 fib=c00000032fa3a498 incno=0 pending i\/o cnt=0\r\n     fname=\/dev\/vg12\/rsystem\r\n     fno=1 lblksz=8192 fsiz=397311\r\n    ----------------------------------------\r\n    SO: c00000033f60dfb0, type: 4, owner: c00000033f45b248, flag: INIT\/-\/-\/0x00\r\n    (session) sid: 473 trans: 0000000000000000, creator: c00000033f45b248, flag: (8000041) USR\/- BSY\/-\/-\/-\/-\/-\r\n              DID: 0001-009F-00012412, short-term DID: 0001-009F-00012413\r\n              txn branch: 0000000000000000\r\n              oct: 3, prv: 0, sql: c0000002967468c0, psql: c0000002eed195f0, user: 0\/SYS\r\n    service name: B1MODDB\r\n    O\/S info: user: Ly, term: LIYAN, ospid: 3404:2428, machine: MSHOME\\LIYAN\r\n              program: toad.exe\r\n    application name: TOAD 9.7.0.51, hash value=1244923487\r\n    last wait for 'SQL*Net message from client' blocking sess=0x0000000000000000 seq=753 wait_time=16896447 seconds since wait started=18\r\n                driver id=54435000, #bytes=1, =0<\/pre>\n<p>\u914d\u5408ORA-600\u7684\u7b2c\u4e00\u4e2a\u9519\u8bef\u53c2\u6570\uff1akrvxdds: duplicated session not\uff0c\u6000\u7591\u53ef\u80fd\u662fTOAD\u5728\u8fd0\u884cLOGMNR\u547d\u4ee4\u65f6\uff0c\u4f7f\u7528\u4e86\u591a\u4e2a\u7a97\u53e3\u6216\u8005\u6307\u5b9a\u7684\u5b57\u5178\u6709\u8bef\uff0c\u4ece\u800c\u5bfc\u81f4\u4e86\u8fd9\u4e2a\u9519\u8bef\u51fa\u73b0\u3002\u5728\u544a\u8b66\u65e5\u5fd7\u4e2d\uff0c\u51fa\u73b0\u4e86\u591a\u6b21\u7684LOGMNR\u7684\u76f8\u5173\u4fe1\u606f\uff0c\u4f46\u662f\u8fd9\u4e2a\u9519\u8bef\u53ea\u51fa\u73b0\u4e86\u4e00\u6b21\uff0c\u800c\u8fd9\u4e2a\u9519\u8bef\u5728metalink\u90fd\u627e\u4e0d\u5230\uff0c\u4e5f\u8bf4\u660e\u8fd9\u4e2a\u9519\u8bef\u5f88\u96be\u89e6\u53d1\u3002\u770b\u6765\u8fd9\u53ef\u80fd\u662f\u5de5\u5177\u6216\u8005\u4f1a\u8bdd\u72b6\u6001\u4e0d\u6b63\u5e38\u5f15\u8d77\u7684\u9519\u8bef\uff0c\u53ea\u9700\u8981\u91cd\u65b0\u8fde\u63a5\u6570\u636e\u5e93\uff0c\u9519\u8bef\u5c31\u4e0d\u4f1a\u518d\u73b0\uff0c\u800c\u4e14\u5bf9\u4e8e\u6570\u636e\u5e93\u800c\u8a00\u57fa\u672c\u6ca1\u6709\u5f71\u54cd\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u5ba2\u6237\u7684\u544a\u8b66\u65e5\u5fd7\u4e2d\u53d1\u73b0\u8fd9\u4e2a\u9519\u8bef\u4fe1\u606f\u3002 \u8fd9\u4e2a\u9519\u8bef\u4fe1\u606f\u662f\u7b2c\u4e00\u6b21\u770b\u5230\uff0c\u800c\u4e14\u5728metalink\u4e2d\u4e5f\u6ca1\u6709\u627e\u5230\u4efb\u4f55\u76f8\u5173\u7684\u63cf\u8ff0\uff0c\u8be6\u7ec6\u7684\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a Fri Nov 19 11:47:47 2010 : Invalid dictionary process cntxt. Fri Nov 19 11:47:47 2010 Errors in file \/oracle\/db\/admin\/B1MODDB\/udump\/b1moddb1_ora_4488.trc: ORA-00600: internal error code, arguments: [krvxdds: duplicated session not ], [], [], [], [], [], [], [] ORA-01334: invalid &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=45\">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":[74,75,8],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-J","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/45"}],"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=45"}],"version-history":[{"count":2,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/45\/revisions"}],"predecessor-version":[{"id":134,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/45\/revisions\/134"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=45"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=45"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=45"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}