Dec 14

ORA-28427: cannot create, import or restore unencrypted tablespace: USERS in Oracle Cloud

Those days I was trying to create a database using the "CREATE DATABASE" syntax in a IaaS Compute in Oracle Cloud to build a lab for one of my sessions. SQL> CREATE DATABASE db21c USER SYS IDENTIFIED BY Oracle11__ USER SYSTEM IDENTIFIED BY Oracle11__ EXTENT MANAGEMENT LOCAL UNDO TABLESPACE undotbs1 DEFAULT TEMPORARY TABLESPACE tempts1 DEFAULT …

Continue reading

Dec 13

Playing with new Oracle Database 21c in your VirtualBox

Last week Oracle released the newest Oracle Database 21c. This is an Innovation release (not long term like 19c) that introduces many cool new features, including also the 20c new features which DB release didn't happen: Oracle is mindful of the unprecedented economic and business disruption our customers faced in 2020. We decided to not …

Continue reading

Nov 06

Docker on Oracle Linux 8 with no access to the internet (yum error)

Those days, after deploying a brand new Oracle Linux 8 from OCI, I deployed docker-ce on it to install a new Oracle Database based on docker. However, when trying to build the database docker image, I started to receive an strange error that was not happening on Oracle Linux 7. I was receiving an strange error …

Continue reading

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