总是凭着感觉去找alert日志，今天记录一下，alert日志在/u01/app/oracle/diag/rdbms/orcl/orcl/trace下。http://www.cndba.cn/hbhe0316/article/4919http://www.cndba.cn/hbhe0316/article/4919

SQL> col value for a100
SQL> col name for a30
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_5410.trc
Active Problem Count           0
Active Incident Count          0
ORACLE_HOME                    /u01/app/oracle/product/19.3.0/dbhome_1

12 rows selected.

版权声明：本文为博主原创文章，未经博主允许不得转载。

Linux,oracle