advertisements
_____________________________________________________________________________________________________________________
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
adrci> ips generate package 2 in /home/oracle/scott INCREMENTAL
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment