ADRCI used for IPS package upload the incident and problems in Oracle

Automatic Diagnostic Repository (ADR) uses in Oracle 11g and above version for creating IPS(Incident Packaging Services) package to upload in oracle support for help. It easy the process for upload the trace files need for incident rather than do it manually one by one file. Its save time.

Steps for using automatic diagnostic tool (ADRCI) for generating IPS Package for used in oracle support

1. Go to command windows and used adrci command:

C:\Windows\System32\config\systemprofile>adrci
ADRCI: Release 12.1.0.2.0 - Production on Wed Mar 29 05:04:40 2017
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
ADR base = "E:\oracle"
adrci>

2. List the oracle home present by show home command:

adrci> show home
ADR Homes:home
diag\rdbms\ic\ic
diag\tnslsnr\IC\listener

3. Select the home with set homepath command:

adrci> set homepath diag\rdbms\ic\ic

4. For list all the problem going, please run show problem command:

adrci> show problem

ADR Home = E:\oracle\diag\rdbms\ic\ic:
************************************************************
PROBLEM_ID PROBLEM_KEY  LAST_INCIDENT LASTINC_TIME
---------- ------------ ------------- ---------------------------------
3          ORA 600[723] 246517        2017-03-10 21:14:18.539000 -05:00
2          ORA 445      243935        2017-03-11 06:06:54.406000 -05:00
1          ORA 4030     283042        2017-03-23 02:25:05.963000 -04:00

5. Show all incident and specific incident with following commands:

--Show all incident on at home:
ardci> show incident

--If you want for specific problem then enter define problem key:
adrci> show incident -p "problem_key='ORA 4030'"

ADR Home = E:\oracle\diag\rdbms\ic\ic:
*********************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
----------- ----------- -----------------------------
235513      ORA 4030    2017-03-02 22:00:05.502000 -05:00
235401      ORA 4030    2017-03-02 22:00:05.861000 -05:00
235402      ORA 4030    2017-03-02 22:00:11.002000 -05:00

6. Create package for specific incident id for upload on oracle support.
Note: specify the path and incident number for creating package.

adrci> ips pack incident 235402 in E:\patch_backup
Generated package 2 in file E:\patch_backup\ORA4030_20170329050754_COM_1.zip, mode complete