Oracle事件打包服務(wù)(IncidentPackagingService,IPS)

packaging incidents（打包事件）
oracle 11g的一個(gè)很強(qiáng)有力的工具是打包事件。利用這個(gè)打包事件壓縮的文件夾提交給oracle的支持來幫助解決分析問題。
一旦你創(chuàng)建一個(gè)事件包，將添加一個(gè)或多個(gè)相關(guān)的問題到打包文件中。其中包括trace文件，dump文件等。
缺省情況下，每一個(gè)問題的事件包僅僅包括第一個(gè)和最后三個(gè)事件。事件包包含所有可以用于診斷的事件。也可以指定事件發(fā)生的時(shí)間或數(shù)
量范圍來打包。
一旦你創(chuàng)建了事件包，那么你能添加或移除文件。
具體步驟如下：
1：創(chuàng)建一個(gè)邏輯包：使用命令是ips create package。該命令可以創(chuàng)建一個(gè)空包，也可以能會創(chuàng)建自動包含診斷數(shù)據(jù)的包。這個(gè)命令有很多
變量，你可以選擇創(chuàng)建某一特定問題號，事件號，問題關(guān)鍵字，或基于期間的包。
2：添加診斷數(shù)據(jù)到邏輯包：這是一個(gè)可選步驟，如果你在第一步創(chuàng)建的是一個(gè)空包，那么你可以使用這一步驟添加診斷文件或數(shù)據(jù)。
3：產(chǎn)生zip文件：可以增量添加文件到zip文件里。


我們也可以通過ADRCI工具來找到跟蹤文件，如下：

adrci> show incident

ADR Home = /u01/app/oracle/diag/rdbms/huateng/huateng:
*************************************************************************
INCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME                              
-------------------- ----------------------------------------------------------- ----------------------------------------
11041                ORA 7445 [kslgetl()+18]                                     2012-08-01 23:32:13.324000 +08:00       
19306                ORA 1578                                                    2012-08-06 19:28:42.011000 +08:00       
19354                ORA 1578                                                    2012-08-06 19:29:01.932000 +08:00       
19355                ORA 1578                                                    2012-08-06 19:29:09.383000 +08:00       
19356                ORA 1578                                                    2012-08-06 19:29:28.922000 +08:00       
25414                ORA 600 [2252]                                              2012-08-07 23:25:03.801000 +08:00       
25454                ORA 600 [2252]                                              2012-08-07 23:25:09.263000 +08:00       
25462                ORA 600 [2252]                                              2012-08-07 23:25:10.793000 +08:00       
25415                ORA 600 [2252]                                              2012-08-07 23:25:11.049000 +08:00       
25416                ORA 600 [2252]                                              2012-08-07 23:25:17.087000 +08:00       
34962                ORA 600 [2608]                                              2012-08-14 11:26:16.424000 +08:00       
42163                ORA 600 [3688]                                              2012-08-16 05:13:34.745000 +08:00       
66276                ORA 4031                                                    2012-11-05 23:39:23.913000 +08:00       
66277                ORA 4031                                                    2012-11-05 23:44:37.593000 +08:00       
66284                ORA 4031                                                    2012-11-05 23:49:24.553000 +08:00       
15 rows fetched

adrci> show trace -i 11041

Output the results to file: /tmp/utsout_9769_308617_2.ado

/u01/app/oracle/diag/rdbms/huateng/huateng/incident/incdir_11041/huateng_ora_13543_i11041.trc
----------------------------------------------------------
LEVEL PAYLOAD                                                                                                                                         
----- ------------------------------------------------------------------------------------------------------------------------------------------------
      Dump file /u01/app/oracle/diag/rdbms/huateng/huateng/incident/incdir_11041/huateng_ora_13543_i11041.trc
      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      ORACLE_HOME = /u01/app/oracle/product/db11gr2
      System name:      Linux
      Node name:        db2server
      Release:  2.6.18-92.el5
      Version:  #1 SMP Tue Jun 10 18:49:47 EDT 2008
      Machine:  i686
      Instance name: huateng
      Redo thread mounted by this instance: 1
      Oracle process number: 30
      Unix process pid: 13543, p_w_picpath: oracle@db2server (TNS V1-V3)


      *** 2012-08-01 23:32:13.444
      *** SESSION ID:(49.13) 2012-08-01 23:32:13.444
      *** CLIENT ID:() 2012-08-01 23:32:13.444
      *** SERVICE NAME:(SYS$USERS) 2012-08-01 23:32:13.444
      *** MODULE NAME:(sqlplus@db2server (TNS V1-V3)) 2012-08-01 23:32:13.444
      *** ACTION NAME:() 2012-08-01 23:32:13.444

      Dump continued from file: /u01/app/oracle/diag/rdbms/huateng/huateng/trace/huateng_ora_13543.trc
