Infrastructure at your Service

Category

Oracle

Alain Fuhrer

After startup database with srvctl, sqlplus as sysdba results in ORA-12547: TNS:lost contact

By | Database Administration & Monitoring, Oracle | One Comment

A few days ago a customer called me, that he have a strange issue with a new created database in a oracle restart configuration with 19c. Problem The customer has patches his 19c Databases with the newest RU and afterwards he get some strange issues in the oracle Restart integration. The Tasks that were done are Install new Oracle Home (u01/app/oracle/product /19.0.0/dbhome_1) Patch new Oracle Home with newest RU for 19c stop database modify oracle…

Read More
Alain Fuhrer

Auto Upgrade of non CDB to PDB with autoupgrade.jar in Oracle 21c

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

Since Oracle 21c it is possible to convert the non CDB database into a PDB directly during the upgrade using the Oracle Autoupgrade Tool. This is an important enhancement, because with Oracle 21c the non CDB architecture is desupported, which means that with an upgrade to 21c a conversion is mandatory. Let’s test if this new feature really works and what needs to be considered. Work done by autoupgrade utility Check and Prepare Source non…

Read More
Marc Wagner

Nutanix Era with oracle databases : Part 2 – Create an oracle database template VM

By | Oracle | No Comments

This is the part 2 of Nutanix Era blogs related to the use with Oracle databases. Before using Nutanix Era with Oracle and be able to provision oracle databases, we need to create a template VM. To do so, we will need to use prism. This template VM will only be used as a reference each time we will provision a database mainly to get the operation system and the Oracle environment. The cpu cores…

Read More
Marc Wagner

Nutanix Era with oracle databases : Part 1 – Introduction

By | Oracle | No Comments

I’m currently setting up a lab for Nutanix Era in order to be able to provide some presentation on this subject and see how Nutanix Era interacts with Oracle databases. I therefore thought it would be certainly helpful and a good opportunity to share the feedback I’m getting from this experience. The lab has been built using Nutanix Cluster free trial integrated with our AWS Cloud account. This fist blog intends to provide only a…

Read More
Jérôme Dubar

ODA: Quickly solve ILOM and BIOS update errors

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

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, but patching the production server on a week-end was not OK. I needed to find…

Read More
Clemens Bleile

ODA 19.11.: ORACLE_HOMEs on ACFS

By | Oracle | 4 Comments

Introduction Beginning with Oracle Database Appliance (ODA) 19.11. the ORACLE_BASE and ORACLE_HOMEs are created on ACFS. That’s good news, because there is much more space on ASM than on the internal disks, i.e. no space issues with /u01 anymore. So how does it work? ORACLE_BASE and ORACLE_HOME on ACFS When installing an ODA from scratch then ORACLE_BASE and ORACLE_HOME are already on ACFS. See an example of a freshly installed ODA X8-2M: [[email protected] ~]# odacli…

Read More
Jérôme Dubar

Deploying a KVM-based virtualized X8-2M ODA

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

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 path to ASM disks. Other VMs could be created, not for databases but for applications,…

Read More
Marc Wagner

oracle update-dcscomponents failure during ODA patching to 19.11

By | Oracle | No Comments

You might know that since ODA 19.10, the ODA metadata database is now stored in a MySQL database and not in the apache derby database any more. During a patching to 19.10 or 19.11 from a release earlier than 19.10, the apache derby database will be migrated to a mysql database. This is performed during the odacli update-dcscomponent command. Starting 19.10, DCS Agent will then use MySQL server to display any metadata information, as for…

Read More