有套19c rac环境,已应用了19.19的补丁,使用purgelogs清理日志是有报错
~~~~~~~~~~~~~~~~~~~~~~adrci RDBMS purge started~~~~~~~~~~~~~~~~~~~~~~
INFO: 2024-08-29 08:30:18: Getting dbhome for 'orcl'
WARNING: 2024-08-29 08:30:18: No ADR homes are set
使用oracle用户登录adrci,发现节点一正常,节点二报No ADR base is set
orcl1:/home/oracle@db1> adrci
ADRCI: Release 19.0.0.0.0 - Production on Thu Aug 29 08:23:18 2024
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle"
adrci>
orcl2:/home/oracle@jytdb2> adrci
ADRCI: Release 19.0.0.0.0 - Production on Thu Aug 29 08:32:02 2024
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
No ADR base is set
临时处理办法:
adrci> set base /u01/app/oracle
永久解决,从节点一上scp目录$ORACLE_HOME/log/diag到节点二
orcl1:/home/oracle@jytdb1> scp -r $ORACLE_HOME/log/diag jytdb2:$ORACLE_HOME/log/