When a new database is deployed on ExaCC, all nodes of the VM cluster are considered. But sometimes a multi-instance database is not required, for example for DEV or non-business critical databases. In this blog post, I will demonstrate how to handle this requirement with dbaascli.
Continue readingCategory: High Availability
Oracle 21c: Separate Oracle Home for GIMR
In Oracle 21c the Grid Infrastructure Management Repository (GIMR) is still an optional component of an Oracle Cluster setup. But with this release, it is not supported anymore to use the Grid Infrastructure installation as Oracle Home for it. Instead, an Oracle RAC Database Home has to be used.
Continue readingOracle 21c: Dedicated Grid Infrastructure resource for a PDB
Starting with Oracle 21c, a PDB is registered as dedicated resource in the Grid Infrastructure.
Continue readingUpgrade FreeNAS 9.x to 11.x using web console
For my Oracle RAC deployments I use FreeNAS to provide shared storage to my cluster nodes. In this blog post I will show, how to upgrade an existing FreeNAS 9.x installation to an 11.x release.
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 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/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 reading
Passwortlose SSH-Verbindung für Oracle RAC konfigurieren
Ziel In diesem Blogeintrag werde ich die verschiedenen Möglichkeiten zur Konfiguration einer passwortlosen SSH-Verbindung zeigen. Eine passwortlose SSH-Verbindung wird zum Beispiel für die Konfiguration eines Oracle Real Application Clusters (RAC) benötigt.
Continue readingData Guard Far Sync mit Oracle 12c Release 1
Ziel Heute möchte ich euch zeigen, wie man das mit Oracle 12c Release 1 eingeführte Feature Data Guard Far Sync konfiguriert. Mithilfe dieses Data Guard Features sollen Zero-Data-Loss Konfigurationen auch über weite Entfernungen möglich sein, ohne die Performance der Produktivdatenbank zur beeinträchtigen (z.B. durch verzögerte Commits).
Continue reading