Tag: 12c

In a new 12c environment (which actually includes 18c and 19c, as per the 12c family), the datapatch failed on the following: ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 1 ORA-65108: invalid use of a cursor…

Now that we are fully into database upgrades, here is an important item to be aware of: As you may know, the Database Vault (DV) option could be reported as not installed in source when converting non-CDB to PDB, and…

Recently I needed to install Oracle 12.2 with the ASM Filter Driver for some research on an upcoming presentation. With the new image based Oracle Grid installation I expected this to be easy. To be fair, it was fairly easy,…

A step-by-step guide to enabling archivelog mode in 12c RAC database.

Fred Denis, Pythian Oracle Database Expert, explains how to rename a diskgroup.

  Oracle 12c introduced a new capability to move a partition online, without any interruptions to DML happening at the same time. But, there’s a catch. So far we’ve been able to use basic table compression without having to worry…

  Recently on a heavily used and freshly upgraded 12.1.0.2 ware-house type database, we started seeing lots of ORA-10173 dumped into the alert log. The information out there on this error is somewhat sparse, and it is often linked to…

So, it has been some time since I have patched a database. Patching seemed necessary in a 12c database used for testing, as it was having some crashing issues. As the database and GI home were both un-patched, it seemed worthwhile to…

Oracle Grid Infrastructure 12c uses a considerable amount of RAM and CPU resources; here are a few tips to shoehorn it into a 2GB virtual machine.

Background Oracle Database 12c brings us many new features including: the long needed ability to run OPatch and query the patch software installed in the Oracle Home programatically through SQL using the new DBMS_QOPATCH package. If you’re a DBA working…