Oracle 11g : ADRCI

Allows interaction with ADR from OS prompt

• Can invoke IPS with command line instead of EM
• DBAs should use EM Support Workbench:
• Leverages same toolkit/libraries that ADRCI is built upon
• Easy to follow GUI

 ADRCI> show incident

ADR Home = /u01/app/oracle/product/11.1.0/db_1/log/diag/rdbms/test/test:

****************************************************************************************

INCIDENT_ID PROBLEM_KEY CREATE_TIME

------------ -------------------------------------- ---------------------------------

1681 ORA-600_dbgris01:1,_addr=0xa9876541 17-May-12 09.17.44.843125000

 1682 ORA-600_dbgris01:12,_addr=0xa9876542 18-May-12 09.18.59.434775000

 2 incident info records fetched

ADRCI>

SQL> SELECT * FROM V$DIAG_INFO;

NAME VALUE

------------------- ---------------------------------------------------------------

Diag Enabled TRUE

ADR Base /u01/app/oracle

ADR Home /u01/app/oracle/diag/rdbms/test/test

Diag Trace /u01/app/oracle/diag/rdbms/test/test/trace

Diag Alert /u01/app/oracle/diag/rdbms/test/test/alert

Diag Incident /u01/app/oracle/diag/rdbms/test/test/incident

Diag Cdump /u01/app/oracle/diag/rdbms/test/test/cdump

Health Monitor /u01/app/oracle/diag/rdbms/test/test/hm

Default Trace File /u01/app/oracle/diag/rdbms/test/test/trace/orcl_ora_11424.trc

Active Problem Count 3

Active Incident Count 8

adrci>>show alert -tail

ADR Home = /u01/app/oracle/diag/rdbms/test/test:

*************************************************************************

2007-04-16 22:10:50.756000 -07:00

ORA-1654: unable to extend index SYS.I_H_OBJ#_COL# by 128 in tablespace

SYSTEM

2007-04-16 22:21:20.920000 -07:00

Thread 1 advanced to log sequence 400

Current log# 3 seq# 400 mem# 0: +DATA/orcl/onlinelog/group_3.266.618805031

Current log# 3 seq# 400 mem# 1: +DATA/orcl/onlinelog/group_3.267.618805047

Thread 1 advanced to log sequence 401

Current log# 1 seq# 401 mem# 0: +DATA/orcl/onlinelog/group_1.262.618804977

Current log# 1 seq# 401 mem# 1: +DATA/orcl/onlinelog/group_1.263.618804993

DIA-48223: Interrupt Requested - Fetch Aborted - Return Code [1]

adrci>>

adrci>>SHOW ALERT -P "MESSAGE_TEXT LIKE '%ORA-600%'"

ADR Home = /u01/app/oracle/diag/rdbms/test/test:

*************************************************************************