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 readingTag: Oracle
Different 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 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 readingChange output language of srvctl
During my development of TVD-Backup I wanted to implement a new subroutine for parsing the output of a srvctl config database command. The first tests on Linux were successful, but the same tests on a Windows system with a German locale failed. After a few minutes of investigation, I found out, that the output of the srvctl was in a different language then expected. In this blog post, I will demonstrate how to change the output language of srvctl.
Continue reading/etc/oratab entries are deleted after applying October 2017 Release Update
This short blog post will explain a change in the behaviour of how the /etc/oratab file is maintained by the oraagent.bin process in Oracle 12c Release 2 with an installed October 2017 Release Update.
Continue readingorapwd enforces password complexity rules in 12.2.0.1
Starting with Oracle Database 12.2.0.1 the orapwd utility – used to create Password Files for remote authentication – enforces complexity rules for the provided password.
Continue readingSilent installation of Grid Infrastructure 12.2.0.1 without ASM
This is the first blog post about the recent release 12.2.0.1 of Oracle Grid Infrastructure. In the next lines I will demonstrate how to install Grid Infrastructure for a standalone server (Oracle Restart) without the Automatic Storage Management (ASM) component silently.
Continue reading