Author: Simon Pane

Evaluating Google AlloyDB for PostgreSQL 

In May of 2022, Google released the public preview of their long awaited and proprietary version of PostgreSQL called AlloyDB. This Google Cloud (GCP) service differs from the core PostgreSQL (and from their own Cloud SQL PostgreSQL) with some Google…

Read More >

An Initial Test of Google’s AlloyDB Columnar Engine

alloydb columnar engine

Google just recently launched the public preview of their new customized cloud version of PostgreSQL called AlloyDB. This Google Cloud Platform (GCP) managed database service is not the same as their Cloud SQL PostgreSQL service that still exists and is…

Read More >

Restoring a Dropped Oracle PDB Without a CDB Backup

Background I ran into a situation where we needed to restore just one dropped (and recreated) pluggable database (PDB) in an Oracle 19c Container Database (CDB), but we did not have any backups for CDB$ROOT, PDB$SEED, etc. Our only backup…

Read More >

Understanding the Implications of Creating a New PDB Using CREATE_FILE_DEST

qOverview When creating a new pluggable database, or PDB, you can optionally include the CREATE_FILE_DEST clause. Here’s an example: create pluggable database PDB1 admin user admin identified by “************” create_file_dest = ‘+DATA_DG’;   The value provided can be an ASM…

Read More >

Bugs with iscsi-initiator-utils*-6.2.0.878-5

This is a quick post for anyone experiencing iSCSI (Internet Small Computer Systems Interface) target login issues on Linux 8. Symptoms include: 1. Upon machine start, iSCSI node target logon does not succeed automatically during the boot process. (This was…

Read More >

Oracle Database and 2FA Using Cisco Duo

Background Oracle Database connectivity using multi-factor (MFA) or two-factor (2FA) authentication is rather simple to set up, is supported for all Oracle Database versions and editions (including SE2) without requiring any additional licenses, and is easy to use. And Cisco…

Read More >

Migrating Oracle Workloads to Google Cloud – BMS

In these challenging and ever-changing times, most organizations would welcome the opportunity to reduce overhead, drive innovation and become more agile. While all these benefits are possible with a move to the cloud, many organizations are overwhelmed at the thought…

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 >

PART 4: Implementing Oracle Database Single Sign-on Using Kerberos, Active Directory, and Oracle CMU

eempty string credentials. If the application throws an error if a NULL username or password is provided, then this will present a problem. For testing, we’ll use SQLPlus so this won’t be an issue for this proof of concept. Active…

Read More >

PART 3: Implementing Oracle Database Active Directory Password Synchronization using Oracle CMU

This is the third in a four-part article series related to testing Oracle Database 18c Centrally Managed Users (CMU) by leveraging the Oracle Cloud Infrastructure (OCI) for Oracle DBAs to create a lab or testbed. The second article covered Configuring…

Read More >
Page 1 of 41234