Autores Invitados
- The Impact of Optimization in a Cloud Architecture March 07th, 2022Rene AntunezLee mas acerca de este tema
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 transform people’s lives, supporting a change in the way we work (from home), and even how we consume ...
- How to List All your Resources in OCI via OCI CLI February 26th, 2022Rene AntunezLee mas acerca de este tema
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 what I could do with OCI CLI was much better and simpler.
This first thing that you have to ...
- Script your RMAN backups using Oracle External Password Store with the SYSBACKUP privilege February 21st, 2022Rene AntunezLee mas acerca de este tema
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 you should not do this, but you can see Simon’s post about it.
The best way ...
- ExaCC : PDB In Restricted Mode And Bind Parameter Error When Applying RU Sql Patch January 20th, 2022Rene AntunezLee mas acerca de este tema
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 to check the PDB_PLUG_IN_VIOLATIONS to see what was going on
SYS@hostname1> SET LINESIZE ... - Log4Shell : A 9D Moment in The IT Industry December 15th, 2021Rene AntunezLee mas acerca de este tema
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 process of removing and fixing buildings that were damaged by that earthquake.
On an analogy of an earthquake, the ...
- Kubernetes 101: Understanding what is K8s (The Hardware Edition) October 22nd, 2021Rene AntunezLee mas acerca de este tema
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 posts on this topic, so I hope you follow the series
I am going to try to ...
- How To Do An Out of Place Patching In ExaCC via dbaascli October 13th, 2021Rene AntunezLee mas acerca de este tema
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 database. One thing to know is that unless stated other wise, all commands are run with root
The first ...
- How To Continue A GI Patch In EXACC When It Has Failed In Node 1 September 30th, 2021Rene AntunezLee mas acerca de este tema
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) in node 1 and node 2 was still running 19.10.
What you see below is the command that was ...
- How an ORA-01102 Error Drove Me Nuts in a 19c Environment and How It Was Fixed August 04th, 2021Rene AntunezLee mas acerca de este tema
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 the second instance, in a 2 node 19.10 RAC environment, he was not able to and it was ...
- ORA-00600 [kcbtse_encdec_tbsblk_1] When Duplicating PDB IN 19C July 29th, 2021Rene AntunezLee mas acerca de este tema
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 Source PDB in a 19.10 version.
Over the last months, the team had been seeing this ORA-00600 intermittently when ...
- ORA-00600 [kpdbHashTableIns:dup] When Creating PDB in 19c July 08th, 2021Rene AntunezLee mas acerca de este tema
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 error.
I will explore in this blog post how I brought the container up, though it goes to say ...
- OCI : Script to Scale Up/Down OCPUs in ExaCC May 10th, 2021Rene AntunezLee mas acerca de este tema
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 put it in cron and scale up or down the OCPUs at a certain time of the ...
- Patching EM 13c to Release Unit 13.4.0.10 April 28th, 2021Rene AntunezLee mas acerca de este tema
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 following three patches:
- p19999993_134000_Generic.zip (OMSPatcher patch of version 13.9.4.5.0 for Enterprise Manager Cloud Control ...
- 2Q21: The Year I Joined Eclipsys April 27th, 2021Rene AntunezLee mas acerca de este tema
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 these changes has been accepting a new job at Eclipsys and I can say it is one decision ...
- 101 SERIES OF ORACLE IN GOOGLE CLOUD – PART IV : Setup an NFS Mount from a GCP Filestore for RMAN Backups April 20th, 2021Rene AntunezLee mas acerca de este tema
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 work.
I have previously built 2 VMs that I am using for these exercises and the steps are in ...