FAN events and FCF for SEHA
With Oracle database version 19.7 we got Standard Edition High Availability as a kind of replacement for Standard Edition RACs which cannot be used as of 19c any more. See https://blogs.oracle.com/maa/standard-edition-high-availability-officially-released In a recent discussion I wondered whether FAN events and Fast Connection Failover might…
TNS chaos
I like to have my Oracle Net config consistent and without surprises. So for me it is a best practice to have ONE central TNS_ADMIN directory on the database server, which is set in all my shells. But a lot of processes might ignore that…
DOAG-Datenbank-Konferenz 2020: Wie kommt der Client zu Datenbank? Oracle-Net für Einsteiger
Herzlichen Dank all denen, die meinen Vortrag „Wie kommt der Client zur Datenbank? Oracle Net für Einsteiger“ im Einsteiger-Stream der virtuellen DOAG-Datenbank-Konferenz 2020 besucht haben. Download des Vortrages (Folien) Download des Vortrages (Vortrag + Notizen)
Troubleshooting Oracle session disconnection slowness
I have been recently asked to investigate very interesting issue. In short: AIX 7.1 with Oracle 12.1.0.2. Connect with SQL*Plus from hostX to databaseA running on hostZ, then disconnect – was hanging for around 75 seconds. Connect with SQL*Plus from hostY to databaseA running on…