Oracle

PDB upgrade from 12c to 18c

By Franck Pachot . Oracle 18c is out, in the Oracle Cloud, and the first thing I do with a new version is testing how long it takes to upgrade a previous version PDB by unplug/plug. Faster upgrade should be(…)

ODA Lite: What is this ‘odacli’ repository?

By Franck Pachot . When ODA Lite was introduced, with ODA X6-2 S/M/L, and now with ODA x7-2 S/M, a new 'odacli' was there to manage it. It will probably replace the oakcli for ODA HA as well in the(…)

How to prevent RMAN archivelog backup from log switch

When RMAN backups archivelogs, it does a logswitch before backing up all archivelogs. In some cases this log switching should be suppressed. This can be done with expression “until time ‘sysdate'”, which actually filters nothing. For example: backup archivelog until(…)

ODA – manually resetting a CPU alert using Fault Manager

While supporting since several years ODAs of different generations and versions, we faced time to time some hardware alerts sent back by the ILOM. However all of them are not related to real hardware issues and are false positive. To(…)

ODA 12.2.1.2.0: Some curious password management rules

While deploying an ODA based on the DCS stack (odacli), it is mandatory to provide a "master" password at appliance creation. The web GUI provides for that a small tooltip which describes the rules applied on password management. However it(…)

ODA X7-2S/M 12.2.1.2.0: update-repository fails after re-image

While playing with a brand new ODA X7-2M, I faced a strange behaviour after re-imaging the ODA with the latest version 12.2.1.2.0. Basically after re-imaging and doing the configure-firstnet the next step is to import the GI clone in the(…)

One command database upgrade on ODA

The 12.2 finally arrived on ODA and is now available on all generations. Modern ODAs are now supporting 11.2.0.4, 12.1.0.2 and 12.2.0.1 database engines, and these 3 versions can work together without any problem. You probably plan to upgrade some(…)

ODA 12.2.1.2.0 – VLAN Management

Virtual Local Area Network (VLAN) have become since several years a standard in enterprise class networks. Most enterprises are now segregating their network, especially for security reasons, between server and user or prod and test or applications and backup and(…)

What you can do when your Veritas cluster shows interfaces as down

Recently we had the situation that the Veritas cluster (InfoScale 7.3) showed interfaces as down on the two RedHat 7.3 nodes. This e.g. can happen when you change hardware. Although all service groups were up and running this is a(…)

CPUs: Cores versus Threads on an Oracle Server

When doing a performance review I often do talk with the DBA about the CPU utilization of the server. How reliable is the server CPU utilization with tools like top or the host CPU utilization in the AWR-report? E.g. on(…)