Home Blog in English

Blog in English

This is where you will find my latest  Blog posts in English, where I blog about Oracle,Cassandra,Tech and sometimes other Life experiences

  • ORA-30926 while using impdp over a database link January 22nd, 2017

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

    While investigating, I found that the source database had OLAP option removed and found a document 1353491.1 that I thought it could help that states that if the package DBMS_CUBE_EXP is present in SYS.EXPPKGACT$ and it does not exist it should be ... 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 one year ago that I had to be picked up in the middle of the street by a policeman and ... 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 logs when you have at least 1 archived redo log available in 1 location.

    So what I will do we have 2 locations where the online redo ... Read more about this post

  • ORA-1830 / ORA-06512 While upgrading to October 16th, 2016

    The other day I was running an upgrade for a client that is using ACLs ( Access Control Lists) from to, 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 65 with the following error (I have trimmed the output for reading purposes) :

    And the worst part of it was ... 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 to recover the tablespaces and the table dependencies and its tablespaces , and it was just a long and ... 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 and it will just seem like the same repetitive sh!t and I won’t bore you with them.

    One of the first ... 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 you can attend or what should you miss, but  one thing you shouldn’t miss are the any of  126 ... 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 these and try again.

    So looking at the ../gc_inst/em/EMGC_OMS1/sysman/log/emoms.log , I saw that in my JSON file, I was missing the workload ... Read more about this post

  • Creating an Oracle Database Cloud Service August 21st, 2015

    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 connect with sqlcli to this new service. As any cloud service, it all happens in the background, saving you from ... 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 shared pool and charged based on metered use and it uses service catalogs to provide a menu of options and ... 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



    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 and had the same error, but still wanted to verify that I had the correct password , so I tried ... 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

    I was able to install the DB without any issues, but when I was trying to do the installation of EM12cR4, an error ... 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 past Monday evening , my cousin of 27 years old passed away in a horrific car crash and now that ... 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 been able to obtain in these series.

    According to the whitepaper “Solving Big Data Challenges for Enterprise Application Performance Management” ... Read more about this post