Administration
IPS : Incident Packaging Service
User Rating: 
/ 0
- Details
-
Parent Category: Articles
-
Created on Sunday, 21 March 2010 19:39
-
Last Updated on Friday, 27 September 2013 15:19
-
Published on Sunday, 21 March 2010 19:39
-
Written by Guy Lambregts
-
Hits: 7742
IPS : Incident Packaging Service.
The Incident Package Service : IPS is an extension of Automatic Diagnostic Repository : ADR
An IPS package is a packaging of diagnostic data in order to be send to Oracle Support Services
1. can package diagnostic data in the ADR related to a specific incident
2. can package diagnostic data in the ADR related to a specific problem
3. can package diagnostic data in the ADR related to incidents occured in a time interval
The physical package is zipped together, the goal is packaging of diagnostic data and --- have it sent --- send to Oracle Support Services
One can use IPS using Oracle Enterprise Manager. If the Metalink Credentials are properly configured the packaged diagnostic information can easily be sent to Oracle Support Services.
The command line interface is called ADRCI : ADR Command Interpreter
I post some ADR gym, rather easy to understand.
C:\Windows\system32>ADRCI
ADRCI: Release 11.1.0.7.0 - Production on Thu May 28 21:11:38 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ADR base = "c:\oracle\product\11.1.0"
adrci> help
HELP [topic]
Available Topics:
CREATE REPORT
ECHO
EXIT
HELP
HOST
IPS
PURGE
RUN
SET BASE
SET BROWSER
SET CONTROL
SET ECHO
SET EDITOR
SET HOMES | HOME | HOMEPATH
SET TERMOUT
SHOW ALERT
SHOW BASE
SHOW CONTROL
SHOW HM_RUN
SHOW HOMES | HOME | HOMEPATH
SHOW INCDIR
SHOW INCIDENT
SHOW PROBLEM
SHOW REPORT
SHOW TRACEFILE
SPOOL
There are other commands intended to be used directly by Oracle, type
"HELP EXTENDED" to see the list
adrci> SHOW HOMES;
ADR Homes:
diag\rdbms\cait11\cait11
diag\rdbms\palladium\palladium
diag\rdbms\platinum\platinum
adrci> set homepath diag\rdbms\platinum\platinum
adrci> SHOW HOMES;
ADR Homes:
diag\rdbms\platinum\platinum
adrci> show incident
ADR Home = c:\oracle\product\11.1.0\diag\rdbms\platinum\platinum:
INCIDENT_ID PROBLEM_KEY
CREATE_TIME
----------------------------------------
3258 ORA 4031
2008-12-23 21:09:22.048000 +01:00
3257 ORA 4031
2008-12-23 21:09:15.947000 +01:00
2523 ORA 4031
2008-12-23 21:09:23.067000 +01:00
2522 ORA 4031
2008-12-23 21:09:19.305000 +01:00
2521 ORA 4031
2008-12-23 21:09:16.221000 +01:00
5 rows fetched
adrci> ips pack incident 3258 IN C:\oracle\ADR
Generated package 1 in file C:\oracle\ADR\ORA4031_20090528212900_COM_1.zip, mode complete
/* creation of a LOGICAL package */
/* create package based on incident key */
adrci> ips create package incident 3258;
Created package 2 based on incident id 3258, correlation level typical
/* create an empty package */
adrci> ips create package;
Created package 6 without any contents, correlation level typical
adrci> show incident -mode detail -p "incident_id=3258"
ADR Home = c:\oracle\product\11.1.0\diag\rdbms\platinum\platinum:
INCIDENT INFO RECORD 1
INCIDENT_ID 3258
STATUS ready
CREATE_TIME 2008-12-23 21:09:22.048000 +01:00
PROBLEM_ID 1
CLOSE_TIME <NULL>
FLOOD_CONTROLLED none
ERROR_FACILITY ORA
ERROR_NUMBER 4031
ERROR_ARG1 3904
ERROR_ARG2 shared pool
ERROR_ARG3 DBMS_RCVMAN
ERROR_ARG4 PL/SQL MPCODE
ERROR_ARG5 BAMIMA: Bam Buffer
ERROR_ARG6 <NULL>
ERROR_ARG7 <NULL>
ERROR_ARG8 <NULL>
SIGNALLING_COMPONENT <NULL>
SIGNALLING_SUBCOMPONENT <NULL>
SUSPECT_COMPONENT <NULL>
SUSPECT_SUBCOMPONENT <NULL>
ECID <NULL>
IMPACTS 0
PROBLEM_KEY ORA 4031
FIRST_INCIDENT 3257
FIRSTINC_TIME 2008-12-23 21:09:15.947000 +01:00
LAST_INCIDENT 4035
LASTINC_TIME 2008-12-23 21:16:30.178000 +01:00
IMPACT1 34668547
IMPACT2 34668546
IMPACT3 0
IMPACT4 0
KEY_NAME Client ProcId
KEY_VALUE ORACLE.EXE.5168_4364
KEY_NAME SID
KEY_VALUE 115.9
KEY_NAME ProcId
KEY_VALUE 7.5
KEY_NAME PQ
KEY_VALUE (16777235, 1230062961)
OWNER_ID 1
INCIDENT_FILE c:\oracle\product\11.1.0\diag\rdbms\platinum\platinum\trace\platinum_ora_4364.trc
OWNER_ID 1
INCIDENT_FILE c:\oracle\product\11.1.0\diag\rdbms\platinum\platinum\incident\incdir_3258\platinum_ora_4364_i3258.trc
1 rows fetched
/* create package based on problem key */
adrci> ips create package problemkey "ORA 4031"
Created package 3 based on problem key ORA 4031, correlation level typical
adrci> ips create package seconds 36000
Created package 4 based on last 36000 seconds, correlation level typical
adrci> ips create package seconds 36000 correlate all;
Created package 5 based on last 36000 seconds, correlation level all
adrci> ips create package time '2008-12-01 01:00:00' to '2009-05-01 01:00:00';
Created package 5 based on time range 2008-12-01 01:00:00.000000 +02:00 to 2009-
05-01 01:00:00.000000 +02:00, correlation level typical
adrci> ips show incidents package 2;
INCIDENT INFORMATION:
INCIDENT_ID 3258
PROBLEM_ID 1
EXCLUDE 0
Correlated INCIDENTS
INCIDENT INFORMATION:
INCIDENT_ID 2521
PROBLEM_ID 1
EXCLUDE 0
INCIDENT INFORMATION:
INCIDENT_ID 2522
PROBLEM_ID 1
EXCLUDE 0
INCIDENT INFORMATION:
INCIDENT_ID 2523
PROBLEM_ID 1
EXCLUDE 0
INCIDENT INFORMATION:
INCIDENT_ID 3257
PROBLEM_ID 1
EXCLUDE 0
/* add manually an incident to a previously created package */
adrci> ips add incident 10000 package 1;
DIA-49431: No such incident 10000
/* creation of a PHYSICAL package */
adrci> ips generate package 2 in C:\oracle\ADR
Generated package 2 in file C:\oracle\ADR\ORA4031_20090528213247_COM_1.zip, mode complete
