Author: Simon Pane

Accessing Oracle Cloud Infrastructure (OCI) using Google G Suite SSO

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…

Read More >

Getting started with Oracle Database Backup Service in 2018

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…

Read More >

Oracle 18c Non-CDB databases in the Oracle Database Cloud Service (ODBCS)

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…

Read More >

Cost management (expenditure alerts) in the Oracle Cloud

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…

Read More >

Trials and tribulations of reactivating an Oracle Cloud Account

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…

Read More >

Oracle Database 18c Schema Only Accounts

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…

Read More >

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