adrci – No ADR base is set 错误的处理

adrci – No ADR base is set 错误的处理

故障如下：

$ adrciADRCI: Release 19.0.0.0.0 - Production on Fri Sep 30 08:51:29 2022Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.No ADR base is set

临时解决方法

先找到ADR Base：

SQL> select value from v$diag_info where name='ADR Base';VALUE
--------------------------------------------------------------------------------
/u01/app/oracle

然后在adrci命令中设置Base：

$ adrciADRCI: Release 19.0.0.0.0 - Production on Fri Sep 30 08:49:24 2022Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.No ADR base is setadrci> set base /u01/app/oracle
adrci> show alertADR Home = /u01/app/oracle/diag/rdbms/db0927_nrt1s2/DB0927:
*************************************************************************
Output the results to file: /tmp/alert_60622_1404_DB0927_1.ado
adrci> exit

这种方法，每次进入adrci都必须设置一次。

永久解决方法

需要将ADR base设置到配置文件中：

$ mkdir -p $ORACLE_HOME/log/diag
[oracle@bigtsiim ~]$ printf "%s" "/u01/app/oracle" > $ORACLE_HOME/log/diag/adrci_dir.mif
[oracle@bigtsiim ~]$ adrciADRCI: Release 19.0.0.0.0 - Production on Fri Sep 30 08:57:17 2022Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.ADR base = "/u01/app/oracle"
adrci>