Automatic Diagnostic Repository Command Interpreter (ADRCI)

How to Resolve DIA-48448: This command does not support multiple ADR homes

by Ed Chen
February 16, 2022December 13, 2021

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… Read More »

How to Resolve "No ADR base is set"

by Ed Chen
August 25, 2021December 21, 2022

No ADR base is set To manage Automatic Diagnostic Repository (ADR), we used to use ADRCI command line to interact with server. Node 1 [oracle@primary01… Read More »

How to Delete Log Files Periodically in Oracle

by Ed Chen
May 18, 2018December 10, 2022

Trace File, Audit File and Alert Log In this post I will introduce a shell script that can delete log files automatically. We will handle… Read More »

How to Delete Old Audit Files in Oracle

by Ed Chen
May 17, 2018October 8, 2022

ADUMP Cleanup Audit files cannot be deleted like trace files deletion by ADR Command Interpreter (ADRCI), so we need to delete them at OS-level by… Read More »

How to Delete Trace Files in Oracle

by Ed Chen
April 4, 2018February 9, 2023

Delete Trace Files Trace files have to be controlled and cleaned regularly, otherwise your disk space will be exhausted soon or later. But cleaning trace… Read More »

Where is Oracle PFILE Location

by Ed Chen
September 9, 2017December 11, 2022

If we were trying to change parameters in an unfamiliar database that was handed over from other DBA, we have to figure it out whether… Read More »