With Release Update 19.27/23.8 (April 2025), Oracle removed the support to run a database with Small Pages on Engineered Systems. More details about this behavior change can be found in My Oracle Support Note Starting DBRU 19.27 and 23.8 Small Pages Are Not Allowed for RDBMS SGA In Exadata. (Doc ID 3081878.1). In this blog post I will show a way to still use Small Pages on an ExaCC environment.
Continue readingTag: 19c
ExaCC: Oracle Home deployment fails with DBAAS-60018
In this blog post, I am going to describe a strange error with OPatch while I was trying to deploy a new Oracle Home to one of our VM clusters.
Continue readingKeep RMAN Auxiliary Instance after failure
In this blog post, I will demonstrate how to keep an automatically created RMAN Auxiliary Instance after a failure occurred.
Continue readingORA-65118 during RESTORE FOREIGN DATAFILE/TABLESPACE
Starting with 12c Transportable Tablespaces can be combined with incremental backups to reduce the amount of time required to copy the Datafiles from the source to the target location. To do this RESTORE FOREIGN DATAFILE resp. TABLESPACE commands were introduced for RMAN. In this blog post, I will show an issue when a backup of an 11.2.0.4 database is used as a source and a 19c PDB is used as target.
Continue readingDifferent ways to get the current database version
In this blog post I will show you how to get the current version of the connected database using either SQL queries or PL/SQL code. To show you some enhancements in this area, I will use versions 12.1.0.2 and 19c for a comparison.
Continue readingRotation for plain-text listener log in 19c
In this short blog post, I will write about a new feature introduced with Oracle 19c. Starting with this release the plain-text listener log located in the diagnostic directory are rotated.
Continue readingSymbolic Links in DIRECTORY Objects not permitted with Oracle 18c/19c
With every new release behavior changes are introduced. This applies to 18c/19c as well. I want to blog about a behavior change related to the usage of symbolic links in directory paths.
Continue reading