I posted recently How to Convert Non-CDB to PDB using Autoupgrade but I thought was good to know how it was done before Autoupgrade and also, to see how to do it in case you dont want to use Autoupgrade (even though I really reocmend it, is much more simple and specially easy to scale... » read more
If you didn’t hear it enough already, Multitenant and Pluggable Databases (PDBs) are here to stay. In fact, 21c (already here for Cloud users) is already the first "Only Multitenant" Version. So, what do you do with all those Non-CDB systems you didn’t want to convert to PDB? Easy, just Migrate them to your CDB.... » read more
When I created my RAC lab, I decided to create my 19c Databases ORACLE_HOME using the name "../19.3.0/dbhome_1" since it was 19.3 version, but of course, after last patching when I updated the system to 19.7, that didn’t make much sense. I tried to follow the document How to move RAC Database ORACLE_HOME from one... » read more
Is always nice to have some test systems where you can do testing and even find some inconsistencies between system versions behaviour, specially when we talk about new features. I recently watched a video from the fantastic channel Oracle Database Upgrades and Migrations related to Online Datafile movement which started in 12c For some reason... » read more
Since 11g is not longer supported, there are high chances people are looking for different and easy ways to upgrade their old Databases to a supported version. If that is the case, there is no easiest method than Autoupgrade. Now, with the latest version (at the time of writing this is version 21.1.2 / date... » read more
After publishing the post Oracle Database monitoring with Grafana Hozefa Palitanawala made me aware of one his projects inside Oracle: Oracle Enterprise Manager App for Grafana and how similar in a way was to what I was trying to do using the Oracle_Exporter for Prometheus and Grafana Like I always say, the best way to... » read more
I already did the OEM Installation and another post about How to add Targets in OEM but since I needed to have at least Oracle Enterprise Manager 13c Release 4 Update 7 for a new project (coming soon™), I decided to create this post about Updating OEM 13R4. In order to do the OEM update... » read more
![Failing to increase Database processes parameter [Failing 101]](https://project42.site/wp-content/uploads/2021/02/fail-1714367_1280-360x240.jpg)
Welcome to "Failing 101 class" Since the start of Project 42, I always wanted to have a "section" or "articles series" where I show some of those mistakes we all make and focus on how to try to avoid them instead of just mentioning the specific error and how to resolve it, or those times... » read more
Has been a while since I got to use Grafana, and since I decided to reinstall OEM, I have decided to try to monitor the Oracle Databases using Grafana Just to clarify, this is just a test to get to understand Grafana and other components like Prometheus, not something that could be consider in your... » read more