Oracle Database Monthly News – January 2024 – Quick Links

Database & Cloud Database News

• Clone Autonomous Database to Change Workload Type: documentation

• Announcing the Oracle SQL Developer Extension for VS Code: blog posting

• Announcing Database Security Assessment Tool (DBSAT) 3.1: blog posting

• Oracle Data Safe now allows you to view user schema access details: documenation

• Oracle Data Safe now allows you to configure and defer risk findings : documentation

• Oracle Data Safe now supports Active Data Guard associated target databases: documentation

• View the top five security assessment findings in Oracle Data Safe: documentation

• Gartner recognizes Oracle as a Leader in the 2023 Magic Quadrant™ for Cloud Database Management Systems: announcement

Upcoming Events

• Ask Tom Office Hours events
• Monthly events from Oracle and the APEX Community
• January 31: Oracle Partitioning for Modern Data Architecture (DBA Masterclasses)
• February 7: Oracle’s Tech Lounge series – Maximum Security Architecture for Regulatory Compliance
• February 15: Customer Webcast: Autonomous in Action 
• February 22: Cross Platform Migration – Transportable Tablespaces to the Extreme (Virtual Classroom Series Upgrade to Oracle Database 23c)
• February 27: Oracle Database Appliance Meet the Experts
• February 28: Oracle DB Multitenant Architecture: Workload Isolation and Resource Management (DBA Masterclasses)
• April 22-24: APEXConnect 2024
• Save the date for CloudWorld Tour 2024: Mumbai (14.2), London (14.3), Milan (21.3), Sao Paulo (4.4), Singapore (16.4), Tokyo (18.April), Mexico City (25.2)
• May 9: Move to Oracle Database 23c – Everything you need to know about Oracle Multitenant (Virtual Classroom Series Upgrade to Oracle Database 23c)

Release & Patch Updates

• January 2024 Critical Patch Update Released

• Update Release Schedule of Current Database Releases: Doc ID 742060.1

• Database Release 23.3.0.23.09, 21.13.0.0.240116, 19.22.0.0.240116, 12.2.0.1.220118, 12.1.0.2.220719: Oracle Database (RDBMS) Releases Support Status Summary (Doc ID 161818.1)

• Enterprise Manager 13.5.0.19: Overview of the Enterprise Manager Proactive Patch Program (Doc ID 822485.1)

• Exadata Storage server 23.1.9.0.0, 22.1.18.0.0, 21.2.24.0.0: Exadata Database Machine and Exadata Storage Server Supported Versions (Doc ID 888828.1)

• Oracle Database Appliance (ODA) 19.21: Oracle Database Appliance Documentation

• MiniCluster 1.6.1.3: Oracle MiniCluster S7-2: Software Download Center (Doc ID 2153282.1)

• Datapump Bundle Patch 19.22.0.0.0 Data Pump Recommended Proactive Patches For 19.10 and Above (Doc ID 2819284.1)

• AutoUpgrade 23.4.230921 AutoUpgrade Tool (Doc ID 2485457.1)

• AHF 23.11: Autonomous Health Framework (AHF) – Including TFA and ORAchk/EXAchk (Doc ID 2550798.1)

• DBSAT 3.1.0: Oracle Database Security Assessment Tool (DBSAT) (Doc ID 2138254.1)

• SQL Developer 23.1.1: oracle.com/sqldev 

• SQLcl 23.3: oracle.com/sqlcl

• ORDS 23.4: oracle.com/ords

• APEX 23.2.3: https://www.oracle.com/tools/downloads/apex-downloads/

• Python Driver 2.0.1: python-oracledb Release Notes

• Node.js Driver 6.1.0: oracle.github.io/node-oracledb

• Instant Client Linux 19.21 and 21.12: oracle.com/de/database/technologies/instant-client/downloads.html

• Instant Client Windows 19.21 and 21.12: oracle.com/de/database/technologies/instant-client/downloads.html

Videos, Tutorials, Posting & Publications

• Kickstart Your Journey with OCI Full Stack Disaster Recovery (DR) (Suraj Ramesh)

• New views in Oracle Data Guard 23c (Ludovico Caldara)

• 2023 in Review for Autonomous Database on Dedicated Exadata Infrastructure (German Viscuso)

• How to Use AWR to Check if Your Application is Protected by Application Continuity (Sinan Petrus Toma)

• The downsides of in-place patching – and a patching lab (Mike Dietrich)

• COUNT(*) versus COUNT(1) – the finale (Connor McDonald)

• See you data through new eyes: Everything ca be graph (Karin Patenge)

• ORA-39405 with impdp when you have mixed time zone versions (Mike Dietrich)

• How to get SQL_ID without execution? (Ulrike Schwinn)

• IF-THEN logic in SELECT and WHERE with CASE expressions in Oracle SQL (Chris Saxon)

• Logins, TNS, DBMS_OUTPUT, & dates in SQLDev for VS Code (Jeff Smith)

• Database 23c  (oracle.com)

• 23c category (blogs.oracle.com/coretec)

General 

• Oracle Technology Products (Oracle Lifetime Support Policy)
• Oracle Cloud Infrastructure Documentation / Release Notes
• Oracle Cloud Infrastructure Documentation / Release Notes – Database
• OCI Status for all Services
• Cloud Services Quick Reference

What’s New

• What’s New in Oracle Base Database Service
• What’s New for Oracle Autonomous Database Serverless
• What’s New in Oracle Exadata Database Service on Cloud@Customer Gen2
• What’s New in Oracle APEX 23.2