Author: Simon Pane

Using Oracle Wallets and SEPS with Perl, JDBC, and ODBC

A few years ago I wrote a couple of popular blog articles on using Secure External Password Stores (SEPS) and Credential Wallets to manage passwords used by scripts for database connections: Securing Oracle Monitoring And Backup Scripts Issues With Oracle…

Read More >

Oracle’s Database Security Assessment Tool (DBSAT) Version 2 (2.0.1)

Background Oracle recently released a new version of their Database Security Assessment Tool (DBSAT) – version 2.0.1. This is a welcome update as it’s been a while since the initial release in 2016. In fact, the tool hasn’t been enhanced…

Read More >

Coming to UKOUG 2017? Meet up with Pythian

UKOUG Applications Conference & Exhibition, Tech17 is just around the corner. The event will take place December 4-6, 2017 in Birmingham England. It is the largest gathering of UK Oracle Database professionals, and we’re really looking forward to it! Pythian…

Read More >

Standardizing the Oracle GoldenGate Home Path (OGG_HOME)

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 >

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 >
Page 2 of 3123