28 Mar How to clone an Oracle Home in 19c
This technique will help you clone an ORACLE_HOME in 19c and onwards ...
Posts in English
20 Apr Upgrade Oracle GI from 12.1 to 18.5 fails and leaves CRS with status of Upgrade Final
How to fix the status of the Oracle GI crs when it is in UPGRADE FINAL after a failed upgrade from 12.1 to 18.5...
26 Jan Creating a 12.2 Oracle Cloud Service
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...
21 Jun EM13cR2 Installation Failing on BI Publisher configuration
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 . I first looked...
10 Apr Error ORA-01033 after doing a switchover in a 12.1 RAC environment
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...
22 Jan ORA-30926 while using impdp over a database link
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 type TABLE_EXPORT/TABLE/COMMENT Processing object type...
16 Nov Parece Impossível but it wasn’t thanks to you :)
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...
09 Nov RMAN and archived redo log failover
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...
16 Oct ORA-1830 / ORA-06512 While upgrading to 12.1.0.2
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...
11 Oct OTN Appreciation Day : Recovering Tables and Table Partitions from RMAN Backups
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...