Thursday, May 12, 2011

ADR File Based Repository Hands On

oracle@vmxdb01:/home/oracle:[ORCL] adrci help=y
Syntax:
adrci [-help] [script=script_filename]
[exec = "one_command [;one_command;...]"]

Options Description (Default)
-----------------------------------------------------------------
script script file name (None)
help help on the command options (None)
exec exec a set of commands (None)
-----------------------------------------------------------------

oracle@vmxdb01:/home/oracle:[ORCL] adrci

ADRCI: Release 11.2.0.2.0 - Production on Thu May 12 11:02:31 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

ADR base = "/ORCL/oradata/admin"

adrci> show alert

adrci> show alert -tail 20

adrci> show alert -tail

adrci> show alert -tail -f

adrci> show alert -tail 200 -f

adrci> show alert -p "message_text like '%ORA-%'"


adrci> spool /tmp/ora-04031.log
adrci> SHOW ALERT -p "MESSAGE_TEXT LIKE '%ORA-04031%'" -TERM

ADR Home = /ORCL/oradata/admin/diag/rdbms/ORCL/ORCL:
*************************************************************************
2011-04-20 10:13:52.622000 +08:00
Errors in file /ORCL/oradata/admin/diag/rdbms/ORCL/ORCL/trace/ORCL_m001_6422582.trc (incident=19401):
ORA-04031: unable to allocate 3976 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","work area tab")
ORA-04031: unable to allocate 3976 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","work area tab")
ORA-04031: unable to allocate 3976 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","work area tab")
ORA-04031: unable to allocate 3976 bytes of shared memory ("shared p
adrci> spool off

adrci> show tracefile

Download the full version here: Click Me