OS환경 : Oracle Linux 6.8 (64bit)
DB 환경 : Oracle Database 11.2.0.4
에러 : DIA-48447: The input path [/oracle/app/oracle/] does not contain any ADR homes
adr base 설정을 위해 명령 수행후 발생한 메세지
1 2 3 4 5 6 7 8 9 | $ adrci ADRCI: Release 11.2.0.4.0 - Production on Mon Aug 17 08:23:51 2020 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. ADR base = "/home/oracle" adrci> set homepath /oracle/app/oracle/ DIA-48447: The input path [/oracle/app/oracle/] does not contain any ADR homes |
해결 방법 : set base 명령 사용
set base 명령으로 ADR base 설정
1 2 3 4 5 6 7 8 9 10 | adrci> set base /oracle/app/oracle/ adrci> show base ADR base is "/oracle/app/oracle" adrci> show home ADR Homes: diag/rdbms/orcl11/ORCL11 diag/tnslsnr/ORACLE11/listener diag/tnslsnr/ORACLE11/listener1527 diag/tnslsnr/ORACLE11/listener1523 diag/clients/user_oracle/host_3827751472_80 |
원인 : ADR base 를 설정 할 때에는 set home 이 아닌 set base 명령을 이용해야함
ADR base 를 설정 할 때에는 set home 이 아닌 set base 명령을 이용해야함
참조 : http://www.dba-oracle.com/t_dia_48447_input_path_adr_home.htm