查看 v$diag_info 视图
SQL> select name,value from v$diag_info
2 ;
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_44965.trc
Active Problem Count 0
Active Incident Count 0
NAME VALUE
------------------------------ ------------------------------------------------------------------
ORACLE_HOME /u01/app/oracle/product/19.3.0/db_1
12 rows selected.
SQL>
ADRCI 的相关命令[oracle@strong ~]$ adrci
ADRCI: Release 19.0.0.0.0 - Production on Fri Sep 8 09:04:27 2023
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle"
adrci> help
HELP [topic]
Available Topics:
CREATE REPORT
ECHO
ESTIMATE
EXIT
HELP
HOST
IPS
PURGE
RUN
SELECT
SET BASE
SET BROWSER
SET CONTROL
SET ECHO
SET EDITOR
SET HOMES | HOME | HOMEPATH
SET TERMOUT
SHOW ALERT
SHOW BASE
SHOW CONTROL
SHOW HM_RUN
SHOW HOMES | HOME | HOMEPATH
SHOW INCDIR
SHOW INCIDENT
SHOW LOG
SHOW PROBLEM
SHOW REPORT
SHOW TRACEFILE
SPOOL
There are other commands intended to be used directly by Oracle, type
"HELP EXTENDED" to see the list
adrci>
设置 ADRCI 的主目录adrci> set home diag/rdbms/orcl/orcl
adrci> show home
ADR Homes:
diag/rdbms/orcl/orcl
使用 show alert 命令查看 alertlog 信息
-- show alert -tail (默认是10条条目)
-- show alert -tail 20 (显示最后20个条目)
-- show alert -tail -f (和 tail -f alertlog 命令功能相同)
adrci> show alert -tail 20
2023-09-08 09:39:01.366000 +08:00
TNS-00513: Destination host unreachable
nt secondary err code: 113
nt OS err code: 0
2023-09-08 09:39:04.362000 +08:00
Fatal NI connect error 12543, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sztech)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcldg)(CID=(PROGRAM=oracle)(HOST=strong)(USER=oracle))))
VERSION INFORMATION:
TNS for Linux: Version 19.0.0.0.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
Version 19.3.0.0.0
Time: 08-SEP-2023 09:39:04
Tracing not turned on.
Tns error struct:
ns main err code: 12543
TNS-12543: TNS:destination host unreachable
ns secondary err code: 12560
nt main err code: 513
TNS-00513: Destination host unreachable
nt secondary err code: 113
nt OS err code: 0
TT00 (PID:13813): Error 12543 received logging on to the standby
adrci>