I woke up this morning and did what I do most days – doomscroll through twitter. One of the benefits of being in the US is that there are usually some interesting discussions going on with people I follow in Europe. I saw an interesting question from Martin Berger: I’ve had my fights with datapatch… Read More »
When moving from one system to another, one of my favorite migration methods is using data guard. It has its restrictions – the destination should be the same platform (exceptions noted in MOS note #413484.1), same version unless you’re performing an upgrade, and that a block-for-block copy of the database is acceptable. Utilizing data guard… Read More »
When logging in to an OCI tenancy, I noticed something interesting – there was a message bar at the top of the console reporting “Unusual traffic detected.” It turns out that there were a couple of instances in a compartment that were showing signs of potential compromise. Here’s the alert that we received when we… Read More »
I spoke with a customer that mentioned they were moving an Exadata rack from one datacenter to another and they had a few questions about what needed to change in order to complete the move. The customer wanted to make the move as much of a “lift and shift” as possible, avoiding the need to… Read More »
When upgrading databases, my preferred method of late has been the autoupgrade tool. Autoupgrade gives DBAs the ability to upgrade databases in batches, automatically performing prechecks, postchecks, and custom database tasks during the upgrade process. Autoupgrade can be downloaded from MOS note #2485457.1, and tests shown here used the most current version at the time… Read More »
As part of the process to get an Exadata rack ready for running 19c databases, many clusters have to go through an upgrade from Oracle Linux 6 to Oracle Linux 7. As part of that upgrade, Oracle took the opportunity to make several configuration changes for security purposes. One of those changes relates to the… Read More »
As part of an ongoing project, I’ve been performing a fair amount of upgrades to 19c on Exadata systems. Several of those systems are virtualized, running Oracle VM (based on Xen). I’ve previously mentioned Oracle’s oedacli tool that can be used to make upgrades easier, and it’s been very useful once you are familiar with… Read More »
One of the cool things that Oracle has done with Exadata is give users the ability to upgrade from Oracle Linux 6 to Oracle Linux 7 with an in-place upgrade process. This comes automatically when you upgrade the Exadata compute image from 18c to 19c. Upgrading the compute nodes to 19c give you the ability… Read More »
As part of the Oracle Exadata Deployment Assistant (“OEDA”), Oracle includes a command line utility to read and modify the XML files used for deployment of an Exadata cluster. Typical use cases are to install additional Oracle database versions, or to create multiple databases before deployment. There are several additional features included for virtualized clusters,… Read More »
I have recently been installing Oracle Enterprise Manager at several sites, and one of the key requirements has been to ensure that the installation isn’t using insecure HTTPS protocols. Securing the OMS and agents typically consists of two components – ensuring that only secure SSL ciphers are being used, and shutting down protocols that have… Read More »