Oracle

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

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. SQL> select histogram, count(*) from dba_tab_columns where histogram <> 'NONE' group by histogram order by 2;(…)

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