Oracle Database General
Jul 09
Those days, I was trying to create a 19c database with a lower COMPATIBLE, so I could have a fallback plan after plugin a PDB from a lower release. However, when trying to create it using DBCA command: dbca -silent -createDatabase \ -gdbName cdb19c \ -templateName General_Purpose.dbc \ -characterSet AL32UTF8 \ -createAsContainerDatabase true \ -numberOfPDBs …
Apr 30
If you follow my quarterly dissecting database patches series, you will note that on 19.11 (April-2021 CPU) oracle introduced a new USER/ALL/DBA_IMMUTABLE_TABLES view. This seems to be related with the new blockchain feature, but on 19.10 (the previous RU), oracle have already created USER/ALL/DBA_BLOCKCHAIN_TABLES. In this post I will investigate the differences among them. So, …
Apr 30
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.210420 DB PSU 11.2.0.4.210420 Exadata Bundle Patch 11.2.0.4.210420 OJVM PSU 12.1.0.2 12.1.0.2.210420 DB PSU 12.1.0.2.210420 Exadata Bundle Patch 12.1.0.2.210420 OJVM PSU 12.2.0.1 12.2.0.1.210420 …
Apr 30
Oracle April 2021 Critical Patch Advisory changed objects performed by each database patch. For more details and the catalog, check the main post: Dissecting 210420 BP, PSU, RU and RUR What exactly changed for each? (click to see detailed line changes) 12.1.0.2 SYS.DBA_LOGSTDBY_NOT_UNIQUE - VIEW 12cR1 (BP) SYS.DBA_LOGSTDBY_UNSUPPORTED - VIEW 12cR1 (BP) SYS.DBA_LOGSTDBY_UNSUPPORTED_TABLE - VIEW …
Apr 15
There is no excerpt because this is a protected post.
Rodrigo Jorge
Oracle OCM Database 11g & 12c
Oracle OCM MAA & Cloud
Oracle OCE Data Guard 12c
Oracle OCE RAC and Grid 11gR2 & 12c
Oracle OCE Performance Tuning 11g & 12c
Oracle OCS Security 11g
Oracle OCS Data Warehousing 11g
