tbwshc

          啟動取消導致ORA-600(2658)錯誤

          客戶數據庫在SHUTDOWN的過程中執行了取消操作,導致了ORA-600錯誤。

           

           

          數據庫版本為10.2.0.4 RAC for HP-UX,詳細錯誤信息為:

          Thu Oct 22 15:05:14 2009
          Shutting down instance: further logons disabled
          Thu Oct 22 15:05:15 2009
          Stopping background process QMNC
          Thu Oct 22 15:05:15 2009
          Stopping background process CJQ0
          Thu Oct 22 15:05:17 2009
          Stopping background process MMNL
          Thu Oct 22 15:05:18 2009
          Stopping background process MMON
          Thu Oct 22 15:05:19 2009
          Shutting down instance (immediate)
          License high water mark = 8
          Thu Oct 22 15:05:19 2009
          Stopping Job queue slave processes, flags = 7
          Thu Oct 22 15:05:19 2009
          Job queue slave processes stopped
          Thu Oct 22 15:05:20 2009
          ALTER DATABASE CLOSE NORMAL
          Thu Oct 22 15:05:20 2009
          SMON: disabling tx recovery
          SMON: disabling cache recovery tb
          Thu Oct 22 15:05:21 2009
          LGWR: Waiting for ORLs to be archived...
          Thu Oct 22 15:05:36 2009
          Reconfiguration started (old inc 2, new inc 4)
          List of nodes:
          0 1
          Global Resource Directory frozen
          Communication channels reestablished
          * domain 0 valid = 1 according to instance 0
          Thu Oct 22 15:05:36 2009
          Master broadcasted resource hash value bitmaps
          Non-local Process blocks cleaned out
          Thu Oct 22 15:05:36 2009
          LMS 0: 0 GCS shadows cancelled, 0 closed
          Thu Oct 22 15:05:36 2009
          LMS 1: 0 GCS shadows cancelled, 0 closed
          Set master node info
          Submitted all remote-enqueue requests
          Dwn-cvts replayed, VALBLKs dubious
          All grantable enqueues granted
          Thu Oct 22 15:05:36 2009
          LMS 1: 2008 GCS shadows traversed, 1001 replayed
          Thu Oct 22 15:05:36 2009
          LMS 0: 1988 GCS shadows traversed, 1034 replayed
          Thu Oct 22 15:05:36 2009
          Submitted all GCS remote-cache requests
          Fix write in gcs resources
          Reconfiguration complete
          Thu Oct 22 15:05:51 2009
          CLOSE: Error 1013 during database close
          Thu Oct 22 15:05:51 2009
          SMON: enabling cache recovery
          SMON: enabling tx recovery
          Thu Oct 22 15:05:51 2009
          ORA-1013 signalled during: ALTER DATABASE CLOSE NORMAL...
          Thu Oct 22 15:05:51 2009
          Errors in file /u01/app/oracle/admin/orcl3/bdump/orcl32_lns1_4678.trc:
          ORA-00600: internal error code, arguments: [2658], [4], [2], [], [], [], [], []
          Thu Oct 22 15:05:52 2009
          Trace dumping is performing id=[cdmp_20091022150552]
          Thu Oct 22 15:05:52 2009
          Errors in file /u01/app/oracle/admin/orcl3/bdump/orcl32_lns1_4678.trc:
          ORA-00600: internal error code, arguments: [2658], [4], [2], [], [], [], [], []
          Thu Oct 22 15:05:55 2009
          LGWR: ORLs successfully archived
          Shutting down archive processes
          Archiving is disabled
          Thu Oct 22 15:06:00 2009
          ARCH shutting down
          ARC3: Archival stopped
          Thu Oct 22 15:06:05 2009
          ARCH shutting down
          ARC2: Archival stopped
          Thu Oct 22 15:06:10 2009
          ARCH shutting down
          ARC1: Archival stopped
          Thu Oct 22 15:06:15 2009
          ARCH shutting down
          ARC0: Archival stopped
          Thu Oct 22 15:06:16 2009
          Thread 2 closed at log sequence 23
          Successful close of redo thread 2

          可以看到,用戶在執行了SHUTDOWN IMMEDIATE操作后,執行了CTRL+C取消操作,導致了ORA-1031錯誤,之后同一時間引發了ORA-600[2658]錯誤。顯然這個錯誤的產生和用戶發出的取消命令直接相關,而且最終這個命令并未生效,數據庫成功的被關閉。

          在MOS上查詢了一下ORA-600[2658]的相關錯誤,發現多部分錯誤都出現在7.3和8.1版本上,在9i以后這個錯誤已經很少見了,從這一點也可以看出,導致這個錯誤出現的是偶然的因素,那么取消操作顯然是導致這個錯誤的最大可能性。

          數據庫本身處于關閉過程中,因此這個錯誤沒有影響,可以直接忽略掉。

          posted on 2012-09-04 16:54 chen11-1 閱讀(914) 評論(0)  編輯  收藏


          只有注冊用戶登錄后才能發表評論。


          網站導航:
           
          主站蜘蛛池模板: 桓台县| 抚州市| 和平区| 临沂市| 商洛市| 沾化县| 蓬溪县| 石林| 阿鲁科尔沁旗| 蒙城县| 获嘉县| 连江县| 鹤岗市| 抚宁县| 新宾| 清水县| 弥勒县| 舞钢市| 镇江市| 石河子市| 金华市| 洛隆县| 建阳市| 宝坻区| 武鸣县| 滕州市| 民勤县| 吉林市| 卓尼县| 赣榆县| 江口县| 海兴县| 华安县| 石嘴山市| 绥棱县| 桃源县| 阳原县| 焉耆| 宜丰县| 长沙市| 剑河县|