July 2019 archive

Jul 31

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

Jul 29

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

Jul 18

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

Jul 03

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

Jul 01

OCI - Mapping compute shapes with billing configuration

Whenever you create compute instances on Oracle Cloud Infrastructure, it's hard to correspond the shapes that you are choosing to create (eg: VM.Standard2.X) with the prices that the OCI Cost Estimator Website or even the contract that you sign with Oracle when buying credits will show to you (eg: Compute - Virtual Machine Standard - …

Continue reading