Author: Simon Pane

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…

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…

Background Oracle Database 12c brings us many new features including: the long needed ability to run OPatch and query the patch software installed in the Oracle Home programatically through SQL using the new DBMS_QOPATCH package. If you’re a DBA working…

Is SELECTing from a sequence your Oracle Performance Problem? The answer to that question is: it might be! You wouldn’t expect a sequence select to be a significant problem but recently we saw that it was—and in two different ways….