User`s guide
Automatic Diagnostic Repository
5-6 Oracle Database Installation and Administration Guide
5. Execute SQL*Plus on the remote computer and connect as user
sys
to a server of
the instance you want to startup. In the following example, which shows the
commands for SQL*Plus on a UNIX client, we use the net service name orcl_on_
bs2000 to address the remote instance on the BS2000 computer:
sqlplus /nolog
SQL> connect sys@orcl_on_bs2000 as sysdba
Enter password:
password
Connected
SQL> startup
...
5.4 Automatic Diagnostic Repository
Automatic Diagnostic Repository (ADR) is a file-based hierarchical data store for
depositing diagnostic information produced by diagnostic framework clients. The
repository contains data describing incidents, traces, dumps, alert logs, health check
records, SQL Trace information, and other information essential for problem diagnosis.
See Also: "Managing Diagnostic Data" in Oracle Database
Administrators Guide for more information about Automatic Diagnostic
Repository
This section describes the following:
■ Automatic Diagnostic Repository Directories and Files
■ ADR Command Interpreter
5.4.1 Automatic Diagnostic Repository Directories and Files
Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside
of the database. It is therefore available for problem diagnosis when the database is
down.
The directories and files of the Automatic Diagnostic Repository are stored in the
PO
SIX file system.
See Also: Oracle Database Administrator's Guide for information
about the directory structure
The ADR root directory is known as ADR bas
e. Its location is set by the
DIAGNOSTIC_
DEST
initialization parameter. For example:
DIAGNOSTIC_DEST=/u01/app/orac1120/oradata/adr
If this parameter is omitted or left null, then the database sets
DIAGNOSTIC_DEST
upon
startup as follows:
■ If environment variable
ORACLE_BASE
is set, then
DIAGNOSTIC_DEST
is set to the
directory designated by
ORACLE_BASE
.
■ If environment variable
ORACLE_BASE
is not set, then
DIAGNOSTIC_DEST
is set to
ORACLE_HOME/log
.