19 | 08 | 2017
Latest Articles
Popular Articles

Administration

IPS : Incident Packaging Service

User Rating:  / 0
PoorBest 

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