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 ...
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 ...
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 ...
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 ...
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 ...
Continuing on the GCP 101 series, I will explain how you use GCP Disk Snapshots to clone a DB in a GCP VM..
I again want to mention that first you should check with Oracle and your licensing rep on what is supported and licensed before doing any of ...
I want to start with the news that on Monday Mar 1st, I presented my resignation letter at Pythian, and after reading an article by Dave Rensin on his lessons learned at Google, I wanted to write my version of what I have learned at Pythian.
While I ...
This past weekend I was doing a production grid infrastructure(GI) Out Of Place Patching (OOP) from 19.6 to 19.8 for a client and while doing this exercise, I hit several bugs along the way (Bugs 20785766 and 27554103).
This blog post is how I solved them and hope it ...
The other day I was doing a database cloning in 11.2.0.4, from an active duplicate and got the following error ORA-19909: datafile 1 belongs to an orphan incarnation and ORA-01110: data file 1.
This is a blog post on how I solved these errors. It is worth mentioning that ...
The other day I was given the task of converting a single instance Oracle Enterprise Manager Management Service (OMS) Repository from legacy non-CDB (Container DataBase) to CDB architecture, and you will see that the steps are basically the same as converting a regular database, but just putting together ...
A couple of weeks ago a client of mine had a situation where DataGuard (DG) switchover that should have taken 5 minutes, took over 1 hour in troubleshooting and resolution. Right after the switchover completed, their application had issues connecting to the database. What we found out was ...
Oracle 19c DataGuard introduced a very cool feature which is the ability to flashback your standby automatically if you flashback your primary.
The first thing I do in this test scenario is create a table called rene.test.
Lee mas acerca de este tema
My last post was on how to do an Out Of Place Patching for Oracle GI. The next thing that I wanted to try was the rollback procedure for this methodology, but as I searched in MOS and the Oracle documentation, I couldn’t find how to rollback ...
I am going through a process of patching an Oracle Grid Infrastructure from 19.6 to 19.8 (Patch 31305339) and I wanted to try out Out Of Place Patching (OOP) for it, but since I don’t have access to their GUI environment, I proceeded to use the silent ...
The other day I was doing a fresh install of Oracle 19.3, using the binaries from edelivery , and doing some testing in that version and then patch it to 19.6. The installation and the tests went fine. What I did next is proceed with the analyze ...