Create an Incident Package with ADRCI and IPS Commands

Oracle Automatic Diagnostic Repository (ADR).

adrci> show homes
ADR Homes:
diag/clients/user_oracle/host_772540587_80
diag/clients/user_oracle/host_3968884957_80
diag/clients/user_tkyte/host_3968884957_80
diag/rdbms/orcl/orcl
diag/rdbms/nvtxdb/nvtxdb
diag/rdbms/ora11g/ora11g
diag/tnslsnr/oracle_home/listener
diag/tnslsnr/oraclehome/listener
diag/tnslsnr/localhost/listener
adrci>
adrci>
adrci>  set homepath diag/rdbms/nvtxdb/nvtxdb
adrci>
adrci>
adrci> show home
ADR Homes:
diag/rdbms/nvtxdb/nvtxdb
adrci>
adrci> show incident

ADR Home = /home/oracle/u01/app/oracle/diag/rdbms/nvtxdb/nvtxdb:
*************************************************************************
INCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
55713                ORA 7445 [kglic0()+1086]                                    2013-11-16 01:30:37.246000 +05:30
1 rows fetched

adrci>
adrci>
adrci> ips pack incident 55713 in /home/oracle
Generated package 1 in file /home/oracle/ORA7445kg_20140624172237_COM_1.zip, mode complete
adrci>

-bash-3.2$ du -ksh ORA7445kg_20140624172237_COM_1.zip
32M     ORA7445kg_20140624172237_COM_1.zip

This statement lists the names of all trace files related to incident number 55713:

adrci> SHOW TRACEFILE -I 55713
diag/rdbms/nvtxdb/nvtxdb/incident/incdir_55713/nvtxdb_m000_20985_i55713.trc

http://www.dba-oracle.com/t_11g_new_ADRCI_IPS.htm

How to monitor alert logs using adrci?

SHOW ALERT
SHOW ALERT -TAIL
SHOW ALERT -TAIL -F

http://docs.oracle.com/cd/B28359_01/server.111/b28319/adrci.htm#BABBHGFC

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s