Author: Simon Pane

Background One of the nice things about so many web apps these days is how easily they integrate with Google authentication and Single Sign-on (SSO). This is thanks to web-based authentication and authorization technologies such as SAML and OAuth. So…

A few years ago I wrote an article on getting started with the Oracle Database Backup Service which can be found here. It’s no surprise that in the last few years things have changed significantly.  Trying to use this service…

Oracle is implementing a cloud first approach and hence the newest releases such as Oracle Database 18c first appear in the Oracle Database Cloud Service (ODBCS).  But only in the Container DB architecture for this PaaS offering.  However, that doesn’t mean…

Background As an Oracle Cloud user using it for my own purposes (mostly just testing), I’m very careful to always shut down services when not required so I don’t incur unnecessary charges. However, I’m always just a little bit worried…

I recently tried to reactivate an Oracle Cloud Account and it turned out to be quite a bit more difficult than anticipated. The purpose of this article is to assist others in this situation so they can go through the…

One nice new feature of Oracle Database 18c is that schemas can be created without a password. These are called “Schema Only Accounts“. This new functionality is pretty simple and is a nice step forward that can allow administrators to…

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…

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…

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…

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…