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

Aug 25

ORACHKSUM v20.03 is out!

Today I'm releasing v20.03 of ORACHKSUM! Now the tool was updated with latest MOAT369 API and also received all the July-2020 CPU cycle dictionary updates. For the ones who don't know what I'm talking about, orachksum is a tool that scans your database for malicious internal code changes (like tampering your DBMS_OUTPUT PL/SQL code), comparing …

Continue reading