ZDM Migration : Migrate from an On-Premises 19c non-Container Database to Oracle Database 23ai Container Database

Migrate from an On-Premises 19c non-Container Database to Oracle Database 23ai Container Database. The details are available at below link.

 ZDM Migration from 19c to 23ai

How to select/filter specific lines from the oracle database alert log?

Usually when verifying the alert log entries to troubleshoot any database specific issue, it will take a good amount of time if the alert log is huge like 10MB or 20MB etc.. During such situations, if we know the exact error time, to filter specific lines from alert log, please use below script.

awk '$0 >= "2025-01-19T00:00:00" && $0 <= "2025-01-25T00:00:00" {print $0; getline; print $0}' /u02/app/oracle/diag/rdbms/test1/TEST1/trace/alert_TEST1.log > selected_alert.txt

in the above command, selected_alert.txt contains your required output lines from the alert log.
reference article :

https://ermannkara.wordpress.com/2025/02/06/filter-a-specific-time-range-in-the-alert-log-and-write-the-results-to-a-txt-file/

Oracle Exadata X11M - Datasheets of EXADATA, EXACC and EXACS

Please refer to the following links for more information on EXADATA X11M..

1) Oracle blog reference informing about Exadata X11M
2) Exadata Database Machine X11M Datasheet (On-prem)
3) Exadata Database Service X11M Datasheet (EXACS)
4) Exadata Cloud@Customer X11M Datasheet (EXACC)

Oracle Enterprise Manager 24ai installation steps

Refer below link for the installation of Oracle Enterprise Manager 24ai

Oracle Enterprise Manager 24ai installation steps

Oracle DB patching (single instance db's) with autoupgrade tool - livelabs session

As we all know opatch is old way of patching oracle db's and autoupgrade is emerging now a days, There is a good livelab session is there if we want to practice patching (single instance) with AUTOUPGRADE tool.

https://apexapps.oracle.com/pls/apex/dbpm/r/livelabs/view-workshop?wid=3740

Oracle database Features and Licensing information for all the database releases through 11.2.0.2 to 23ai

Sometimes we want to compare/verify the database feature(s) that is/are available in a perticular database version. During that time, we need to verify oracle documentation (or) some other resources available in the internet. Some times we did not get the details easily. In such cases, to save our time, use below link for database features and licencing information

Oracle database Features and Licensing information

Oracle database release schedule (updated till 23ai)

Please find the master note for Oracle database releases..

Schedule of Current Database Releases (Doc ID 742060.1)