Author: Simon Pane

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

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

PART 2: Configuring Windows and Linux Servers for CMU Testing

This is the second 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 first article covered how…

Read More >

PART 1: Creating an Oracle 18c Centrally Managed Users Testbed using Oracle Cloud Infrastructure

Oracle Database 18c introduced a new feature called Centrally Managed Users (CMU) to allow simplified database user management through integration with Microsoft Active Directory (AD). This is an exciting and much-needed enhancement. Previously, complex additional tiers such as Oracle Unified…

Read More >
Page 1 of 41234