Oracle 19c查看alert日志路径

最新推荐文章于 2024-01-23 22:29:08 发布

hbhe0316

最新推荐文章于 2024-01-23 22:29:08 发布

阅读量7.7k

点赞数 3

文章标签： oracle ios cordova unity app

本文链接：https://blog.csdn.net/hbhe0316/article/details/122701429

版权

Oracle alert日志诊断信息 DiagTrace v$diag_info

关键词由CSDN通过智能技术生成

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

https://www.cndba.cn/hbhe0316/article/4919

https://www.cndba.cn/hbhe0316/article/4919 https://www.cndba.cn/hbhe0316/article/4919 https://www.cndba.cn/hbhe0316/article/4919 https://www.cndba.cn/hbhe0316/article/4919 https://www.cndba.cn/hbhe0316/article/4919 https://www.cndba.cn/hbhe0316/article/4919

https://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