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 readingCategory: Administration
Instance 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/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 readingCreate Golden Image of your current Grid Infrastructure 12.2 installation
Starting with the release of Grid Infrastructure 12c Release 2, Oracle changed the installation process. Instead of unzipping the downloaded zip files to a staging area, you unzip them to your target Oracle Home location. Afterwards you run the configuration script gridSetup.sh. This new installer has a lot of improvements like patching the installer itself or installing patchset updates or bundle patches before the actual configuration of the Grid Infrastructure starts. I want to demonstrate one of these new features – the creation of a Gold Image of an existing Grid Infrastructure installation.
Continue readingtfactl fails on Solaris while using df
This is just a short blog post about a problem using Oracle Tracefile Analyzers commandline utility tfactl on Solaris.
Continue readingResolve TNS alias using DBMS_TNS
This short blog post will demonstrate the usage of the new DBMS_TNS package, which was first introduced with the release of Oracle 12.2.0.1 and can be used to resolve a TNS alias to its full connect descriptor.
Continue reading