Jérôme Dubar has more than 25 years of IT experience, including 20 years specializing in Oracle Database technology. His expertise covers database architecture, licensing, high availability (RAC), disaster recovery (Data Guard, Dbvisit), backup (RMAN), performance tuning (AWR/Statspack), and migration and consolidation projects, particularly with Oracle Database Appliance (ODA), Multitenant, OLVM, and Delphix. Prior to dbi services, he was Database Team Manager and main consultant at a Franco-Belgian IT services company for seven years, and has taught Oracle Database courses for years. He holds a Computer Engineering degree from Lille Sciences and Technologies University. His industry experience covers public sector, retail, industry, banking, health, and e-commerce.
Introduction Multitenant brings new possibilities regarding Oracle databases, and one of them is to move a database from a container to another quite easily. When containers are on the same server, it’s very easy, but when the containers are on different servers, you will need to use a database link or an RMAN restore. But there is also another solution…
Introduction As virtualization is available for all ODAs now, you could ask yourself if it’s a good idea to use this virtualization or not. Databases can be created as bare metal, but also within a DB System for better isolation. And both can be used on the same ODA. If you’re looking for how to deploy an ODA with KVM…
Introduction RMAN backups are not a hot topic today. This is because it didn’t evolve that much in 12c/18c/19c, and most of the databases are now protected by a good backup strategy since years, and no changes are needed. Furthermore, Disaster Recovery solutions are more and more deployed, and all the flashback technologies embeded in the database are well known.…
Introduction Cloud often raises in the top 3 solutions when thinking about Oracle infrastructure renewal. For obvious reasons: you do not need to buy any server, platform is already available, you pay as a subscription, you drastically reduce time to go to production and you can scale up and down. Oracle Cloud Infrastructure, or OCI, is a Cloud provider you…
Introduction Benefits of going into the Oracle Cloud (OCI) are clear for most of us: no more datacenter and hardware to manage. But what else? On OCI, you can also decide to get rid of part of the DBA tasks (the less interesting ones, for sure). To create your Oracle database environment, you need to choose among these 3 solutions…
Introduction Patching an Oracle Database Appliance is sometimes quite tough and you often struggle to solve failures at different steps. Regarding ILOM and BIOS patching errors, a simple workaround is possible. Errors when patching ILOM and/or BIOS This is something I recently had on an ODA X7-2S when trying to apply patch 19.11. Patching of the test server was OK,…
Introduction Until now, High-Availability (HA) ODAs could have been deployed either in bare metal or in virtualized mode. Virtualized mode means that instead of installing a classic Linux system on the nodes, an OVM hypervisor (based on Xen) was deployed. This hypervisor had at least one VM, a special one called ODA BASE, holding all the databases and having direct…
Introduction Building an Oracle infrastructure today without thinking about a Disaster Recovery solution (DR) is quite rare. This became obvious that a backup or a dump will not help if you do not know where to restore or import once your production server is down. And restoring a backup is definitely not the fastest way to bring back your database…
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…
Introduction In an Oracle database, services have multiple purposes: identifying group of users prior authenticating them enabling/disabling access to a database for particular groups managing preferred nodes on a RAC configuration redirecting users to the primary after a switchover/failover when using Data Guard or Dbvisit Standby redirecting read only connections to Standby database with Active Guard option A customer asked…
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…
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…