Author: Simon Pane

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 >

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