oracle@myhost:[PRODDB01]# adrci ADRCI: Release 11.2.0.4.0 - Production on Wed May 28 15:06:44 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. ADR base = "/u01/oracle"Display which homes that exists, and set the homelocation to point to the database's home:
adrci> show homes ADR Homes: diag/rdbms/PRODDB01/PRODDB01 diag/tnslsnr/myhost/listener adrci> set home diag/rdbms/PRODDB01/PRODDB01Tail the log:
adrci> show alert -tail -fOther handy comments related to the alert log:
show alert show alert -tail 50 show alert -p "module_id='DBMS_SCHEDULER'" show alert -p "module_id != 'DBMS_SCHEDULER'" show alert -p "module_id LIKE '%SCHEDULER%'"If you want to extract the Streams related statements from the alert log, you would use:
show alert -p "message_text like '%STREAM%'"
See also this post for searching in adr using adrci
No comments:
Post a Comment