04 Apr 101 Series of Oracle in Google Cloud – Part I : Building ASM and Database
This is the first of a series that will guide whoever is wanting to test out Oracle in Google Cloud ( GCP ). In here, will create the VM, OHAS and DB....
Posts in English
29 Mar While upgrading from GI 12c to 19c +asm1(19c) does not see +asm2(12c)
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...
28 Mar How to clone an Oracle Home in 19c
This technique will help you clone an ORACLE_HOME in 19c and onwards ...
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...