All articles

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(…)

New SHA-2 functions showing up in PostgreSQL 11

A recent commit announced new SHA-2 functions coming up in PostgreSQL 11. Until now you can use the md5 function to generate hashes for test data or whatever you want. This commit adds more(…)

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(…)

Migrate Oracle Database(s) and ASM diskgroups from VMWARE to Oracle VM

This is a step by step demonstration on how to migrate any ASM disk groups from a cluster to another. May be use, with or without virtualization and may be used with storage layer snapshot for fast environment provisioning. Step(…)

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(…)

18c Read Only Oracle Home

By Franck Pachot . This is the big new feature of Oracle 18c about database software installation. Something that was needed for decades for the ease of software deployment. Piet de Visser raised this to(…)