Category: Oracle Database General

Oracle Database General

Oct 03

How to access internal OCI DBaaS backup Object Storage bucket

By DBA RJ in Oracle Cloud, Oracle Database General, Recovery Manager (RMAN)

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 …

10 comments

Oct 02

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

By DBA RJ in Oracle Database General

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

10 comments

Aug 27

DBMS_PDB arriving on 11.2.0.4!

By DBA RJ in Oracle Database General

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 …

10 comments

Aug 27

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

By DBA RJ in Oracle Database General

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 …

10 comments

Aug 27

Dissecting 200714 BP, PSU, RU and RUR

By DBA RJ in Database Security, Oracle Database General

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 …