Oracle Tech

  • While upgrading from GI 12c to 19c +asm1(19c) does not see +asm2(12c) March 29th, 2020

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

    Read more about this post
  • Upgrade Oracle GI from 12.1 to 18.5 fails and leaves CRS with status of Upgrade Final April 20th, 2019

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

    Read more about this post
  • Oracle 12cR2 : RAC Attack a la Mexicana – Instalación de los binarios de Oracle RDBMS February 26th, 2019

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

    Read more about this post
  • Oracle 12cR2 : RAC Attack a la Mexicana – Instalación de Oracle Grid Infrastructure February 25th, 2019

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

    Read more about this post
  • Oracle 12cR2 : RAC Attack a la Mexicana – Configuración de OS y DNS February 18th, 2019

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

    Read more about this post
  • Oracle 12cR2 : RAC Attack a la Mexicana – Instalación de Virtualbox y OS February 15th, 2019

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

    Read more about this post
  • Creating a 12.2 Oracle Cloud Service January 26th, 2018

    Back in late June of 2015, Larry Ellison launched several public cloud services , and one of those who were included was the Public DBaaS , today I had the opportunity to try out this new service and here we will go into how to create it and how to ...

    Read more about this post
  • EM13cR2 Installation Failing on BI Publisher configuration June 21st, 2017

    This is going to be a short post as there wasn’t much information on this type of failure when searching for it.

    I was working on an Oracle EM13cR2 installation and when the installation reached 78% it failed on the BI Publisher configuration .

    Principalmente escribo este post para no olvidarme de este error, así que será un pequeño post. El otro día hice una switchover en un ambiente de RAC, que fue bastante fácil, pero después de hacer el switchover, en la Base de datos primaria continua recibiendo el siguiente error:

    I am mostly writing this so I don’t forget , it will be a small post. The other day I did a switchover in a RAC environment , which went pretty smooth , but after doing the switchover in the primary I kept getting the following error :

    The other day I was doing an import using impdp in 12.1.0.2 , and got the following error ORA-30926: unable to get a stable set of rows in the source tables.

    Starting "SYS_PYTHIAN"."SYS_IMPORT_TABLE_03": sys_pythian/******** parfile=table_import.par
    Processing object type TABLE_EXPORT/TABLE/TABLE
    Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
    Processing object ...
    Read more about this post
  • Parece Impossível pero no fue gracias a ti :) November 16th, 2016

    Ayer mientras corría aqui en Lisboa, me encontré con una manta en el exterior del Teatro Nacional D. Maria II en la Plaza de Rossio que decía “Parece Impossível” (Parece Imposible) y pensé que no podría haber encontrado una mejor señal en el día que marca un aniversario lleno de cambios, donde hace un ...

    Read more about this post
  • Parece Impossível but it wasn’t thanks to you :) November 16th, 2016

    Yesterday as I was running  here in  Lisbon, I found a sign outside the Teatro Nacional D. Maria II in Rossio Square that read “Parece Impossível” (Seems Impossible)  and I thought that I couldn’t have found a better sign on the day that marked an anniversary of changes , it was ...

    Read more about this post
  • RMAN and archived redo log failover November 09th, 2016

    This is something that you might have already known, but it’s a cool thing when using RMAN that I want to show you.

    As you may know Oracle Database has a feature called archived redo log failover, this feature allows RMAN to backup successfully the archived redo ...

    Read more about this post