Shulou(Shulou.com)06/01 Report--

Packaging incidents (Packaging event)

A powerful tool for oracle 11g is packaging events. Use the support that this compressed folder of packaged events is submitted to oracle to help solve the analysis problem.

Once you create an event package, one or more related questions will be added to the package file. It includes trace file, dump file and so on.

By default, the event package for each question includes only the first and last three events. The event package contains all the events that can be used for diagnosis. You can also specify the time or number of events that occur

Measure the range to pack.

Once you have created the event package, you can add or remove files.

The specific steps are as follows:

1: create a logical package: the command to use is ips create package. This command can create an empty package or a package that automatically contains diagnostic data. There are many orders.

Variable, you can choose to create a specific problem number, event number, question keyword, or period-based package.

2: add diagnostic data to the logical package: this is an optional step. If you created an empty package in the first step, you can use this step to add diagnostic files or data.

3: generate zip files: you can incrementally add files to zip files.

We can also find the trace file through the ADRCI tool, as follows:

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 purl 32 purl 13.324000 + 08:00

19306 ORA 1578 2012-08-06 1928 purl 42.011000 + 08:00

19354 ORA 1578 2012-08-06 19 1929 purl 01.932000 + 08:00

19355 ORA 1578 2012-08-06 19 1929 purl 09.383000 + 08:00

19356 ORA 1578 2012-08-06 1929 purl 28.922000 + 08:00

25414 ORA 600 [2252] 2012-08-07 23 purl 25purl 03.801000 + 08:00

25454 ORA 600 [2252] 2012-08-07 23 purl 25purl 09.263000 + 08:00

25462 ORA 600 [2252] 2012-08-07 23 purl 25purl 10.793000 + 08:00

25415 ORA 600 [2252] 2012-08-07 23 purl 25purl 11.049000 + 08:00

25416 ORA 600 [2252] 2012-08-07 23 purl 2517.087000 + 08:00

34962 ORA 600 [2608] 2012-08-14 1115 26 purl 16.424000 + 08:00

42163 ORA 600 [3688] 2012-08-16 05PUBG 13 ORA 34.745000 + 08:00

66276 ORA 4031 2012-11-05 23 39 purl 23.913000 + 08:00

66277 ORA 4031 2012-11-05 23 44 purl 37.593000 + 08:00

66284 ORA 4031 2012-11-05 23 23 49 purl 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 purl 13.444

* SESSION ID: (49.13) 2012-08-01 2315 3215 13 444

* CLIENT ID: () 2012-08-01 23 purl 3213.444

* SERVICE NAME: (SYS$USERS) 2012-08-01 23 32 13 444

* MODULE NAME: (sqlplus@db2server (TNS V1-V3)) 2012-08-01 23 Fran 32 13. 444

* ACTION NAME: () 2012-08-01 23 purl 3213.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] []

one

* 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. Create a new logical package using "ips create package"

1) enter the adrci command line interface

ADRCI: Release 11.2.0.1.0-Production on Tuesday February 1 11:01:28 2011

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

ADR base = "/ u01/oracle"

2) try to create a logical package

Adrci > ips create package

DIA-48448: This command does not support multiple ADR homes

Modify the adrci directory:

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) here we choose diag/rdbms/orcl/orcl

Adrci > set homepath diag/rdbms/orcl/orcl

4) confirm that there is only one home

5) try to create a logical package again, successfully.

Adrci > ips create package

Created package 1 without any contents, correlation level typical

6) add diagnostic data to the logical package you just created

Add the 53475 event that appears in the system to logical package 1, where you can use the show incident command to get the incident number.

Adrci > ips add incident 53475 package 1

Added incident 53475 to package 1

7) generate physical package

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) take a brief look at the extracted file directory. It can be seen that Oracle automatically collects a lot of relevant information in the compressed package.

-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. Summary

It is convenient to use ADRCI (ADR Command Interface) to complete the whole fault packaging process. This is convenient both for yourself and for the support staff of Oracle.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.