101 Series of Oracle in Google Cloud - Part I : Building ASM and Database

Introduction to Oracle on Google Cloud About a year ago, I worked on a project with some amazing teammates (Simon Pane ...

Upgrade SQL Server Reporting Services to 2017

In the past, we could run the SQL installer to do an in-place upgrade of SQL server including the SSRS instance to a ...

SQL - Managing Jobs in Availability Groups

This blog post will show how to dynamically add logic at the beginning of jobs in Availability Groups in order to avoid ...

Oracle RAC: Network Performance with Jumbo Frames

Introduction When working with Oracle RAC, it's strongly advised to use Jumbo Frames for the network that provides the ...

Using MySQL Workbench to Connect Through ProxySQL 2

So, I admit the title for this post is a bit ambiguous. Not only is it the second post I've written in a short period ...

Using FreeRadius to Authorize Oracle Connections

Introduction This article will show how to configure the FreeRadius RADIUS server for use in authorizing Oracle ...

Using MySQL Workbench to Connect Through ProxySQL

MySQL Workbench is a popular tool for many developers working with a MySQL backend database. In a simple environment ...

Trace on Standby: Tracing MRP Process

Sounds simple, right? And it really is, although it might not seem obvious. Recently, I ran into an issue when trying ...

While Upgrading from GI 12c to 19c, +asm1(19c) Cannot Detect +asm2(12c)

A few weeks ago, I was working on a GI upgrade from 12.2 to 19.6. After running ...

A few weeks ago, I was working on a GI upgrade from 12.2 to 19.6. After running the upgrade on Node 1, an issue ...

Resolving an Availability Group Sync Issue - HADR_AR_CRITICAL_SECTION_ENTRY

We recently ran into an interesting issue on a three-node SQL Server Availability Group (AG) cluster. There was a ...

Join, Group By, and Aggregate in Cloud Data Fusion

Good news! Cloud Data Fusion is now GA. Announced at Google Next ‘19 UK on November 21, 2019, Cloud Data Fusion is a ...

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

It’s one of those classic "Oracle knows best" moments, isn't it? You try to take back control of your own schema, and ...

How to Read Oracle Traces from SQL*Plus

Situation Let's say you need to read trace files from Amazon Relational Database Service (RDS). How do you do it?

How Cloud Computing Has Transformed Over the Last Decade

As we look back on the past ten years, cloud computing may be considered one of the largest transformations in ...

Conventions Make for Easy Automation

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

Problem In a new 12c environment (which actually includes 18c and 19c, as per the 12c family), the datapatch failed on ...

Installing OCI Command Line Utilities in Linux and Windows

As part of a recent project, I installed the Oracle Cloud command line utilities (oci) on the following Linux systems:

Managing SQL Jobs in Availability Groups - Method Job Category

Method - Job Category This blog post will show how to setup SQL Jobs in multiple availability groups. This method will ...

Extracting DML Stats/Workload With GoldenGate

Quantifying data movement across the environment After setting up GoldenGate in your environment, you might ask ...

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 ...

How To Export Collections in SCCM to CSV Using Powershell

Your mission: Gather a list of servers in a specific collection on System Center Configuration Manager (SCCM) so you or ...

Data Guard Listener Networking

I am currently reviewing an environment to create a third standby database. One of the primary challenges I’ve ...

CRS-10051: CVU found following errors with Clusterware setup

Error Statement I recently found this interesting message error in a CRS alert log from a client environment:

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:

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 ...

How to Quickly Ignore ORA Error on Agent Layer

I had a very specific situation where I wanted to ignore an error from a specific agent. It turns out that it is easier ...

Deep Learning: Techniques to Avoid Overfitting and Underfitting

Machine Learning is all about striking the right balance between optimization and generalization. Optimization means ...

How to Connect from Cloud Functions to the Private IP Address of Cloud SQL in Google Cloud

Cloud functions allow you to run single-purpose functions without having to manage instances in Google Cloud. Cloud SQL ...