Author: Simon Pane

I don’t work with Oracle GoldenGate extensively but when I do I find it somewhat remarkable that there aren’t more standards with something as simple as the Oracle GoldenGate software home path (OGG_HOME). With the Oracle Database, in recent years…

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

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

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

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

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…

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…

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…

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…

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…