Since version 1.5 the Oracle SQL Developer has the capability to view and analyze raw trace files in an interactive way. In this blog post, I will demonstrate how to use this very unknown feature.
Continue readingAuthor: Christian Gohmann
Cleanup of TEMPORARY segments
In this short blog post, I will explain how to get rid of TEMPORARY segments in a permanent tablespace.
Continue readingUpgrade FreeNAS 9.x to 11.x using web console
For my Oracle RAC deployments I use FreeNAS to provide shared storage to my cluster nodes. In this blog post I will show, how to upgrade an existing FreeNAS 9.x installation to an 11.x release.
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 readingGenerate DBMS_DATAPUMP script using Data Pump trace
Starting with Oracle 10g, Data Pump can be used to export and import database objects using command-line tools expdp and impdp. Calls of these tools are mapped to the Data Pump API within the database. This blog post will demonstrate how to generate DBMS_DATAPUMP calls based on an expdp/impdp execution.
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 readingALERT: opatch util cleanup deletes OS files in 12.2.0.1.19
With the release of the January patches, Oracle released version 12.2.0.1.19 of OPatch. In this specific release, the execution of opatch util cleanup deletes OS files outside the Oracle home directory structure. Thanks to my colleague Miguel for pointing this out.
Continue readingShrink virtual disk (VDI) of a VirtualBox VM (Linux)
A lot of people are using VirtualBox to build their test or demo environments. In this blog post, I will demonstrate how to shrink an existing virtual disk of a Linux VM (Oracle Linux 7).
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 reading