DIA-48448
Tried to purge trace files in ADRCI, but it failed with DIA-48448
adrci> purge -age 10080
DIA-48448: This command does not support multiple ADR homes
Even show control threw the error.
adrci> show control
DIA-48448: This command does not support multiple ADR homes
DIA-48448 means that there're multiple ADR homes in current session, the utility does not know which ADR home you want to perform. That is to say, only one ADR home can be used at a time to perform commands in ADRCI.
Solution
Let's see what ADR homes we have.
adrci> show homes
ADR Homes:
diag/asm/+asm/+ASM1
diag/asmcmd/user_grid/primary01
diag/asmcmd/user_oracle/primary01
diag/clients/user_grid/host_220395685_110
diag/clients/user_root/host_220395685_110
diag/crs/primary01/crs
diag/kfod/primary01/kfod
diag/tnslsnr/primary01/asmnet1lsnr_asm
diag/tnslsnr/primary01/listener
diag/tnslsnr/primary01/listener_scan1
diag/tnslsnr/primary01/listener_scan2
diag/tnslsnr/primary01/listener_scan3
As you can see, there're many ADR home in ORACLE_BASE. To solve DIA-48448, we should explicitly set only one ADR home in order to perform the command.
adrci> set home diag/tnslsnr/primary01/listener
adrci> purge -age 10080
adrci>
By the way, SHOW HOME, SHOW HOMES and SHOW HOMEPATH are synonyms, there's no difference among them.
adrci> help SHOW HOME
Usage: SHOW HOMES | HOME | HOMEPATH
[-ALL | -base <base_str> | homepath_str1 ... ]
Purpose: Show the ADR homes in the current ADRCI session.
Options:
[-ALL]: If it is specified, the ADR homes under the current base
setting will be displayed.
[-base <base_str>]: It is for showing all the homes under <base_str>,
where <base_str> is a system-dependent directory path string.
<homepath_str1 ...>: The paths of the home, relative to the ADR base.
Examples:
show homes -all
show homes -base /temp
show homes rdbms
show homes