重庆思庄IT技术分享-节点2出现No ADR homes are set异常处理

数据库：oracle 19.3
系统：CentOS 7.9
环境：rac
问题描述：在节点2执行adrci指令，出现No ADR base is set，如下所示：
[oracle@hisdb2 ~]$ adrci

ADRCI: Release 19.0.0.0.0 - Production on Thu Apr 28 13:59:01 2022

Copyright © 1982, 2019, Oracle and/or its affiliates. All rights reserved.

No ADR base is set
adrci> show home
No ADR homes are set

经查询资料，以下为解决过程：
[oracle@hisdb2 db]$ ll $ORACL{E}_{H}OME/log/diag/ls:cannotaccess/u01/app/oracle/product/19.3.0/db/log/diag/:Nosuchfileordirectory[oracle@hisdb2db]$ mkdir -p $ORACL{E}_{H}OME/log/diag/[oracle@hisdb2db]$ printf “%s” $ORACLE_BASE > $ORACL{E}_{H}OME/log/diag/adrc{i}_{d}ir.mif[oracle@hisdb2]$ adrci

ADRCI: Release 19.0.0.0.0 - Production on Thu Apr 28 14:03:34 2022

Copyright © 1982, 2019, Oracle and/or its affiliates. All rights reserved.

ADR base = “/u01/app/oracle”
adrci> show home
ADR Homes:
diag/rdbms/orcl/orcl2

adrci> set home diag/rdbms/orcl/orcl2
adrci> show alert -tail -f
2022-04-28 13:45:05.914000 +08:00
Set master node info
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Reconfiguration complete (total time 0.3 secs)
2022-04-28 13:45:25.092000 +08:00
Increasing number of high priority LMS from 0 to 2
2022-04-28 13:45:34.272000 +08:00
ALTER SYSTEM SET _ipddb_enable=TRUE SCOPE=MEMORY SID=‘orcl2’;
2022-04-28 13:45:42.272000 +08:00
Warning: VKTM detected a forward time drift.
Please see the VKTM trace file for more details:
/u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_vktm_9520.trc
2022-04-28 13:56:01.401000 +08:00
ALTER SYSTEM SET db_files=1000 SCOPE=SPFILE;