April 28, 2020
Upgrades and RAC - Martin Klier, Oracle ACE Director
Last month's virtual meeting went well, so we're going to try it again! This month's meeting will be via WebEx from 3pm-5pm Eastern time. Click HERE to join.
Originally, my good friend and Oracle ACE Director, Martin Klier, was planning to present during a visit to the US. With the Corona travel bans, his trip was cancelled, but Martin has graciously volunteered to give an SOUG presentation via live remote all the way from his home in Mitterteich, Germany. He sent me a list of several topics we can choose from. I've picked the following two topics, but I'm sure Martin will be flexible if the audience wants to lead us in a different direction.
Experience from 24 Months of Database Upgrade and Migration - Running out of support, security concerns, new features, coming operating system or hardware changes.... there is a long and versatile list of potential reasons for our customers, to change the version of their running Oracle Databases. The "choice" of situations, challenges and options for changing the version, is at least as long and as versatile as the reasons are. Martin will deliver an unveiled overview about his adventures with logical dependencies, human sensitivities, technical skulduggeries and license traps. All this happens, when one or multiple databases are to be migrated or upgraded to a new version in a controlled fashion. For A as in AIX, L like Linux, S like Solaris, V like Virtualization, W twice in Windows ... there was trouble, there was a solution, and there was a new experience!
42 facts for Grid Infrastructure, ASM and RAC - The ecosystem of the Oracle Real Applications Cluster (RAC) gives lots of space for creative solutions, optimized concepts and --- intelligent questions! The Grid Infrastructure framework is highly flexible, ASM opens many performant and safe options of mass storage administration and RAC is the measure for scalable database power in the market. But every single one of those building blocks needs to be understood for itself and for its place in the big picture. If not, we are in for one or two nasty surprises or very "interesting" side effects. In more than 12 years of operative practice with RAC, the author collected a full list of facts, best practices, anecdotes and scars-to-prove-it. The 42 best of them are entangled here in a guideline how you can do RAC in a better way. The presentation also shows in telegraph style, how a technology made its way from an appendix of the database to a full-fledged product. We'll also cover - besides all the tech talk - some licensing and organisational matters.
Being in the IT business as a specialist for Linux, Martin Klier has been involved in the administration of Oracle Databases for about fifteen years now. The integration of large Oracle-based high-availability solutions (MAA) with RAC and Data Guard were the first challenges In the last years, he largely moved into performance analysis and tuning of complex systems with dynamically changing load profiles. Skeptical needs assessments, thorough architecture planning, decent system sizing, critical benchmarking and experienced load-focused system analysis are Martin's formula to success in avoiding production downtime. For years now, Martin can be found speaking on topics regarding "Oracle Core, Performance and High Availability" on various national and international conferences, like COLLABROATE (IOUG), Oracle Open World or DOAG Konferenz. Martin frequently blogs about recent issues and their solutions at http://www.usn-it.de and is known on Twitter as @MartinKlierDBA. Martin works a lot for the community, especially for the German Oracle Users Group "DOAG" and Linux User Group Mitterteich, and is an Oracle ACE Director (Database).
For information on usual meeting locations and times as well as previous
meeting minutes and presentations please refer to the
For further information or enquiries regarding meetings please
contact the SOUG meeting coordinator.