BE SHARING

Jérôme Dubar

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

Cloud

Will [email protected] change or kill your DBA job?

20.06.2022 by Jérôme Dubar

Introduction Exadata [email protected] ([email protected]) from Oracle is an hybrid solution for customer willing a Cloud-like platform without actually being in the public Cloud. Behind cloud’s concept is a high-level management of complex stuff, like provisioning homes and databases, patching, aso.

Oracle

CIFS mounts no more compatible with ODA

14.06.2022 by Jérôme Dubar

Introduction Some of us are using CIFS mountpoints on the ODA. This is mostly for sharing files with Windows application servers. On ODA, as on other Linux setup, it works like a charm. But it ends working starting from patch(…)

Oracle

Patch 19.15 is available for your ODA

09.06.2022 by Jérôme Dubar

Introduction Patch 19.15 is now available on Oracle Database Appliance. It’s time to test it. What’s new? This version brings April’s PSU to database and grid homes with their bug fixes, as usual. It also brings latest database 21.6 but(…)

Oracle

ODA X9-2: it’s finally here!

08.06.2022 by Jérôme Dubar

Updated the 10th of June, 2022: add PMEM option on X9-2L. Introduction It’s been nearly 3 years that Oracle Database Appliance X8-2 reached the market, and in 2022 it’s still a great performer. But now it’s time for a refresh:(…)

Database Administration & Monitoring

Extract all DDL from an Oracle database

11.04.2022 by Jérôme Dubar

Introduction Extracting DDL is sometime useful for creating similar objects in another database without data. Basically everything can be extracted from a running Oracle database. The needs My customer asked me to replicate a database without any data. The goal(…)

Database Administration & Monitoring

Patch 19.14 is out for ODA: new features and how to apply

01.03.2022 by Jérôme Dubar

Introduction Patch 19.14 is now available on Oracle Database Appliance. It’s time to test it. What’s new? This version brings January’s PSU to database and grid homes with their bug fixes, as usual. It also brings latest 21.5 but only(…)

Database Administration & Monitoring

ODA 19.13: odacli update-dbhome raises DCS-10001 and PRGH-1153

28.02.2022 by Jérôme Dubar

Introduction While patching ODAs from 19.10 to 19.13, the update-dbhome could fail if some databases inside this dbhome are stopped or only mounted. Job would then stop with a DCS-10001:Internal error encountered: PRGH-1153 : RHPHelper call to get runing nodes(…)

Database Administration & Monitoring

ODA: Migrating from bare metal to CPU pools

22.02.2022 by Jérôme Dubar

Introduction Oracle Database Appliance now fully supports virtualization with KVM, and this could be interesting for some of us. If you’re using Enterprise Edition, you probably decreased the number of cores to comply with your licenses. Now you can increase(…)

Database Administration & Monitoring

Statspack with Oracle Database 19c and Multitenant

17.01.2022 by Jérôme Dubar

Introduction When it comes to performance analysis on Oracle databases, everybody think about Diagnostic Pack. This is a very complete tool and it brings much more metrics than a DBA can analyze. But there is a big drawback with this(…)