ADRCI used IPS package for upload the incident and problems

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 Packgage 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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.