错误的处理"/>
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>
更多推荐
adrci – No ADR base is set 错误的处理
发布评论