Infrastructure at your Service

Category

Hardware & Storage

Casimir Schmid

When to secure erase storage devices? How to do it on Oracle Database Appliances?

By | Hardware & Storage, Operation systems | No Comments

TL;DR If hardware stays inside your data center, it’s ok to secure erase storage devices. If it leaves your data center (decommission, move to another location), it’s best to physically destroy (shredder) it. Storage devices are not only hard drives, solid state drives, but also the ones holding data temporarily like memory modules (RAM) and CPUs (containing caches, register, …). As a consequence, do not sell used storage devices. Main reason to follow this advice…

Read More
Jérôme Dubar

Does it still make sense to deploy a virtualized HA ODA in 2021?

By | Database management, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction Starting from version 19.11 of the Oracle Database Appliance software bundle, OLVM will definitely replace OVM server as virtualization engine. This change has quite a big impact as there will be no more virtualized specific deployment. Bare metal will come as a standard for all ODAs, and creating VMs for applications, or even databases, will be possible on top of that, for sure if you need them. And you can decide later to use…

Read More
Dieter Henig

Clone a Terabyte Database in Seconds

By | Database Administration & Monitoring, Database management, DevOps, Hardware & Storage, Oracle | One Comment

Introduction Have you ever cloned a database using RMAN? Have you ever gotten the advice not to clone during daytime to avoid performance downgrade on the entire storage or network? For a proof of concept, we wanted to evaluate a Pure Storage array in terms of feasibility and speed of database cloning by using storage-based snapshot technology. First, I want to mention that PureStorage produces Storage devices in several sizes, all based on NVMe devices…

Read More
Jérôme Dubar

ODA: Move a DB to ASM after migrating from 11g to 19c

By | Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction Modern Oracle Database Appliances still support 11gR2, but there are several drawbacks using this old version: if you want/need support for your databases, you should pay for Market Driven Support (11gR2 is even no more under extended support – it ended at the end of 2020) some ODA features will not work with 11gR2 (odacli Data Guard feature for example) the use of ACFS filesystems is mandatory As I already told you, it’s more…

Read More
Jérôme Dubar

Oracle Database Appliance: ODA patch 19.10 is out

By | Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction 4 months after the 19.9, here comes the 19.10 version of the Oracle Database Appliance patch. Let’s have a look at what’s new. Will my ODA supports this 19.10 patch? The 19.10 release will be the same for all ODAs, as usual. The oldest ODA compatible with this release is the X5-2. Don’t expect to install this version on older models. X4-2 is stuck to 18.8, X3-2 is stuck to 18.5 and V1 is…

Read More
Jérôme Dubar

How to configure additional listeners on ODA

By | Database Administration & Monitoring, Database management, Hardware & Storage, Oracle | No Comments

Introduction Oracle Database Appliance has quite a lot of nice features, but when looking into the documentation, at least one thing is missing. How to configure multiple listeners? Odacli apparently doesn’t know what’s a listener. Let’s find out how to add new ones. odacli Everything should be done using odacli on ODA, but unfortunately odacli has no commands for configuring listeners: odacli -h | grep listener nothing! The wrong way to configure a listener One…

Read More
Jérôme Dubar

Oracle Database Appliance: what have you missed since X3/X4/X5?

By | Database Administration & Monitoring, Database management, Hardware & Storage, Oracle | No Comments

Introduction ODA started to become popular with X3-2 and X4-2 in 2013/2014. These 2 ODAs were very similar. The X5-2 from 2015 was different with 3.5 inches disks instead of 2.5 inches and additional SSDs for small databases (FLASH diskgroup). All these 3 ODAs were running 11gR2 and 12cR1 databases and were managed by the oakcli binary. If you’re still using these old machines, you should know that there is a lot of differences compared…

Read More
Jérôme Dubar

How long does it take to redeploy an ODA X8-2M?

By | Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction One of the advantage of Oracle Database Appliance is its fast deployment. Most often, the initial setup of a lite ODA (with a reimaging) only takes half a day, from unboxing until a first test database is available. Trust me, it’s hard to do better. For some reason, for example if you need to patch to the latest release and you have some intermediate patch to apply before, or if you plan to change…

Read More
Jérôme Dubar

A typical ODA project (and why I love Oracle Database Appliance)

By | Database Administration & Monitoring, Database management, Hardware & Storage, Oracle | No Comments

Introduction You can say everything about Oracle infrastructure possibilities but nothing compares to experience based on the realization of real projects. I did quite a lot of ODA projects during the past years (on other platforms too), and I would like to tell you why I trust this solution. And for that, I will tell you the story of one of my latest ODA project. Before choosing ODAs A serious audit of the current infrastructure…

Read More