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.
Read more about this post
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 ...
This week I had the opportunity to path EM 13c with Release 4 Update 6 (13.4.0.6) and I won’t lie, this post is more for me than anything else, so that I have in handy the steps I took to patch EM. One of the things I did ...
So this is a post that was in draft mode for almost 1.5 years. But even though that I know most clients are no longer in 11.2.0.4 , this is valid for anyone that still are and are thinking of an upgrade from 11.2 to 12/18/19.
I had been ...
This will be a short entry, but hopefully it will help you if you face the error ORA-01722 while doing an upgrade .
Today I was doing an Oracle RDBMS upgrade from 12.2 with DST 34 to 19.7 with DST 35 and ...
I thank you for coming back to this series. I wrote a couple of weeks the first part of the series and I was going to write for part II the automation with Ansible of the first part. But since there is very little blog posts on ...
About a year ago I worked on a project with some awesome teammates (Simon Pane and Karun Dutt) to work on a POC to move their Oracle environment into Google Cloud. These are some of the things I learned and this series will guide whoever is wanting to ...