Author: Simon Pane

Oracle Database 12c: PSUs vs Database Proactive Bundle Patches

Simon Pane, Pythian Database Consultant, compares PSUs and Database Proactive Bundle Patches in Oracle 12c.

Read More >

Changes to DBCA Patch Application Behaviour Causes PDB Cloning to Fail

Simon Pane, Pythian Database Consultant, illustrates how changes to DBCA patch application behaviour cause PDB cloning to fail.

Read More >

Issues with Oracle Secure External Password Stores

Simon Pane, Pythian Database Consultant, Illustrates how to properly lock-down and harden scripts that use Oracle Wallets and Secure External Password Stores (SEPS).

Read More >

Securing Oracle Monitoring and Backup Scripts

Simon Pane, Pythian Database Consultant, demonstrates how to secure backups and monitoring scripts using an Oracle Wallet and Secure External Password Store.

Read More >

Oracle Upgrade Failures due to METHOD_OPT and XDBCONFIG

Background I recently experienced a problem when upgrading an old Oracle 10.2.0.4 database to 11.2.0.4 that had no matches in a My Oracle Support (MOS) or Google search. The problem presented itself initially when upgrading as the following error was…

Read More >

Part 3: Comparing Oracle Cloud Database Backups Options

Comparing Oracle Database Backup Service (ODBS) and Oracle Secure Backups (OSB) to Amazon Web Services (AWS) This is part 3 of a 3 part series on “Getting Started with Oracle Cloud Backups”. Part 1 covers setting up RMAN to backup…

Read More >

Part 2: Oracle Cloud Backups to AWS S3

Getting Started with Oracle Cloud Backups – Amazon Web Services (AWS) This is part 2 of a 3 part series on “Getting Started with Oracle Cloud Backups”. Part 1 covers setting up RMAN to backup directly to the new Oracle…

Read More >

Part 1: Oracle Cloud Database Backup Service

Getting Started with Oracle Cloud Backups – Oracle Cloud Database Backup Service (ODBS) This is part 1 of 3 in a series on “Getting Started with Oracle Cloud Backups”. Part 1 covers setting up RMAN to backup directly to the new…

Read More >

Making Existing SQLPLUS Scripts 12c and Container DB (PDB) Compatible

Oracle 12c introduces new catalog features including CDB_ dictionary views (which include a CON_ID column) superseding the DBA_ views that most DBA sqlplus scripts are based upon. However, existing DBA sqlplus scripts can easily be modified using just a few…

Read More >

Recovering an Oracle Database with Missing Redo

Background I ran into a situation where we needed to recover from an old online backup which (due to some issues with the RMAN “KEEP” command) was missing the archived redo log backups/files needed to make the backup consistent.  The…

Read More >
Page 1 of 212