Throughout May, Oracle ACEs from all around the globe shared insights, tips and tricks, and knowledge in over 500 blog posts. Before this month is over, we wanted to highlight some of them for you to read and enjoy, focusing on 23ai, APEX, ZDM, ZDLRA, OCI, JSON, and much more.

While preparing for my upcoming Kscope24 presentations, I thought I’d introduce a section on Oracle’s recently announced AI Vector Search that is now generally available with the Oracle Database 23ai rebranding and release. At the time of writing, you can either provision the new version of the database on the Oracle Cloud Infrastructure (OCI), download the Oracle Autonomous Database (ADB) Free container image, or the Oracle Database 23ai Free. On the OCI, you can either provision an Always Free ADB, or an Oracle Base Database service instance.

Oracle Zero Downtime Migration (ZDM) is a comprehensive cloud migration tool offered by Oracle to facilitate seamless migration of on-premises databases to the Oracle Cloud Infrastructure (OCI) with minimal downtime. ZDM automates the entire migration process, making it efficient and reliable for organizations looking to transition their database workloads to the cloud.

Oracle Cloud Infrastructure (OCI) provides a robust platform for deploying and managing applications. In this blog, we test the capabilities of Select AI with a sample application using Oracle’s HR schema.

Another 23c or 23ai feature that you will be happy embracing! In previous Oracle versions, what did you do when someone requested read only access to a schema?

Most likely, as a good DBA, you created roles that would give users read only access. Here is an example. Let’s say I have the HR schema in my database, with tables, views and other objects.

This blog post details the investigation of a high CPU usage issue caused by a rogue bash process on an Oracle Linux server. This systematic investigation identified malicious scripts causing the high CPU usage. This blog post also offers valuable insights into troubleshooting bash process issues and highlights the importance of secure system configurations.

Tutorial Objectives:

   –  Simulate a ZDLRA site/server failure scenario by shutting down the secondary ZDLRA catalog database

   – Perform RMAN incremental level 1 backup and verify backup completes successfully by connecting to primary ZDLRA catalog database which is up and running

   – Verify replication of database and archive log backups from Primary to Secondary ZDLRA servers after failure scenario has been resolved

This post will show how to get GL Journal details of AP Invoice Payment in Oracle Fusion, i.e. how to get details of accounting details of AP Invoice payment, by navigating from AP_INVOICES_ALL all the way to GL_JE_HEADERS

The most complicated part about ADT is the installation. But don’t worry, it is not that complicated and everything after that is super easy.

If you have been patching your Oracle Enterprise Manager Environment frequently you were struggling with patching the WLS and all other components.

What is “Security Assessment”. Data Safe is divided in a few sections. Security assessment is the tool that assesses the security of your Oracle database configurations.

A very nice, powerful and potentially somewhat dangerous new feature in Oracle Database 23ai: Pre-Authenticated Request URLs for Read Only Data Access on Autonomous Database. In summary: with a single statement we can create a URL that provides direct HTTP access to a dataset (that is returned as a JSON document).

I wanted to write on this topic in a previous post already. But then I stumbled upon an issue with read only tablspaces. So today I’ll cover the topic using R/W tablespaces only. The reason for writing this article is, that the majority of restore szenarios is not caused by infrastructure failures but by human errors.

Recently I started a piece of research on Inline Application Help. I wanted to find examples of guiding the user, helping them completing the page, without being too obtrusive, annoying or taking up valuable screen area.

When I launched my 5th and final blog post in the Oracle + AI series in April of this year, I was pleasantly surprised to see an email within 24 hours from my buddy and former CEO, Edward Roske. Edward and I share a deep fascination with AI.

Oracle Cloud Infrastructure Bastion provides restricted and time-limited access to target resources that don’t have public endpoints. Bastions let authorized users connect from specific IP addresses to target resources using Secure Shell (SSH) sessions. The target instance can be a compute instance or a DB system, an Autonomous Database for Transaction Processing or a Mixed Workload Database.

One key feature within Oracle APEX is Interactive Reports (IR), which offer rich data analysis out-of-the-box and can be customized by end-users for sorting, filtering, and more. End-users can also save their customized reports as private reports, exclusively accessible to them.

So this post is the continuity of the previous one , where I described the concepts around OCI Object Storage.

In two prior articles I used pl/sql and java to build functions that would return the keys of a JSON document as a collection which could be queried as a table.

BITMAP index are different from B-TREE index in the manner they store data. B-TREE index stores data in tree format whereas BITMAP index stores data as 2-dimensional arrays.

I recently hit an issue with OCI Network Firewall that we had configured with NAT GW (see previous posts on it). We expected only to use it for egress traffic from OCI to public internet from our private compute VMs but a new requirement came which required to access some privately exposed services on OCI, and traffic would still need to flow through firewall.

We’ve been pushing out some Oracle 19c databases on Oracle Linux 9 (OL9) since it was certified, see here, but those databases have not been monitored or backed up by Cloud Control, because the Enterprise Manager (EM) 13.5 agent was not certified on OL9.

In the rapidly evolving digital landscape, chatbots and digital assistants have emerged as game-changers, revolutionizing how businesses interact with technology. Within this context, the Oracle Digital Assistant, part of the Oracle Cloud Fusion suite, stands out as a powerful tool designed to enhance user efficiency, reduce email overload, and boost overall productivity.

Got too much data in the database? Offloading it to object storage is one option. Even better, get stuff in to the database and analyse it with SQL.

You can find all the ACEs above and many more on the Oracle ACE Directory. Bookmark the Oracle ACE Program blog and come back next month for more updates!