Infrastructure at your Service

Tag

Oracle database appliance Archives - Page 2 of 4 - Blog dbi services

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
Jérôme Dubar

odacli create-database -io doesn’t work for older databases in 19.9

By | Database Administration & Monitoring | 4 Comments

Introduction On ODA, you create your databases with odacli create-database. You can create a complete database, and it takes about 10 minutes, and you can also create an instance-only database. It will simply and quickly create a record in the ODA registry, start the instance with a basic pfile, and that’s it. Then you’re supposed to do the next step: feed up the database with a manual restore or an RMAN duplicate. Create a 12.2…

Read More
Jérôme Dubar

Configure Data Guard with odacli on ODA

By | Database Administration & Monitoring | No Comments

Introduction I always thought integration of Data Guard was a missing feature on Oracle Database Appliance. For sure, you can configure Data Guard manually as you do on a classic server, but as an appliance, ODA should have proposed an easier way for configuring that. After years of waiting for this feature, it’s now available, and I just tested it. And I’m here to give you my feedback. Disclaimer You’ll need 2 ODAs for building…

Read More
Jérôme Dubar

ODA 19.9 software release is out

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

Introduction 6 months after the 19.6, the first 19c production release, here comes the 19.9 Oracle Database Appliance patch with major improvements. Will my ODA supports this 19.9 patch? First, the 19.9 release will be the same for all ODAs, as usual. Like 19.6, the oldest ODA compatible with this release will be the X5-2. Don’t expect to install 19c on older models. X4-2 is stuck to 18.8, X3-2 is stuck to 18.5 and V1…

Read More
Jérôme Dubar

Disk usage on ODA – Free MB and usable MB

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

Introduction Oracle Database Appliances rely on ASM to manage disk redundancy. And ASM is brilliant. Compared to RAID, redundancy is managed at the block level. For NORMAL redundancy, which is similar to RAID1, you need at least 2 disks, but it can also work with 3 disks, 4 disks, 5 disks and so on. There is no need for parity at the disk level. HIGH redundancy, which does not exist in RAID technology, is basically…

Read More
Jérôme Dubar

Oracle Database Appliance vs Oracle Cloud Infrastructure

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

Introduction Oracle Database Appliances are very popular these days. And not only among new customers for this kind of engineered systems. Almost all customers already using old generation ODAs are renewing their infrastructure by choosing again ODAs, meaning that the solution is good enough and probably better than anything else. But now, public clouds are a real alternative to on-premise servers, and Oracle Cloud Infrastructure is a solid competitor vs Amazon and Azure public clouds….

Read More
Mouhamadou Diaw

Reimaging an ODA to 19.8 Part I

By | Database Administration & Monitoring, Operation systems, Oracle | 2 Comments

Recently I was deploying some ODA X8-2M. To install the 19.8 software, I decide to reimage the server with the 19.8 image. In this blog I describe the main steps I did. First, we will need to download following patches from Oracle support website -Patch 30403643: Oracle Database Appliance 19.8.0.0.0 OS ISO IMAGE for all platforms -Patch 30403673: Oracle Database Appliance GI Clone for ODACLI/DCS stack (and -Patch 30403662: Oracle Database Appliance RDBMS Clone for…

Read More