Every OPatch experience is different and from time to time applying a patch fails for varying reasons. Today I wanted to patch an Oracle Database 18c home. During the apply process, OPatch complained about a missing shrept.lst file.
Continue readingAuthor: Christian Gohmann
Symbolic 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 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 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 readingEstimate Age or Size of ADR Home in 18c
With the release 18c, Oracle introduced the capability to calculate the size of an ADR Home before changing the purging policies. In this short blog post, I will demonstrate this new feature.
Continue readingInstance crashed with ORA-01092 Error
While I was checking a customer environment, I saw that the Repository Database of an Enterprise Manager Cloud Control installation was down. Due to the alert log, there was a hung of processes in the night and the instance was killed by the PMON. Every subsequent startup of the database failed with an ORA-01092 error. In this blog post, I will demonstrate how to analyze a memory issue which can lead to an ORA-01092 error.
Continue readingORAchk execution on SLES 12 fails with RC-001
In this short blog post, I will demonstrate an issue with the current version 12.2.0.1.4 of the famous ORAchk tool running on SuSE Linux Enterprise Server 12.
Continue readingGenerate Healthcheck Reports in HTML with CVU 12.2
With the release of Oracle 12c Release 2, the Cluster Verification Utility (CVU) was included with an updated version. Beside new checks and enhanced functionality, the possibility of generating HTML reports was added. In this blog post I will show you how to generate such HTML reports.
Continue readingPerformance improvements with OPatch 12.2.0.1.12
In the last few months I was struggeling with performance issues during the installation of different Database Proactive Bundle Patches on Solaris SPARC. On the server, the OPatch version 12.2.0.1.11 (October 2017) was installed. Now with the release of OPatch 12.2.0.1.12 (January 2018) the installation time decreases from 3,5 to 0,5 hours.
Continue readingIdentify sensitive data with DBSAT
In December, Oracle released the version 2.0.1 of the Database Security Assessment Tool (DBSAT) (German). One big enhancement is the introduction of the new Discoverer component, which can be used to identify sensitive data within your database. This blog post will demonstrate how to configure and use the Discoverer.
Continue reading