Skip to content

Oracle

Oracle Database as our consultants live it every day: installation and patching, upgrades, RMAN backup and recovery, Data Guard, RAC, performance tuning, multitenant, licensing, and engineered systems such as ODA and Exadata.

Patch ODA X8 : 19.9 to 19.11

By Mouhamadou Diaw In this blog, I describe the patching of an ODA X8 from 19.9 to 19.11. We use following patches p32790643_1911000_Linux-x86-64.zip : Oracle Database Appliance Server Patch for ODACLI/DCS Stackp30403673_1911000_Linux-x86-64.zip : Oracle Database Appliance GI Clone for ODACLI/DCS stackp30403662_1911000_Linux-x86-64.zip : Oracle Database Appliance RDBMS Clone 19.11.0.0.210420 for ODACLI/DCS stack Patching the Oracle Database Appliance Server Before starting the… 

Oracle 21c and Dbvisit 11

By Mouhamadou Diaw Dbvisit 11 is released since a few months ans now is referenced as Dbvisit Standby MultiPlatform v11 ( Dbvisit StandbyMP 11 ) for Linux and Windows.  It brings revolutionary improvements, including being able to manage both Oracle and SQL Server DR from a single GUI. In this blog I am showing how to install Dbvisit StandbyMP on… 

ODA – oda-admin’s reset password no end loop

If you are new like me in the ODA world, there is a chance that you don’t know the workaround for the ODA Administration console, asking you to reset the oda-admin’s pasword each time ! The solution is really simple. In some cases, you must accept certificats for the DCS-controller on port 7093 and DCS-agent on port 7070. Here we… 

ODA: how to configure ILOM IP without DHCP?

Introduction Once your brand new Oracle Database Appliance is racked and connected to power, the first configuration step is to setup the static IP address on the management console (ILOM). Until ODA X6-2 generation, servers were equipped with a VGA connector, and it was possible to configure ILOM IP in the BIOS of each ODA node using a keyboard and… 

Patching your ODA may enable all cores!

Introduction If you use Enterprise Edition on your Oracle Database Appliance environment, and if you don’t have unlimited licences, you probably lowered the CPU cores available on each server to dispatch your licences accross your environment. This operation is normally done after deploying your ODAs, and this number of cores could eventually be increased if you need more and if… 

Configure Oracle DB for using Large Pages on AIX

When it comes to deploying a new Oracle infrastructure, 90% of it is implemented on Linux. This makes sense, because Oracle runs very stable and performant on Linux and it is also Oracle’s own development platform. But since variety makes life interesting, I recently had the privilege to deploy a new Oracle environment on AIX for a customer.AIX is not… 

Running Intel x86-64 VMs with an Oracle DB on Apple Silicon (ARM)

For testing purposes many IT-people traditionally use Virtual Machines (VMs) on their Laptops (often on Oracle Virtualbox). Since Apple moved to its own processor type (Apple Silicon, i.e. ARM architecture), it’s no longer possible to run VMs based on Intel x86-64 on Apple ARM (e.g. on Apple MacBook Pros with M1 or M2 processors). I.e. as the Oracle Database does… 

datapatch fails when running against an Oracle Container Database because of missing temp files in PDBs

When going to 19.15. a customer hit this error when running datapatch: Unsupported named object type for bind parameter at /u01/app/oracle/product/19.0.0.0/dbhome1915/sqlpatch/sqlpatch.pm line 5849, line 4452. After anlyzing the issue it turned out to be related to what has been documented in My Oracle Support NoteDatapatch Failed with Error:”ORA-25153: Temporary Tablespace is Empty” (Doc ID 2285159.1) In our case we had… 

A few words about the good to know MAX_IDLE_BLOCKER_TIME

The increasing popularity of tools like SQL Developer and Toad, sometimes comes hand in hand with an increase of stuck sessions.This is especially seen in cases where: User A does a change (neither committed nor rolled back). Then, switches to another task, or even leaves for lunch. Then, User B updates the same row and stays there, stuck for hours.… 

Why do we still have HEIGHT BALANCED Histograms and how to get rid of them?

A customer, who is on 19c with his Oracle databases asked me recently why he still has Height Balanced Histograms in his database? E.g. In 12.1. Oracle introduced Top Frequency and Hybrid Histograms, which should replace Height Balanced histograms. There are 2 main reasons why Height Balanced histograms may still be there: 1. Top Frequency and/or Hybrid histograms are disabled… 

ODA: How to use Data Preserving Reprovisioning?

Introduction Oracle Database Appliance has a global patch available each quarter, so all the components can be patched together on a regular basis. Most of the time, applying the patch on your ODA will be OK, but sometimes you will struggle for multiple reasons. If you don’t apply patch frequently for example. Or if your ODA is heavily tuned. Or…