In this blog post, I will demonstrate how to keep an automatically created RMAN Auxiliary Instance after a failure occurred.
Continue readingCategory: Troubleshooting
ORA-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 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 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 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 reading