The Brand New Exadata X8M Deployment Process Revealed

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…

Read More >

Oracle Database and Two-Factor Authentication (2FA)

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…

Read More >

19c Auto-Indexing: ORA-65532: Cannot Alter or Drop Automatically Created Indexes

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,…

Read More >

AWS RDS: 5 Must-Know Actions for Oracle DBAs

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;…

Read More >

Datapatch Failing on ORA-65108 (PDB$SEED): Applying Datapatch Manually

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…

Read More >

Installing OCI Command Line Utilities in Linux and Windows

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.

Read More >

Oracle RAC: Network Performance with Jumbo Frames

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.

Read More >

Caution: Using AutoUpgrade with Multiple Databases from the Same ORACLE_HOME

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,…

Read More >

Extracting DML Stats/Workload With GoldenGate

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…

Read More >

IPv6 Formatting for JDBC and SQLPlus

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…

Read More >
Page 1 of 2412345...10...Last Page »