Dissecting 190716 BP, PSU, RU and RUR

I am quarterly writing a post dissecting the changes implemented by Oracle CPUs so we can understand better the modifications implemented by Oracle in our Databases. To check previous changes, follow the links below: Dissecting 190416 BP, PSU, RU and RUR Dissecting 190115 BP, PSU, RU and RUR Dissecting 181016 BP, PSU, RU and RUR …

Continue reading

Oracle Database Proactive Patch 12.1.0.2.190716 failing with ORA-04068 ORA-04061 ORA-04065

Those days, I was updating some of my lab environments running Oracle Database 12.1.0.2 to the 190716 quarterly update Bundle Patch. However, during the Datapatch execution phase, I was getting some ORA errors. Patch 29496791 apply (pdb CDB$ROOT): SUCCESS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29496791/22993732/29496791_apply_ORCL_CDBROOT_2019Jul31_11_55_12.log (no errors) Patch 29496791 apply (pdb PDB$SEED): WITH ERRORS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29496791/22993732/29496791_apply_ORCL_PDBSEED_2019Jul31_11_58_00.log (errors) Error at …

Continue reading

Deploying a highly available MySQL Cluster with DRBD on OCI

This tutorial walks you through the process of deploying a MySQL database to Oracle Cloud Infrastructure (OCI) by using Distributed Replicated Block Device (DRBD). DRBD is a distributed replicated storage system for the Linux platform. PS: This post was based in many other articles that I've read over internet and I adapted them for OCI. …

Continue reading

Value for property: DBUserName for credential ID=SQLCreds has an invalid format

Those days, while testing Oracle Management Cloud Service (OMC), I was trying to deploy the agent to monitor my Oracle Database, but it was failing with "Value for property: DBUserName for credential ID=SQLCreds has an invalid format". [oracle@test bin]$ ./omcli add_entity agent /home/oracle/agent_json/entity.json -credential_file /home/oracle/agent_json/credential.json Oracle Management Cloud Agent Copyright (c) 1996, 2019 Oracle Corporation. …

Continue reading

How to learn Oracle Cloud and take 3 certifications per month with your ULS

In this article I will give a quick walk-though of the steps you can take to achieve some of the cool Oracle Cloud certifications that are being offered with about 1-2 hours of studies per day and an ULS subscription. Recently, I've noticed that oracle is offering many new certifications for their cloud PaaS and …

Continue reading