Oracle ODA – oda-admin’s reset password no end loop 24.08.2022 by Oracle Team 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.
Oracle ODA: how to configure ILOM IP without DHCP? 19.08.2022 by Jérôme Dubar 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(…)
Oracle Patching your ODA may enable all cores! 17.08.2022 by Jérôme Dubar 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(…)
Database Administration & Monitoring, Database management, Operating systems, Oracle Configure Oracle DB for using Large Pages on AIX 12.08.2022 by Oracle Team 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(…)
Oracle Running Intel x86-64 VMs with an Oracle DB on Apple Silicon (ARM) 06.08.2022 by Clemens Bleile 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(…)
Cloud, Oracle OCI connected to your personal network – quick&easy example with open source firewall ‘IPFire’ 05.08.2022 by Oracle Team 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(…)
Oracle datapatch fails when running against an Oracle Container Database because of missing temp files in PDBs 03.08.2022 by Clemens Bleile 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(…)
Database Administration & Monitoring, Database management, Oracle A few words about the good to know MAX_IDLE_BLOCKER_TIME 30.07.2022 by Oracle Team 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(…)
Oracle Why do we still have HEIGHT BALANCED Histograms and how to get rid of them? 29.07.2022 by Clemens Bleile 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;(…)
Oracle ODA: How to use Data Preserving Reprovisioning? 22.07.2022 by Jérôme Dubar 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(…)