wiki:cleanup_diag_folder
To cleanup some space on your disk with old incidents in the Oracle\diag folder do the following
- Open Command Prompt as administrator
- Check that the ORACLE_HOME variable is defined and that the PATH variable contains %ORACLE_HOME%\perl\bin
echo %ORACLE_HOME% C:\oracle\product\19.3.0\dbhome_1
c:\source\35962832>echo %PATH% C:\oracle\product\19.3.0\dbhome_1\bin;C:\Install_Oracle19c\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\oracle\product\19.3.0\dbhome_1\perl\bin
- If not present, type the following:
set ORACLE_HOME=C:\oracle\product\19.3.0\dbhome_1set PATH=%ORACLE_HOME%\perl\bin;%PATH%
- Once oracle home is set, you can start ADRCI
C:\Windows\system32>adrci ADRCI: Release 19.0.0.0.0 - Production on Tue Jul 23 11:43:03 2024 Copyright (c) 1982, 2024, Oracle and/or its affiliates. All rights reserved. ADR base = "C:\oracle"
- Check if home path is properly set
adrci> show home ADR Homes: diag\clients\xxx\host_2998225502_110 diag\rdbms\xxx\xxx diag\tnslsnr\servername\xxx
- If you have multiple home path set, you'll have to specify the one that you want to cleanup. Look in the folder where are the diag files that need to be removed. It should be in the rdbms or the tnslsnr
adrci> set homepath diag\rdbms\xxx\xxx
- Once the home path is set, you can use the purge command to cleanup the diag files where -age is specified in minutes and - type is the type of diag files that needs to be cleaned up (incident, alert, trace … )
adrci> purge -age 20160 -type incident
wiki/cleanup_diag_folder.txt · Last modified: by wagner.jer