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
![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
After my recent OEM 13.4 Installation I needed to start adding targets to it. Like previously, I just followed Oracle-Base article to complete the same: Oracle Enterprise Manager Cloud Control 13c Post-Installation Setup Tasks I added the Software Library location in the OEM host, but skipped the MOS configuration and Update, to go directly to... » read more
With the dead of Adobe Flash Player, I decided it was a good time to get a new OEM system so I can test OEM without flash and test couple of things on it. With this guide just wanted to make sure I have all the details in case I need to make a new... » read more
One of the best things about the Oracle Community is the amount of people willing to share cool information and tools they develop on their own. I guess we could say "Sharing is caring" 🙂 One of the people you should start following (but I’m sure you already do..) is Kamil Stawiarski. He recently created... » read more
![DML Operations over Standby in Active Dataguard [19c feature]](https://project42.site/wp-content/uploads/2020/12/DML-Redirect-360x240.png)
One of the new Features for 19c database is the possibility to execute DML operations (INSERT, UPDATE, DELETE…) over a Standby in a Active Dataguard configuration. The operation itself won’t be actually executed in the standby, but redirected to the primary where will be executed and then apply in the standby by the Recovery Process.... » read more
![Standby Automatic Flashback [19c feature]](https://project42.site/wp-content/uploads/2020/12/Automatic_flashback-360x240.jpg)
One of the new Database 19c Features is the possibility of automatically Flashback the standby database if the Primary has been Flashback. There are couple of requisites though, the Standby has to have Flashback enabled, and in order for the Automatic flashback to start, the standby has to be mounted Lets do a quick test... » read more
![The New AUTO_ONLY option for USE_LARGE_PAGES parameter [19c feature]](https://project42.site/wp-content/uploads/2020/10/Screenshot-2020-10-31-at-15.08.03-360x240.png)
Setting up the memory of a Database is always a process that requires planification, specially if you want to get the maximum of your server and setup Memory Huge Pages in your Linux system, which is recommended. The concern is that other applications/processes wont be able to use that portion of memory, causing instability if... » read more