重庆思庄Oracle、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 1678|回复: 0
打印 上一主题 下一主题

[Oracle] 节点2出现No ADR homes are set异常处理

[复制链接]
跳转到指定楼层
楼主
发表于 2022-5-13 13:17:01 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
数据库: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;


分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏 支持支持 反对反对
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2024-11-26 03:57 , Processed in 0.091893 second(s), 21 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表