Wednesday, October 12, 2022

Remove "XDB initialized" from alertlog


 There is an unpublished Bug 29845449 in Oracle 19c, causing the following message to be written frequently in the DB alertlog:


XDB initialized.

XDB initialized.

Solution: [Works on Linux OS only]

You can run the following command to clean up "XDB initialized" message from the alertlog and two lines above it, which include the timestamp as well: 

[Replace /u01/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log with your right database alertlog path]

# vim -e - /u01/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log << EOF
g/XDB initialized/.-2,.d

Excerpt from the alertlog file before running the command:

 After running the command:


Looks cool! 

I'll add this feature shortly to the database monitoring script "dbalarm" to automatically get rid of this message whenever the script runs:



"XDB Initialized." appearing multiple times in alert.log (Doc ID 2784774.1) 













No comments:

Post a Comment