Category Archives: Oracle

Oracle-related content

Restarting Autoupgrade Jobs When the Instance Won’t Restart

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 »

OEDA Virtualized Cluster Discovery With SSH Keys

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 »

OEM SSL Cipher Hardening Reset After Securing OMS

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 »

Recovering ODA VMs From Lost ACFS Snapshots

This is a continuation of my previous post regarding dropped ACFS snapshots.  In this scenario, a user logged in to a virtualized ODA system and deleted the underlying ACFS snapshots for multiple virtual machines on the host.  Oracle advises how to back up and restore guest VMs on an ODA in MOS note #1633166.1. The… Read More »

Checking Flash Cache Mode in Exadata Cloud

While looking at an exachk report for an Exadata rack running in Oracle Cloud Infrastructure, I saw an interesting finding: Since this is an Oracle cloud environment, we don’t have any access to view the storage servers – they are managed and maintained by Oracle.  For several reasons, I believed this to be a false… Read More »

Changing IP Addresses on InfiniBand Network with 12.2 GI on Exadata

I was tasked a while back with modifying the IP addresses assigned to the InfiniBand network on an X6-2 rack.  We were configuring a ZFS appliance to share between 2 Exadata clusters, and we wanted to keep them on separate network ranges.  In this case, we were moving the interfaces from 192.168.10.x/22 (the Exadata default… Read More »