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 reading »

Create 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 reading »