This is where you will find my latest Blog posts in English, where I blog about Oracle,Cassandra,Tech and sometimes other Life experiences
- The Impact of Optimization in a Cloud Architecture March 07th, 2022
In recent years, few aspects of modern life have enterprises and techies drooling more than the cloud. The amount of cloud of data centers dominated by tech giants, Amazon, Microsoft, Google and Oracle is stagering and it is not stopping any time soon. During the Covid-19 pandemic, they have helped ...
Read more about this post - How to List All your Resources in OCI via OCI CLI February 26th, 2022
This will be a small post and is mostly for me to remember how to do it. The other day I was asked to provide all of the resources that we had in OCI , and I did try to do it via the GUI interface, but I thought that ...
Read more about this post - Script your RMAN backups using Oracle External Password Store with the SYSBACKUP privilege February 21st, 2022
As you may already know, scripting your RMAN backups and storing your connectivity credentials in the actual scripts is not a good security practice. Sometimes even hiding the actual password through another script or a mechanism for this will expose your password. I won’t go into details as of why ...
Read more about this post - ExaCC : PDB In Restricted Mode And Bind Parameter Error When Applying RU Sql Patch January 20th, 2022
A couple of weeks ago, I was helping out a teamate with a post patch issue on the ExaCC, The problem was that after applying the 19.12 RU to the DB ORACLE_HOME, the PDBs were left in restricted mode and couldn’t be opened. So my first train of thought is ...
Read more about this post - Log4Shell : A 9D Moment in The IT Industry December 15th, 2021
It has been 4 years and almost 3 months that on September 19th (19s as it is commonly known due to the day 19th and S of September) of 2017 at 1:15 PM CT México City got hit by one of the deathliest earthquake. México City is still in the ...
Read more about this post - Kubernetes 101: Understanding what is K8s (The Hardware Edition) October 22nd, 2021
Lately I have been testing the GC project “El Carro” and it came to light that I hadn’t done a 101 of Kubernetes or also known as K8s and following Christine’s post on learning something new, I think this can help out newcomers. I will be doing a couple of ...
Read more about this post - How To Do An Out of Place Patching In ExaCC via dbaascli October 13th, 2021
This will be a small post on how to do an Out of Place Patching for your database in an ExaCC environment. The documentations shows how to do it via the console, but in this example it will be a 19.11 patch via dbaascli that will be applied to the ...
Read more about this post - How To Continue A GI Patch In EXACC When It Has Failed In Node 1 September 30th, 2021
This week we had an issue when we were patching and EXACC Grid Infrastructure from 19.10 to 19.11 and the patching died when it was running the postpatch on node 1 and left the patch in a weird “ROLLING PATCH” mode as it hadn’t finished the 19.11 patching (rootcrs.sh -postpatch) ...
Read more about this post - How an ORA-01102 Error Drove Me Nuts in a 19c Environment and How It Was Fixed August 04th, 2021
This blog post is part rant and part on how I was able to fix an issue in the second instance that was failing with ORA-01102: cannot mount database in EXCLUSIVE mode when trying to start it up.
Yesterday a teamate mentioned to me that when he was trying to bring up ...
Read more about this post - ORA-00600 [kcbtse_encdec_tbsblk_1] When Duplicating PDB IN 19C July 29th, 2021
Seems that lately I have been getting all of the ORA-00600 errors possible when duplicating databases, and this is just another one in the list. This will be a very short blog post on how I worked around ORA-00600 when duplicating a PDB and TDE is enabled in the ...
Read more about this post - ORA-00600 [kpdbHashTableIns:dup] When Creating PDB in 19c July 08th, 2021
This week I was involved in an issue with a QA pluggable database refresh that is critical to business, where after the PDB clone to the QA container caused an ORA-00600 error and then the container crashed and it was not possible to start it, failing with the same ...
Read more about this post - OCI : Script to Scale Up/Down OCPUs in ExaCC May 10th, 2021
I will start this post that the script I am talking about might already be somewhere out there and even in a better version, but myself I couldn’t find it and I needed something that I could quickly put in cron.
The script I wrote is called oci_ocpu_scale.sh and I can ...
Read more about this post - Patching EM 13c to Release Unit 13.4.0.10 April 28th, 2021
This will be a small blog post to help you patch your EM 13c environment to the latest release unit, which is 13.4.0.10. Which I highly recommend, as it fixes a bug (32288282) if you are planning to upgrade from EM 13.4 to 13.5.
The first thing is to download the ...
Read more about this post - 2Q21: The Year I Joined Eclipsys April 27th, 2021
For some, this past year has been full of doubts, fears, loneliness, and even loss. I count myself as part of these “some”. But like anything in life, it has also been filled with life, happiness, and some of the greatest experiences I have had in my 42-year life.
One of ...
Read more about this post - 101 SERIES OF ORACLE IN GOOGLE CLOUD – PART IV : Setup an NFS Mount from a GCP Filestore for RMAN Backups April 20th, 2021
Staying with the GCP 101 series, I will now explain how you setup an NFS mount from a GCP filestore for RMAN backups.
I want to keep on mentioning that first you should check with Oracle and your licensing rep on what is supported and licensed before doing any of this ...
Read more about this post