{"id":628,"date":"2012-03-02T23:58:53","date_gmt":"2012-03-02T15:58:53","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=628"},"modified":"2012-03-04T01:00:35","modified_gmt":"2012-03-03T17:00:35","slug":"%e4%bf%ae%e6%94%b9%e6%95%b0%e6%8d%ae%e5%ad%97%e5%85%b8%e8%a1%a8%e5%af%bc%e8%87%b4ora-600ktecgsckcbz_objdchk%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=628","title":{"rendered":"\u4fee\u6539\u6570\u636e\u5b57\u5178\u8868\u5bfc\u81f4ORA-600(ktecgsc:kcbz_objdchk)\u9519\u8bef"},"content":{"rendered":"<p>\u516c\u53f8\u7684\u6d4b\u8bd5\u670d\u52a1\u73af\u5883\u88ab\u6574\u5d29\u6e83\u4e86\uff0c\u7b80\u5355\u8bb0\u5f55\u4e00\u4e0b\u9519\u8bef\u3002<br \/>\n\u540c\u4e8b\u53d1\u73b0\u4e00\u4e2a\u6d4b\u8bd5\u6570\u636e\u5e93\u65e0\u6cd5\u767b\u5f55\uff0c\u5bf9\u6570\u636e\u5e93\u6267\u884cSHUTDOWN ABORT\u540e\uff0c\u91cd\u65b0\u542f\u52a8bootstrap\u62a5\u9519\uff1a<br \/>\n[ora11g@hpserver2 ~]$ sqlplus \/ as sysdba<br \/>\nSQL*Plus: Release 11.2.0.3.0 Production on Sun Mar 4 00:37:58 2012<br \/>\nCopyright (c) 1982, 2011, Oracle. All rights reserved.<br \/>\nConnected to an idle instance.<br \/>\nSQL> startup<br \/>\nORACLE instance started.<br \/>\nTotal System Global Area 2555744256 bytes<br \/>\nFixed Size 2230912 bytes<br \/>\nVariable Size 637535616 bytes<br \/>\nDatabase Buffers 1862270976 bytes<br \/>\nRedo Buffers 53706752 bytes<br \/>\nDatabase mounted.<br \/>\nORA-01092: ORACLE instance terminated. Disconnection forced<br \/>\nORA-00704: bootstrap process failure<br \/>\nORA-00604: error occurred at recursive SQL level 1<br \/>\nORA-08103: object no longer exists<br \/>\nProcess ID: 20964<br \/>\nSession ID: 125 Serial number: 5<br \/>\n\u6570\u636e\u5e93\u600e\u4e48\u4f1a\u7a81\u7136\u51fa\u73b0\u8fd9\u4e48\u4e25\u91cd\u7684\u95ee\u9898\uff0c\u68c0\u67e5\u544a\u8b66\u65e5\u5fd7\u53d1\u73b0\u4e86\u5982\u4e0b\u7684\u9519\u8bef\uff1a<br \/>\nErrors in file \/u02\/app\/oracle\/diag\/rdbms\/orcl11g\/orcl11g\/trace\/orcl11g_ora_31804.trc (incident=127465):<br \/>\nORA-00600: internal error code, arguments: [ktecgsc:kcbz_objdchk], [0], [0], [1], [], [], [], [], [], [], [], []<br \/>\nIncident details in: \/u02\/app\/oracle\/diag\/rdbms\/orcl11g\/orcl11g\/incident\/incdir_127465\/orcl11g_ora_31804_i127465.trc<br \/>\nUse ADRCI or Support Workbench to package the incident.<br \/>\nSee Note 411.1 at My Oracle Support for error and packaging details.<br \/>\nDumping diagnostic data in directory=[cdmp_20120302133841], requested by (instance=1, osid=31804), summary=[incident=127465].<br \/>\nSweep [inc][127465]: completed<br \/>\nSweep [inc2][127465]: completed<br \/>\nErrors in file \/u02\/app\/oracle\/diag\/rdbms\/orcl11g\/orcl11g\/trace\/orcl11g_ora_31900.trc (incident=127449):<br \/>\nORA-00600: internal error code, arguments: [kkdlGetBaseUser2:authIdType], [0], [27], [GLOBAL_AQ_USER_ROLE], [], [], [], [], [], [], [], []<br \/>\nIncident details in: \/u02\/app\/oracle\/diag\/rdbms\/orcl11g\/orcl11g\/incident\/incdir_127449\/orcl11g_ora_31900_i127449.trc<br \/>\nUse ADRCI or Support Workbench to package the incident.<br \/>\nSee Note 411.1 at My Oracle Support for error and packaging details.<br \/>\nDumping diagnostic data in directory=[cdmp_20120302134009], requested by (instance=1, osid=31900), summary=[incident=127449].<br \/>\nSweep [inc][127449]: completed<br \/>\nSweep [inc2][127449]: completed<br \/>\n\u68c0\u67e5\u7b2c\u4e00\u4e2aORA-600\u5bf9\u5e94\u7684TRACE\uff0c\u53d1\u73b0\u51fa\u73b0\u9519\u8bef\u7684\u4f1a\u8bdd\u5728\u6267\u884c\u5bfc\u5165\uff1a<br \/>\n[ora11g@hpserver2 ~]$ more \/u02\/app\/oracle\/diag\/rdbms\/orcl11g\/orcl11g\/trace\/orcl11g_ora_31804.trc<br \/>\nTrace file \/u02\/app\/oracle\/diag\/rdbms\/orcl11g\/orcl11g\/trace\/orcl11g_ora_31804.trc<br \/>\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 &#8211; 64bit Production<br \/>\nWith the Partitioning, Oracle Label Security and Real Application Testing options<br \/>\nORACLE_HOME = \/u02\/app\/oracle\/product\/11.2.0\/db_1<br \/>\nSystem name: Linux<br \/>\nNode name: hpserver2.enmotech.com<br \/>\nRelease: 2.6.32-100.28.5.el6.x86_64<br \/>\nVersion: #1 SMP Wed Feb 2 18:40:23 EST 2011<br \/>\nMachine: x86_64<br \/>\nInstance name: orcl11g<br \/>\nRedo thread mounted by this instance: 1<br \/>\nOracle process number: 29<br \/>\nUnix process pid: 31804, image: oracle@hpserver2.enmotech.com (TNS V1-V3)<br \/>\n*** 2012-03-02 13:38:34.271<br \/>\n*** SESSION ID:(141.3959) 2012-03-02 13:38:34.271<br \/>\n*** CLIENT ID:() 2012-03-02 13:38:34.271<br \/>\n*** SERVICE NAME:(SYS$USERS) 2012-03-02 13:38:34.271<br \/>\n*** MODULE NAME:(imp@hpserver2.enmotech.com (TNS V1-V3)) 2012-03-02 13:38:34.271<br \/>\n*** ACTION NAME:() 2012-03-02 13:38:34.271<br \/>\n*** SESSION ID:(141.3959) 2012-03-02 13:38:34.270<br \/>\nDATA seg.obj=-2, on-disk obj=27, dsflg=0, dsobj=74, cls=4<br \/>\nIncident 127465 created, dump file: \/u02\/app\/oracle\/diag\/rdbms\/orcl11g\/orcl11g\/incident\/incdir_127465\/orcl11g_ora_31804_i127465.trc<br \/>\nORA-00600: internal error code, arguments: [ktecgsc:kcbz_objdchk], [0], [0], [1], [], [], [], [], [], [], [], []<br \/>\n*** SESSION ID:(141.3959) 2012-03-02 13:38:40.815<br \/>\nDATA seg.obj=0, on-disk obj=27, dsflg=0, dsobj=74, cls=4<br \/>\n\u548c\u540c\u4e8b\u786e\u8ba4\u4e86\u4e00\u4e0b\uff0c\u786e\u5b9e\u6709\u4e2a\u540c\u4e8b\u5728\u5bfc\u5165\u6570\u636e\u5b57\u5178\u8868\uff0c\u800c\u4e14\u672c\u6765\u5e94\u8be5\u5bfc\u5165\u5230\u5355\u72ec\u7684\u7528\u6237\u4e0b\uff0c\u4f46\u662f\u5bfc\u5165\u65f6\u5fd8\u4e86\u6dfb\u52a0TOUSER\uff0c\u5bfc\u81f4\u6570\u636e\u88ab\u5bfc\u5165\u5230SYS\u7528\u6237\u4e0b\uff0c\u9020\u6210\u4e86\u6570\u636e\u5b57\u5178\u7684\u4e0d\u4e00\u81f4\uff0c\u4ece\u800c\u5f15\u53d1\u4e86\u8fd9\u4e2a\u95ee\u9898\u3002<br \/>\n\u8fd9\u91cc\u5e76\u4e0d\u662f\u8981\u89e3\u51b3\u8fd9\u4e2a\u9519\u8bef\uff0c\u4e8b\u5b9e\u4e0a\u5982\u679c\u6ca1\u6709\u5b8c\u6574\u7684\u5907\u4efd\uff0c\u6570\u636e\u5e93\u5df2\u7ecf\u5f88\u96be\u6062\u590d\u4e86\u3002\u8fd9\u91cc\u4e3b\u8981\u662f\u8bb0\u5f55\u8fd9\u4e2a\u95ee\u9898\uff0c\u5e0c\u671b\u7ed9\u5176\u4ed6\u4eba\u5f15\u4ee5\u4e3a\u6212\u3002<br \/>\nDBA\u603b\u8981\u505a\u4e00\u4e9b\u9ad8\u98ce\u9669\u7684\u64cd\u4f5c\uff0c\u800cDBA\u53c8\u6709\u8db3\u591f\u7684\u77e5\u8bc6\u548c\u80fd\u529b\u5bfc\u81f4\u95ee\u9898\u4e00\u822c\u60c5\u51b5\u4e0b\u96be\u4ee5\u4ea7\u751f\u7684\u524d\u63d0\u8981\u6c42\u5f97\u4ee5\u5b9e\u73b0\u3002<br \/>\n\u6bd4\u5982\u5f53\u524d\u8fd9\u6b21\u4e8b\u6545\uff0c\u5982\u679c\u4e0d\u662fDBA\uff0c\u6ca1\u6709\u4e00\u5b9a\u4e13\u4e1a\u7684\u77e5\u8bc6\uff0c\u65e0\u6cd5\u4f7f\u7528IMP\u65b9\u5f0f\u6765\u5bfc\u5165\u6570\u636e\u5b57\u5178\u8868\u3002\u800c\u5bf9\u4e8e\u7f3a\u5c11\u4e86TOUSER\u53c2\u6570\u7684\u60c5\u51b5\u4e0b\uff0c\u8868\u4f1a\u5bfc\u5165\u5230SYS\u7528\u6237\u4e0b\uff0c\u4f46\u662f\u8fd9\u4f1a\u51fa\u73b0\u8868\u5df2\u7ecf\u5b58\u5728\u7684\u9519\u8bef\uff0c\u800c\u4f7f\u5f97\u5bfc\u5165\u5931\u8d25\u3002\u800c\u5bf9\u4e8eDBA\u6765\u8bf4\uff0c\u8fd9\u79cd\u5e38\u89c1\u9519\u8bef\u5e76\u4e0d\u4f1a\u5f15\u53d1DBA\u7684\u8db3\u591f\u91cd\u89c6\uff0c\u4e00\u4e2aIGNORE=Y\u53c2\u6570\u7684\u4f7f\u7528\uff0c\u6700\u7ec8\u917f\u6210\u4e86\u8fd9\u6b21\u4e8b\u6545\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u516c\u53f8\u7684\u6d4b\u8bd5\u670d\u52a1\u73af\u5883\u88ab\u6574\u5d29\u6e83\u4e86\uff0c\u7b80\u5355\u8bb0\u5f55\u4e00\u4e0b\u9519\u8bef\u3002 \u540c\u4e8b\u53d1\u73b0\u4e00\u4e2a\u6d4b\u8bd5\u6570\u636e\u5e93\u65e0\u6cd5\u767b\u5f55\uff0c\u5bf9\u6570\u636e\u5e93\u6267\u884cSHUTDOWN ABORT\u540e\uff0c\u91cd\u65b0\u542f\u52a8bootstrap\u62a5\u9519\uff1a [ora11g@hpserver2 ~]$ sqlplus \/ as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Sun Mar 4 00:37:58 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=628\">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":[3],"tags":[495,497,496,492,491,8,493,494],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-a8","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/628"}],"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=628"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/628\/revisions"}],"predecessor-version":[{"id":629,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/628\/revisions\/629"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=628"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=628"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}