- ORA-1830 / ORA-06512 While upgrading to 12.1.0.2 October 16th, 2016
The other day I was running an upgrade for a client that is using ACLs ( Access Control Lists) from 11.2.0.3 to 12.1.0.2, and if you have been doing upgrades to 12c, you know that when running the catctl.pl -n 4 catupgrd.sql it entails 73 steps. So this upgrade failed in step ...
Read more about this post - OTN Appreciation Day : Recovering Tables and Table Partitions from RMAN Backups October 11th, 2016
As some of you may know , one of my very first errors back when I was using Oracle RDBMS 9.2 was to drop a table from production instead of development just for not following FIT-ACER , but back then recovering a table was not as easy , as you had ...
Read more about this post - La Macchina Va Dove Vanno Gli Occhi – Parte 2 September 15th, 2016
Estos últimos años han sido una montaña rusa de emociones, de cosas buenas y no tan buenas, pero también han sido unos años lleno de mucho aprendizaje, madurez y no voy a platicar sobre esto aquí, ya que algunos de ustedes ya saben acerca de ello y mis luchas a través de ...
Read more about this post - La Macchina Va Dove Vanno Gli Occhi – Part 2 September 14th, 2016
These past few years have been such a rollercoaster of emotions , of good and not so good things, but they have also been years of hard core learning experiences and I won’t go here about them, as some of you already know about them and my struggles through them ...
Read more about this post - OOW15 : What to do and What to See at Oracle Open World 2015 October 16th, 2015
This year it was delayed by 1 month and it is going to be a cold time in San Francisco, but that doesn’t mean it’s not going to be a fun time.
To those who will be their first time attending , it can be a bit overwhelming of what can ...
Read more about this post - Error in EM12c using emcli create_service_template September 29th, 2015
This will be a small post regarding creating an error I had today regarding Schema as a Service template with EM12c emcli . While creating today a service template , I had an error that showed me nothing more or where I could look for it “Validation error(s) occurred. Resolve ...
Read more about this post - Are you ready to be a private cloud service provider? August 19th, 2015
When defining what is a cloud service, we need to know that it is not a technology per se, but its an architectural and operational paradigm. It is a self-service computing environment offering the ability to create, consume and pay for services. In this architecture, computing resources are elastically supplied from a ...
Read more about this post - My journey on becoming an Oracle ACE (UKOUG Magazine) July 21st, 2015
Today is just a short post , as today an article done on me was published in the UK for UKOUG Oracle Scene on how I became an oracle ACE
UKOUG Oracle Scene
Read more about this post - RMAN 12cR1 : Dile adios a tu respaldo cuando haces un DROP de tu PDB – Parte II June 04th, 2015
En mi última entrada en mi blog de Pythian (aquí en español) antes de unirme a Oracle, hable de lo que ocurre si intentas recuperar una BASE DE DATOS “PLUGGABLE” si haces un DROP PLUGGABLE DATABASE en 12cR1, para no hacer la historia larga , no vas a ser capaz de restaurar / recuperar tu ...
Read more about this post - EM12c : Login to GUI with the correct password causes authentication failure May 19th, 2015
So the other day I was trying to login to my EM12c R4 environment with the SSA_ADMINISTRATOR user, and I got the error :
Authentication failed. If problem persists, contact your system administrator.
I was quite sure that the password that I had was correct, so I tried with the SYSMAN user ...
Read more about this post - Quick Tip : oracle user ulimit doesn’t reflect value on /etc/security/limits.conf May 01st, 2015
So the other day I was trying to do a fresh installation of a new Oracle EM12cR4 in a local VM, and as I was doing it with the DB 12c, I decided to use the Oracle preinstall RPM to ease my installation of the OMS repository database
# yum ...
Read more about this post - Como mover un datafile en Oracle 12c R1 March 31st, 2015
Aquí les voy a pasar un tip rapido de como en Oracle 12c R1 podemos mover un datafile sin tener que bajar la base de datos o poner el tablespace al que pertenecía el datafile en modo offline.
Para este ejemplo, voy a usar OMF (Oracle Managed Files), pero también lo ...
Read more about this post - Como Recuperarse del error ORA-30012 cuando clonas una BD de 20 TB con RMAN March 24th, 2015
Hace algunos días dentro de mis tareas diarias, tenia pendiente una clonacion de una bd, quizá la mas grande bd que he clonado, alrededor de 20 TB, asi que hice mi tarea, prepare el ambiente target, revise que la base de datos target se registrara en el listener, valide los ...
Read more about this post - Yes, I understand that every life must end… March 19th, 2015
Ever since I listened in my ‘teens to the song “The Impression that I get” by The Mighty Mighty Bostons, I have always been hoped that a situation like that stays as far away as possible from my life, but as is life, you don’t get what you wish for.
This ...
Read more about this post - Cassandra 101 : Understanding what is Cassandra March 12th, 2015
As some of you may know, in my current role at Pythian, I am tackling OSDB and currently Cassandra is in my radar. So one of the things I have been trying to do is learn what Cassandra is, so I’m going to share a bit of what I have ...
Read more about this post