Here we will see how the deployment process of the new Exadata X8M works.   RoCE issues from the factory Exadata X8M servers are coming from the factory with the RoCE private network disabled. In case the Field Engineer assigned…

Background A common question from Oracle customers is whether they can configure the Oracle Database to use: Two-Factor Authentication (2FA) Multi-Factor Authentication (MFA) A “Time-based One-time Password” (TOTP) code, which is usually a six-digit code generated from a hardware or…

Hello! I recently noticed that: What if I’m not happy with the Oracle algorithm and I want to drop and auto-index on 19c? It should be easy, I initially thought. For example, something like “drop index XXXX;” right? Wrong. However,…

Managing Oracle on AWS has some twists. Here are five daily DBA activities that have changed on AWS: Kill Sessions: begin rdsadmin.rdsadmin_util.kill( sid => &sid, serial => &serial, method => ‘IMMEDIATE’); end; /   Flush shared_pool or buffer_cache: exec rdsadmin.rdsadmin_util.flush_shared_pool;…

In a new 12c environment (which actually includes 18c and 19c, as per the 12c family), the datapatch failed on the following: ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 1 ORA-65108: invalid use of a cursor…

There are multiple documented methods for installing the Oracle Cloud Infrastructure command line utilities (oci). Some methods work better than others, but sometimes none of them meet your needs. This is a story of getting the installation done to meet our needs.

When configuring virtual servers to run Oracle RAC, be sure to use Jumbo Frames for the private network interconnect , just like you would on physical servers.

Here’s a short and sweet post. “In Deploy mode, AutoUpgrade also confirms that the upgrade has succeeded, and moves database files such as sqlnet.ora, tnsnames.ora, and listener.ora from the source home to the target home. After these actions are complete,…

After setting up GoldenGate in your environment, you might ask yourself: How much work is being done by my GGate environment? Here’s another consideration: You just want to set up a dummy extraction so you can measure it before starting…

Does IPv6 formatting for JDBC and SQLPlus seem new to you well, it’s been available since 11gR2. You’re familiar with IPv6, right? If not, click here. Basically, the only thing you need to do is enclose the IPv6 address in…