Author: Simon Pane

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 >

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