Otras Tecnologias

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 ...

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 ...

A few weeks ago I was working on a GI upgrade from 12.2 to 19.6, but after running the upgrade in node 1 +asm1(19c) does not see +asm2(12c) .

Below you will see what I did and how it was fixed.

I started running the prechecks and everything passed successfully.

In Oracle 19c the way that we clone an Oracle Home has changed. Before you had to zip or tar the original ORACLE_HOME , untar to the desired location and use the script clone.pl. So it you try to use it in 19c you will get the message ...

A couple of weeks ago I was working on a two node Oracle Grid Infrastructure upgrade from 12.1 to 18.5 and everything was going great as both rootupgrade.sh scripts ran correctly, so the only thing pending to run was the gridSetup.sh -executeConfigTools  command, but that failed in the ...

RAC Attack es un libro que ha sido escrito por varias personas en el ámbito de Oracle y que tu eres libre de editar y contribuir, pero una de las quejas que existía es que no había una versión en español, y es por eso que ...