Oracle Script to calculate the network latency between the application and the Oracle DB-server 29.12.2021 by Clemens Bleile By Clemens Bleile Network latency is crucial for applications, especially if lots of “row by row”-processing (some call it “slow by slow”-processing) is used by the application or if lots of data is transported between the database and the application.
Oracle Exadata Cloud at Customer: Considerations for Backup & Recovery 28.12.2021 by Clemens Bleile Working in a project where the customer migrates from an on-premises environment to Exadata Cloud at Customer provides insights about the decisions to take and what to consider when using the Exadata Cloud at Customer environment. In a series of(…)
Oracle Upgrade AHF and TFA on an ODA 22.12.2021 by Marc Wagner TFA (Trace File Analyzer) is part of AHF (Autonomous Health Framework). Those tools are preinstalled and part of ODA (Oracle Database Appliance). As you might know patching and upgrading are normally always going through ODA global Bundle patches. AHF can,(…)
Database Administration & Monitoring, Database management, Operating systems, Oracle Oracle Database Appliance 19.13: what’s new and how to patch? 11.12.2021 by Jérôme Dubar Introduction Patch 19.13 is now available on ODA. It’s time to test it. What’s new? This version brings October’s PSU to database and grid homes with their bug fixes, as usual. It also brings 21.4 for DB Systems (21c being(…)
Database management, Hardware & Storage, Operating systems, Oracle When unreachable NFS share mess up your Dbvisit Standby configuration 09.12.2021 by Joël Cattin If I had to rank my favorite Oracle-related tools and software, Dbvisit Standby would likely be at the top of the list. You are reading this post, so you probably know that Dbvisit Standby is a(…)
Database Administration & Monitoring, Database management, Oracle Move a PDB from a server to another one using NFS 03.12.2021 by Jérôme Dubar Introduction Multitenant brings new possibilities regarding Oracle databases, and one of them is to move a database from a container to another quite easily. When containers are on the same server, it’s very easy, but when the containers are on(…)
Database Administration & Monitoring, Database management, Operating systems, Oracle ODA 19.12: How can you manage DB Systems with odacli? 26.11.2021 by Jérôme Dubar Introduction As virtualization is available for all ODAs now, you could ask yourself if it’s a good idea to use this virtualization or not. Databases can be created as bare metal, but also within a DB System for better isolation.
Database management, Oracle 5 things that aren’t true about RMAN 22.11.2021 by Jérôme Dubar Introduction RMAN backups are not a hot topic today. This is because it didn’t evolve that much in 12c/18c/19c, and most of the databases are now protected by a good backup strategy since years, and no changes are needed. Furthermore,(…)
Database Administration & Monitoring, Database management, Operating systems, Oracle Dbvisit 10 on Oracle Database Appliance 22.11.2021 by Oracle Team By Mouhamadou Diaw Dbvisit Standby can also be installed on Oracle Database Appliance (ODA). The installation is the same that on any other Linux box. I did an install of Dbvist 10 on an ODA 19.12 for a customer and(…)
Database Administration & Monitoring, Database management, Operating systems, Oracle Install Enterprise Manager 13c R5: Check the db edition Failed 17.11.2021 by Oracle Team By Mouhamadou Diaw A few days ago, I was setting an Enterprise Manager 13c R5 for a client. The configuration used is the following -The EM binaries are installed in a separate server than the database -The database(…)