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

Aug 27

Oracle July 2020 Critical Patch Advisory – PL/SQL detailed changes

Oracle July 2020 Critical Patch Advisory changed objects performed by each database patch. For more details and the catalog, check the main post: Dissecting 200714 BP, PSU, RU and RUR What exactly changed for each? (click to see detailed line changes) 11.2.0.4 SYS.DBMS_RCVMAN – PACKAGE BODY 11g (BP) SYS.DBMS_RCVMAN – PACKAGE BODY 11g (PSU) 12.1.0.2 …

Continue reading

Aug 27

Dissecting 200714 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. The following patches were analysed: 11.2.0.4 11.2.0.4.200714 DB PSU 11.2.0.4.200714 Exadata Bundle Patch 11.2.0.4.200714 OJVM PSU 12.1.0.2 12.1.0.2.200714 DB PSU 12.1.0.2.200714 Exadata Bundle Patch 12.1.0.2.200714 OJVM PSU 12.2.0.1 12.2.0.1.200717 …

Continue reading