Starting with Oracle 21c, a PDB is registered as dedicated resource in the Grid Infrastructure.
Continue readingCategory: Administration
Installation of Oracle Audit Vault Server 20.1
With this blog post, I am trying something new for me. I will install Oracle Audit Vault Server 20.1 as a virtual machine using Oracle VirtualBox. This blog post will be the first of a multipart series of posts around the topic of the Oracle Audit Vault and Database Firewall 20.1 (AVDF)
Continue readingAnalyze raw trace files with SQL Developer
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 readingCleanup of TEMPORARY segments
In this short blog post, I will explain how to get rid of TEMPORARY segments in a permanent tablespace.
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 readingInsufficient SRLs reported by DGMGRL
This is a short blog post about a small issue with the reporting of Standby Redo Logs in DGMGRL during the validation of a database.
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 readingRunning SQL Developer on High DPI Screens
After five years, it was time for a new Laptop. My new Laptop has a high resolution screen with a resolution of 3840 x 2160. One of the first actions was to download SQL Developer 18.2. Then a surprise, the window and font size of SQL Developer was very low and hard to read and use. This short blog post will show you a way to get back the “old size” on Windows 10.
Continue reading