Alert Log

How to Resolve "Warning: PDB altered with errors."

by Ed Chen
April 11, 2022November 17, 2022
6 Comments

Warning: PDB altered with errors Tried to open a newly cloned or created PDB, but it failed with "Warning: PDB altered with errors". SQL> alter… Read More »

How to Resolve ORA-65144: ALTER SYSTEM DISABLE RESTRICTED SESSION is not permitted

by Ed Chen
April 11, 2022May 18, 2022

ORA-65144 Tried to remove restricted mode from a newly cloned PDB, but it failed with ORA-65144. SQL> show pdbs CON_ID CON_NAME … Read More »

Where is DBCA Log Location

by Ed Chen
December 31, 2021April 22, 2022

DBCA Log Location Two locations that you can see the trace log of Database Configuration Assistant (DBCA). DBCA log location The file path and name… Read More »

Where is Oracle Alert Log Location

by Ed Chen
April 19, 2019September 28, 2021

The Default Oracle Alert Log Location Oracle alert log location may vary from version to version, and sometimes it's not easily found. However, it usually… Read More »

How to Delete Log Files Periodically in Oracle

by Ed Chen
May 18, 2018October 10, 2021

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 Trim Alert Log File in Oracle

by Ed Chen
April 19, 2018December 27, 2021

The retention of alert log cannot be controlled by ADRCI utility, it needs manual intervention. In this post, I'd like to share how I reduce… Read More »