1>     ***** Error Stack *****
       ORA-07445: exception encountered: core dump [kslgetl()+18] [SIGSEGV] [ADDR:0x600075F8] [PC:0xF052F62] [Address not mapped to object] []
1<     ***** Error Stack *****
1>     ***** Dump for incident 11041 (ORA 7445 [kslgetl()+18]) *****
2>      ***** Beginning of Customized Incident Dump(s) *****
        Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x600075F8] [PC:0xF052F62, kslgetl()+18] [flags: 0x0, count: 1]
        Registers:
        %eax: 0x600075f0 %ebx: 0x00000000 %ecx: 0x0f052f50
        %edx: 0x00000000 %edi: 0x600075f0 %esi: 0x00000001
        %esp: 0xbfa8a5f4 %ebp: 0xbfa8a604 %eip: 0x0f052f62
        %efl: 0x00010282
 
 
 
 
        

1.使用“ips create package”創(chuàng)建一個(gè)新的邏輯包
1）進(jìn)入到adrci命令行界面


ADRCI: Release 11.2.0.1.0 - Production on 星期二 2月 1 11:01:28 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

ADR base = "/u01/oracle"

2）嘗試創(chuàng)建邏輯包
adrci> ips create package;
DIA-48448: This command does not support multiple ADR homes




修改adrci目錄:      
        
adrci> show homes
ADR Homes:
diag/clients/user_oracle/host_2467386799_76
diag/tnslsnr/biserver/orcl
diag/tnslsnr/biserver/listener
diag/rdbms/orcl/orcl

3）這里我們選擇diag/rdbms/orcl/orcl

adrci> set homepath diag/rdbms/orcl/orcl

4）確認(rèn)只有一個(gè)home


5）再次嘗試創(chuàng)建邏輯包，成功。
adrci> ips create package;
Created package 1 without any contents, correlation level typical

6）將診斷數(shù)據(jù)添加到剛剛創(chuàng)建的邏輯包中
將系統(tǒng)中出現(xiàn)的53475 事件添加到邏輯包1中，在系統(tǒng)中可以使用show incident命令獲得incident號。
adrci> ips add incident 53475 package 1;
Added incident 53475 to package 1

7）生成物理包
adrci> ips generate package 1 in /export/home/oracle

Generated package 1 in file /export/home/oracle/IPSPKG_20110201110631_COM_1.zip, mode complete

8）簡單查看一下解壓后的文件目錄?？梢奜racle在壓縮包中自動采集了很多相關(guān)信息。

-bash-3.00$ unzip  IPSPKG_20110201110631_COM_1.zip
Archive:  IPSPKG_20110201110631_COM_1.zip
  inflating: diag/rdbms/orcl/orcl/incpkg/pkg_1/seq_1/export/IPS_CONFIGURATION.dmp
  inflating: diag/rdbms/orcl/orcl/incpkg/pkg_1/seq_1/export/IPS_PACKAGE.dmp
  inflating: diag/rdbms/orcl/orcl/incpkg/pkg_1/seq_1/export/IPS_PACKAGE_INCIDENT.dmp
  inflating: diag/rdbms/orcl/orcl/incpkg/pkg_1/seq_1/export/IPS_PACKAGE_FILE.dmp
  inflating: diag/rdbms/orcl/orcl/incpkg/pkg_1/seq_1/export/IPS_PACKAGE_HISTORY.dmp
  inflating: diag/rdbms/orcl/orcl/incpkg/pkg_1/seq_1/export/IPS_FILE_METADATA.dmp
  inflating: diag/rdbms/orcl/orcl/incpkg/pkg_1/seq_1/export/IPS_FILE_COPY_LOG.dmp
 .......
 .....
 
 
 
 
5.小結(jié)
使用ADRCI (ADR Command Interface)完成整個(gè)故障打包的過程是很便利的。這既方便了自己也方便了Oracle的support人員。

讓客戶滿意是我們工作的目標(biāo)，不斷超越客戶的期望值來自于我們對這個(gè)行業(yè)的熱愛。我們立志把好的技術(shù)通過有效、簡單的方式提供給客戶，將通過不懈努力成為客戶在信息化領(lǐng)域值得信任、有價(jià)值的長期合作伙伴，公司提供的服務(wù)項(xiàng)目有：域名與空間、網(wǎng)頁空間、營銷軟件、網(wǎng)站建設(shè)、烏海網(wǎng)站維護(hù)、網(wǎng)站推廣。

文章標(biāo)題：Oracle事件打包服務(wù)(IncidentPackagingService,IPS)
本文鏈接：http://bm7419.com/article40/jjceho.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供做網(wǎng)站、電子商務(wù)、手機(jī)網(wǎng)站建設(shè)、企業(yè)建站、Google、網(wǎng)站導(dǎo)航

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)

網(wǎng)站優(yōu)化排名