Infrastructure at your Service
By Clemens Bleile From Oracle Database Appliance (ODA) version 19.11. onwards the ORACLE_HOMEs and ORACLE_BASE will be created on ACFS, i.e. take space from an ASM-diskgroup instead of taking filesystem space from /u01. See this blog concerning details. If the ODA has been upgraded from a release < 19.11. to 19.11. or newer, then you usually have diag- and admin-data in 2 ORACLE_BASE-locations: /u01/app/oracle for databases created before migrating to ODA 19.11. or newer and…
In a previous blog , I was talking about virtual machines on ODA servers. Sometimes it comes that we want to add another network interface for other purpose. In this blog I am describing the main tasks to add a second network interface card on KVM virtual machine. Let’s describe the context I have an ODA X8-2M with appliance 19.12. This ODA contains virtual machines for the applications. The virtual machine only has one NIC…
TFA (Trace File Analyzer) is part of AHF (Autonomous Health Framework). Those tools are preinstalled and part of ODA (Oracle Database Appliance). As you might know patching and upgrading are normally always going through ODA global Bundle patches. AHF can, without any problem, be upgraded independently. In this blog I wanted to share with you how I upgraded TFA with latest v21.4 version. The upgrade is performed with root user. This version addresses CVE-2021-45105/CVE-2021-44228/CVE-2021-45046. For…
Introduction Patch 19.13 is now available on ODA. It’s time to test it. What’s new? This version brings October’s PSU to database and grid homes with their bug fixes, as usual. It also brings 21.4 for DB Systems (21c being an innovation release, understand just for testing). Something new that some of us have been waiting for a while, a multi-user mode for odacli tasks: you don’t need to be root anymore for managing the…
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 if you don’t want to use the previous ones: using a NFS volume. Test lab…
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 virtualization, please have a look at my previous blogpost here. What is a DB System?…
Dbvisit Standby can also be installed on Oracle Database Appliance (ODA). The installation is the same that on any other Linux box. I did an install of Dbvist 10 on an ODA 19.12 for a customer and in this blog I am describing the on an ODA steps. The configuration is below -The primary server is oda-prod-01 -The standby server is oda-dev-01 -The database name is ORCL Dbvisit should be installed on both servers (primary…
Debugging errors when working with ODA is not always the easiest thing do… 😛 It may become a bit tricky and not a straightforward process. In this blog I wanted to show you and example we faced with the debugging of a Dbsystem creation failure and how we found out the real reason it failed.
Sometimes giving a workshop is a good opportunities to test new things…this what happened to me today… 🙂 While giving an ODA workshop, I thought it was a good opportunity to test patching to the new 19.12 release. However during the update-server process we got a failure on the our ODA update to 19.12 failing on GI patch using RHP. Let’s see how we fixed it…
KVM virtualization uses a kernel-based virtual machine (KVM) to create a virtualized environment for your Linux applications.In this blog I want to share some tasks I did at a client. The client is using ODA 19.12. The databases are created on the bare metal and for the applications, we decide to create virtual machines. What do I need for a VM creation? -VMstorage for the creation of vdisks -Vdisks will be attached to the VMs…
