Collection of useful blog posts and articles

APEX, Rest

Batch Loading CSV to a TABLE in Oracle Autonomous Database using AUTOREST API <- Jeff Smith; Cloud; ATP

Exploring Report Printing in APEX 20.2

Faceted Search Enhancements in APEX 20.2

Performance optimization, SQL & PL/SQL

PL/SQL 101: Part 1 in a series of articles on understanding and using PL/SQL for accessing Oracle Database

I ‘fixed’ execution plan regression with optimizer_features_enable, what to do next? <- SQL Plan Baseline; Pathfinder;

Data Pump your Data to the Oracle Autonomous Database <- Jeff Smith; Cloud; Data Pump; SQL Developer

PL/SQL SDK for Oracle Cloud

DBA Masterclass – Application Tuning by Chris Saxon

Longest common substring – Ratcliff-Obershelp similarity algorithm – Great Stuff!!!!

Security

Managing Oracle Database 19c Users in Active Directory (part 1 – Kerberos)

RAC, Grid Infrastructure, ASM, OCR

Trace File Analyzer Collector – TFA Collector Usage and installation <- H. Hutzler!

Debugging Clusterware <- H. Hutzler!

Silent Out Of Place Patching for ORACLE 19c GI <- Rene Antunez

OPATCHAUTO Bug on 19.3 GI/RDBMS when Patching to 19.6

Step By Step Guide To Install Oracle 19c RAC installation Using VirtualBox

Silent Out-of-Place Patching For Oracle 19c GI

Oracle 12c – Is VKTM always your top process?

Data Guard

About Oracle Data Guard Log Transport Services

Oracle Data Guard mit der Datenbank-CLI verwenden – Cloud, CLI

How to Fail Over and Reinstate Oracle Database on Oracle Cloud

Backup & Recovery

(OCI) mv2bucket – Oracle Managed Bucket Content Manager (Doc ID 2723911.1) MV2Bucket is a new tool to manage the Oracle Managed Bucket Content

Upgrade, Migration

Upgrading Oracle using autoupgrade.jar and Migration From NON-CDB to CDB Architecture

Oracle Zero Downtime Migration

When Fixed Object Stats Gathering takes very long during upgrade …

Cloud

How to Create a Database Link from an Autonomous Data Warehouse to a Database Cloud Service Instance <- Official Oracle DWH Blog

Oracle Autonomous Transaction Processing – Move your Data with Oracle Data Pump – Part 3 <- Martin Berger CH; DataPump into Cloud

DBMS_CLOUD Package – A Reference Guide Christian Antognini; 2018;

Oracle Cloud : Autonomous Database (ADW or ATP) – Import Data from an Object Store (impdp) <- Tim Hall; Oracle Base

Data Pump your Data to the Oracle Autonomous Database <- Jeff Smith: Data Pump; SQL Developer

Blog from Martin Berger – Autonomous Database

Using Let’s Encrypt certs with Oracle Cloud Load Balancer — including auto renew feature

Working with Oracle Cloud Infrastructure Object Storage

Oracle Autonomous Database Dedicated Workshops & Labs

Oracle 19c Workshops

Create SSH Key for the Cloud

VCN flow logs general availability for Oracle Cloud Infrastructure

Use Microsoft Active Directory with Autonomous Database

MAA, Application Continuity, Transaction Guard

Application Continuity in Oracle Database 19c <- Official Oracle MAA Blog

Exadata, ZDLRA, ODA

Patch ODA from 18.3 to 19.8. Part 4 – 19.7 to 19.8 <- Fernando Simon

ZDLRA + MAA, Protection for Platinum Architecture

DevOps, Docker, Ansible, Linux

How to Setup and Manage Log Rotation Using Logrotate in Linux

Ansible with Oracle Linux Virtualization Manager

OEM (Oracle Enterprise Manager)

How to Install OEM 13.4 on OL8

Machine Learning, AI (Artificial Intelligence)

Oracle Machine Learning Workshops

Recommended blogs

https://www.hhutzler.de/blog/ H. Hutzler

Oracle Base – Tim Hall

Mohamed Houri

SQL Developer & Modeller – Jeff Smith

Miscellaneous commands for DB, RAC, TFA etc.

Oracle Developers Blog

Oracle Upgrade Blog – Mike Dietrich

WebTechie.be – Java, JavaFX, Rapsberry PI by Frank Delporte