Oracle 11g ADRCI – How to Create Package for an Incident or a Problem?

Using ADRCI utility we can create package for a particular incident or problem. This package can be uploaded to oracle metalink support for further diagnosis of the problem. Here are the steps to create a package using ADRCI tool

$ adrci

ADRCI: Release 11.1.0.7.0 - Production on Wed Aug 3 04:10:14 2011


Copyright (c) 1982, 2007, Oracle.  All rights reserved.

ADR base = "/data/oracle/admin/prod9"
adrci> show incident

ADR Home = /data/oracle/admin/prod9/diag/rdbms/prod9/prod9:
*************************************************************************
INCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
96273                ORA 600 [kzsviver:4]                                        2011-07-26 01:19:13.656023 -07:00
76993                ORA 600 [kpotcgah-7]                                        2011-07-15 21:24:45.168636 -07:00
67393                ORA 600 [kpotcgah-7]                                        2011-07-15 21:23:21.558570 -07:00
38593                ORA 600 [kpotcgah-7]                                        2011-07-15 21:14:39.926067 -07:00
29012                ORA 600                                                     2011-07-15 10:12:40.718673 -07:00
29011                ORA 600 [kpotcgah-7]                                        2011-07-15 10:12:31.447684 -07:00
29010                ORA 600                                                     2011-07-15 10:12:19.482870 -07:00
29009                ORA 600 [kpotcgah-7]                                        2011-07-15 10:11:06.247114 -07:00
28976                ORA 600                                                     2011-07-15 10:17:33.285385 -07:00
28974                ORA 600                                                     2011-07-15 10:16:33.013877 -07:00
28972                ORA 600                                                     2011-07-15 10:15:41.681809 -07:00
28971                ORA 600 [kpotcgah-7]                                        2011-07-15 10:15:32.137271 -07:00
28970                ORA 600 [kpotcgah-7]                                        2011-07-15 10:15:05.756256 -07:00
28969                ORA 600 [kpotcgah-7]                                        2011-07-15 10:11:05.401734 -07:00
14 rows fetched

I have 14 incidents in my database and I am going to create incident package for incident 96273

adrci> IPS CREATE PACKAGE INCIDENT 96273
Created package 1 based on incident id 96273, correlation level typical

The package number assigned to this logical package is 1

You can create a package for a problem with following command

adrci> IPS CREATE PACKAGE PROBLEM_ID
adrci> IPS CREATE PACKAGE 2
You can create a package with reference to the problemkey
adrci> IPS CREATE PACKAGE PROBLEMKEY “problem_key”
adrci> IPS CREATE PACKAGE PROBLEMKEY ‘ORA 600 [kzsviver:4]’

The problem key must be enclosed in single quote (‘) or double quotes (“) if it contains spaces or quotes.

You can create time specific packages also.
adrci> IPS CREATE PACKAGE PROBLEMKEY ‘start_time’ to ‘end_time’

Add related files to problem package

adrci> ips add file /data/oracle/admin/prod9/diag/rdbms/prod9/prod9/trace/prod9_m000_7829.trc package 2
Added file /data/oracle/admin/prod9/diag/rdbms/prod9/prod9/trace/prod9_m000_7829.trc to package 2

Add alert log file
adrci> ips add file /data/oracle/admin/prod9/diag/rdbms/prod9/prod9/trace/alert_prod9.log package 2
Added file /data/oracle/admin/prod9/diag/rdbms/prod9/prod9/trace/alert_prod9.log to package 2

Now you can generate package to a specific directory. The package will be in zip format.
adrci>  ips generate package <package number> in <path>
adrci>  ips generate package 2 in /home/oracle/scott

Generated package 2 in file /home/oracle/scott/ORA600kzs_20110803042544_COM_1.zip, mode complete

Suppose if you wanted to create incremental package for a particular package you can use this command.

adrci>  ips generate package <package number> in <path> INCREMENTAL
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google