40 - [Oracle 19C] Automatic Diagnostic Repository (ADR)

 

 

Typical installations will have the ADR_BASE set to the ORACLE_BASE

[oracle@test ~]$ echo $ORACLE_BASE

/u01/app/oracle

• You can make sure from parameter diagnostic_dest

• The ADR home path is "/u01/app/oracle/diag/rdbms/orcl/orcl"

 

 

 

SQL> show parameter diagnostic_dest

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest 		     string	 /u01/app/oracle
SQL>

 

 

 

/u01/app/oracle/diag/rdbms/orcl/orcl
[oracle@test orcl]$ ll
합계 108
drwxr-x--- 2 oracle oinstall    21 11월 11 00:59 alert
drwxr-x--- 2 oracle oinstall     6 11월 11 00:59 cdump
drwxr-x--- 2 oracle oinstall     6 11월 11 00:59 hm
drwxr-x--- 2 oracle oinstall     6 11월 11 00:59 incident
drwxr-x--- 2 oracle oinstall     6 11월 11 00:59 incpkg
drwxr-x--- 2 oracle oinstall     6 11월 11 00:59 ir
drwxr-x--- 2 oracle oinstall  4096 11월 11 01:00 lck
drwxr-x--- 8 oracle oinstall   103 11월 11 00:59 log
drwxr-x--- 2 oracle oinstall  4096 11월 11 01:00 metadata
drwxr-x--- 2 oracle oinstall     6 11월 11 00:59 metadata_dgif
drwxr-x--- 2 oracle oinstall     6 11월 11 00:59 metadata_pv
drwxr-x--- 2 oracle oinstall     6 11월 11 00:59 stage
drwxr-x--- 2 oracle oinstall     6 11월 11 00:59 sweep
drwxr-x--- 2 oracle oinstall 65536 11월 23 15:47 trace
[oracle@test orcl]$

 

 

 

• The alert log

The alert log is a chronological log of messages and errors, and includes the following items:
- Any non default initialization parameter used at startup.
- All internal errors (ORA-00600), block corruption errors (ORA-01578), and deadlock
errors (ORA-00060) that occur
- Administrative operations, such as some CREATE, ALTER, and DROP statements and STARTUP, SHUTDOWN, and ARCHIVELOG statements
- Messages and errors relating to the functions of shared server and dispatcher processes.
- Errors occurring during the automatic refresh of a materialized view
- The locations of the various diagnostics directories can be displayed using the V$DIAG_INFO view. SELECT name, value FROM v$diag_info;
- You can view the alert log by text editor or using ADRCI

 

 

 

SQL> SELECT name, value FROM v$diag_info;

NAME					 VALUE
---------------------------------------- ------------------------------------------------------------
Diag Enabled				 TRUE
ADR Base				 /u01/app/oracle
ADR Home				 /u01/app/oracle/diag/rdbms/orcl/orcl
Diag Trace				 /u01/app/oracle/diag/rdbms/orcl/orcl/trace
Diag Alert				 /u01/app/oracle/diag/rdbms/orcl/orcl/alert
Diag Incident				 /u01/app/oracle/diag/rdbms/orcl/orcl/incident
Diag Cdump				 /u01/app/oracle/diag/rdbms/orcl/orcl/cdump
Health Monitor				 /u01/app/oracle/diag/rdbms/orcl/orcl/hm
Default Trace File			 /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_15756.tr
					 c


NAME					 VALUE
---------------------------------------- ------------------------------------------------------------
Active Problem Count			 0
Active Incident Count			 0
ORACLE_HOME				 /u01/app/oracle/product/19/db_1

12 rows selected.

 

 

 

• 2개의 중요한 파일들

[oracle@test trace]$ pwd
/u01/app/oracle/diag/rdbms/orcl/orcl/trace


[oracle@test trace]$ ll *.log
-rw-r----- 1 oracle oinstall 672140 11월 23 14:17 alert_orcl.log


[oracle@test alert]$ pwd
/u01/app/oracle/diag/rdbms/orcl/orcl/alert


[oracle@test alert]$ ll
-rw-r----- 1 oracle oinstall 3249581 11월 23 14:17 log.xml