在Oracle中,各个组件(监听器、数据库实例、各种配置工具)在安装和运行时都会有相应的日志Log和跟踪文件Trace生成。Oracle 11g之前,这些信息都是零散的分布在Oracle组件目录中的。在11g,Oracle推出了ADR(Automatic Diagnostic Repository)的概念,将这些信息统一的列入到其中管理。
[grid@rac1]$ adrci
ADRCI: Release 19.0.0.0.0 - Production on Mon Mar 30 14:47:54 2020
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/grid"
adrci> show homes
ADR Homes:
diag/asm/+asm/+ASM1
diag/crs/njybjdb1/crs
diag/clients/user_grid/host_49425219_110
diag/clients/user_root/host_49425219_110
diag/tnslsnr/xxx1/asmnet1lsnr_asm
diag/tnslsnr/xxx1/listener_scan1
diag/tnslsnr/xxx1/listener
diag/asmcmd/user_grid/xxxx1
diag/asmcmd/user_oracle/xxxx1
diag/kfod/xxxx1/kfod
adrci>
查看alert日志
cd /u01/app/grid/diag/crs/nxxx1/crs
/u01/app/grid/diag/crs/xxxxb1/crs/trace
[grid@nxxx1 trace]$ ls |grep alert
alert.log