Category: Oracle Database General

Oracle Database General

Oct 28

Oracle October 2020 Critical Patch Advisory - PL/SQL detailed changes

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

Continue reading

Oct 28

Dissecting 201020 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.201020 DB PSU 11.2.0.4.201020 Exadata Bundle Patch 11.2.0.4.201020 OJVM PSU 12.1.0.2 12.1.0.2.201020 DB PSU 12.1.0.2.201020 Exadata Bundle Patch 12.1.0.2.201020 OJVM PSU 12.2.0.1 12.2.0.1.201020 …

Continue reading

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 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