I tested some of the Vagrant projects made by Tim Hall a while ago (it was this blog very first post), but I never got to use it too much since they were created to be used with VirtualBox. Since I decided to get rid of my old lab and create a new one, I... » read more
![Creating a Standby on 21c [Single Instance]](https://project42.site/wp-content/uploads/2021/09/Standby_DBCA_21c-360x240.png)
For this post, I just wanted to test the same DBCA option we saw in the past to create Standby but this time on 21c. The first thing I have to clarify is that I will be using rac1-node1 to host the 21c primary database (cdb21) and rac1-node2 to host our new Standby (cdbst21). The... » read more
I was wondering the other day how can I easily upgrade a OL7 to OL8, and looks like Oracle has the exact tool for the process: Oracle® Linux 8 Performing System Upgrades With Leapp This is the system I will try to upgrade: [root@OL7 ~]# head -1 /etc/*rel* ==> /etc/oracle-release <== Oracle Linux Server release... » read more
If you follow the right Oracle people, you probably already know that Oracle just released Oracle Linux Automation Manager: Your #Ansible automation engine might be already there, included with your Oracle Linux subscription… https://t.co/RPZw37yOvs pic.twitter.com/aQZInFcUsv — Ludovico Caldara (@ludodba) September 6, 2021 My understanding was that access to it required ULN access, so there was... » read more
![Installing Oracle 21c Database on Linux [Single Instance]](https://project42.site/wp-content/uploads/2021/08/21c-246x240.jpeg)
After some time of been available on the cloud, 21c Database is now ready to install on premises (Linux version for now) @GeraldVenzl – Aug 13 You can read more about it from the usual suspects like Mike’s blog: Oracle Database 21c is available for download on Linux The first thing we need to do... » read more
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
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
![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