标题: 节点2出现No ADR homes are set异常处理 [打印本页] 作者: denglj 时间: 2022-5-13 13:17 标题: 节点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 (c) 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 $ORACLE_HOME/log/diag/
ls: cannot access /u01/app/oracle/product/19.3.0/db/log/diag/: No such file or directory
[oracle@hisdb2 db]$ mkdir -p $ORACLE_HOME/log/diag/
[oracle@hisdb2 db]$ printf "%s" $ORACLE_BASE > $ORACLE_HOME/log/diag/adrci_dir.mif
[oracle@hisdb2 ~]$ adrci
ADRCI: Release 19.0.0.0.0 - Production on Thu Apr 28 14:03:34 2022
Copyright (c) 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;