Oracle

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(…)

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(…)

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.

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(…)

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(…)

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(…)

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(…)

OCI connected to your personal network – quick&easy example with open source firewall ‘IPFire’

Introduction & why attaching your personnal network to OCI (Oracle Cloud Infrastructure) You want to use your existing tools and infrastructure, but you need high internet performance for your Oracle environment – the combination of on premise and OCI may(…)

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(…)

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(…)