Infrastructure at your Service

Tag

ODA Archives - Blog dbi services

Clemens Bleile

Oracle Database Appliance (ODA): Adjusting to the new ORACLE_BASE-setting from 19.11. onwards

By | Oracle | No Comments

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…

Read More
Mouhamadou Diaw

ODA KVM Machines : Adding a Network Interface on a Virtual Machine

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

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…

Read More
Marc Wagner

Upgrade AHF and TFA on an ODA

By | Oracle | 4 Comments

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…

Read More
Jérôme Dubar

Oracle Database Appliance 19.13: what’s new and how to patch?

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

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…

Read More
Jérôme Dubar

Move a PDB from a server to another one using NFS

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

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…

Read More
Jérôme Dubar

ODA 19.12: How can you manage DB Systems with odacli?

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

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?…

Read More
Mouhamadou Diaw

Dbvisit 10 on Oracle Database Appliance

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

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…

Read More
David Hueber

ODA update-server to 19.12 fails on Patch GI with RHP

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

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…

Read More
Mouhamadou Diaw

Oracle Database Appliance KVM Virtual Instance on ODA 19.12

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

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…

Read More