About Oracle 11g alert files

A First, introduce 2 words

Automatic Diagnostic Repository (ADR)-

A directory of database diagnostic logs and trace files, called ADR base, corresponding to initialization parameter diagnostic_dest,

If you set the ORACLE_BASE environment variable, diagnostic_dest equals Oracle_base,

If Oracle_base is not set, wait with Oracle_home/log.

Sql> Show Parameter Diag

NAME TYPE VALUE

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

Diagnostic_dest string/oracle/app/oracle

......

Adrci command-line Utility command line tool

Use this tool to view logs, track information, and view health reports.

[Oracle@ora1 ~]$ Adrci

Adrci:release 11.2.0.1.0-production on Sat June 10 18:47:33 2010

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

ADR base = "/oracle/app/oracle"

Adrci>?

Dia-48415:syntax error found in string [?

] at column [2]

Adrci> Help

Help [Topic]

Available Topics:

CREATE A

ECHO

EXIT

Help

HOST

Ips

PURGE

RUN

SET BASE

SET BROWSER

SET Control

SET ECHO

SET EDITOR

SET Homes | Home | HomePath

SET Termout

Show ALERT

Show BASE

Show control

Show Hm_run

Show Homes | Home | HomePath

Show Incdir

Show INCIDENT

Show PROBLEM

Show

Show Tracefile

SPOOL

There are commands intended to is used directly by Oracle, type

"Help EXTENDED" to the list