ADRCI alert
Log into the oracle user.
Set Oracle database environment, using
. oraenv
Start the ADR command line interpreter(ADRCI) by issuing the following command in the database directory:
adrci
ADRCI: Release 11.2.0.2.0
ADR base = "/ora01/oracle"
adrci> show homes
ADR Homes:
diag/rdbms/demo/demo ß oracle instance
diag/tnslsnr/lnx100/listener ß listener
diag/asm/+asm/+ASM ß ASM
adrci> set home diag/rdbms/demo/demo
adrci> show homes
ADR Homes:
diag/rdbms/demo/demo
adric> show incdir
adrci> show incident # This will show all the incident
adrci> show problem # This will show problem. There can be number of incident in a problem
ADR Home = /ora01/oracle/diag/rdbms/demo/demo:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
2 ORA 600 [audxpl:invalid action] 39882 2010-09-02 08:09:33.992000 -04:00
1 ORA 4031 161 2010-08-18 15:42:05.051000 -04:00
2 rows fetched
Collect Trace and alert log file
Collect information and prepare to send to Oracle Support, in case there is a problem
adrci> ips create package problemkey "ORA 4031"
Created package 1 based on problem key ORA 4031, correlation level typical
adrci> ips generate package 1 in /tmp
Generated package 1 in file /tmp/ORA4031_20100915163145_COM_1.zip, mode complete
adrci> query ips_package
adrci> exit
lnx100:/ora01/oracle/admin/demo/demo $ cd /tmp
lnx100:/tmp $ ls -l /tmp/ORA4031_20100915163145_COM_1.zip
-rw-r--r-- 1 oracle oinstall 6852768 Sep 15 16:32 /tmp/ORA4031_20100915163145_COM_1.zip
Useful links
