Oct 20

SPOUG 2020 – Deep dive into Oracle Cloud metadata

Click here to download my session slides. 0

Oct 03

How to access internal OCI DBaaS backup Object Storage bucket

This article will show how can you access the data that oracle stores in the internal hidden buckets, mainly used for “*aaS” backups. Update: Oracle has now an official tool for that: MV2BUCKET. It’s fully supported and available in the MOS note below. Consider using it instead of the manual approach:(OCI) mv2bucket – Oracle Managed …

Continue reading

Oct 03

Enable YUM in OCI DBaaS Compute Instances

If you have some DBaaS computes nodes in your OCI, you will note that they don’t come with any YUM repo configured by default. This is purposely architect to avoid you from installing or messing the system that you should be using “As a Service”. [root@db19c ~]# yum install swift Loaded plugins: versionlock There are …

Continue reading

Oct 02

OCI-21500: internal error code, arguments: [kpcerecv: auth], [9], [], [], [], [], [], []

Those days, for one of my customers, I was having a bizarre oracle connection error, where the Oracle Client connecting using sqlplus was calling a package procedure and this error was being returned: [user@machine ~]$ sqlplus /@dbname SQL*Plus: Release 18.0.0.0.0 – Production on Thu Sep 10 00:07:43 2020 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle. …

Continue reading

Aug 27

DBMS_PDB arriving on 11.2.0.4!

If you follow my CPU cycle dissect articles, you will note that a new package appeared on 11.2.0.4 on the EXA Bundle Patch (still not available with the PSU). DBMS_PDB! Until today, the only way to upgrade 11g to any 12+ PDB using the “plug way” would be following this approach: Of course there are …

Continue reading