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…
Read More >Simon Pane, Pythian Database Consultant, compares PSUs and Database Proactive Bundle Patches in Oracle 12c.
Read More >Simon Pane, Pythian Database Consultant, illustrates how changes to DBCA patch application behaviour cause PDB cloning to fail.
Read More >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 >Simon Pane, Pythian Database Consultant, demonstrates how to secure backups and monitoring scripts using an Oracle Wallet and Secure External Password Store.
Read More >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 >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 >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 >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 >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 >