Oracle ODA version 19.18 is available: how to patch? 22.03.2023 by Jérôme Dubar Applying 19.18 patch on your Oracle Database Appliance(…)
Cloud, Oracle Zero Downtime Migration (ZDM) to Oracle Cloud Infrastructure (OCI) 19.03.2023 by Marc Wagner The question to migrate or not to the Cloud comes more and more often now. There are some added values to go to the Cloud as analytics capabilities, scalability and flexibility, cost saving, no dedicated hardware and its related maintenance,(…)
Oracle ODA vnetwork bridge with no IP address 16.03.2023 by Marc Wagner It is not mandatory to setup an IP address on a bridge interface. A bridge forwards packets at MAC layer. But of course, if I would like to reach the DB System or the Compute Instance from the ODA, then(…)
AWS, Cloud, Database management, Oracle Oracle Database Backup Cloud Service 14.03.2023 by Oracle Team In a previous blog I demonstrated how to migrate an Oracle database from AWS to Oracle OCI using Data Guard. But what if you want to migrate to the Oracle Cloud, but don’t have a direct connection between the(…)
Database Administration & Monitoring, Database management, Oracle, Security Unplug/Plug PDB in TDE Environment 14.03.2023 by Oracle Team By Mouhamadou Diaw In an oracle environment with Transparent Data Encryption (TDE) the transfer of PDB may require additional steps. In this blog we will see some steps which may be required when doing Unplug and Plug of pluggable(…)
Hardware & Storage, Oracle Why you should consider keeping your ODA more than 5 years 09.03.2023 by Jérôme Dubar ODA is a long-lifetime platform!(…)
Database Administration & Monitoring, Database management, DevOps, Development & Performance, Oracle SHELL SCRIPTING: improve DBA scripts readability using J2 templates 27.02.2023 by Oracle Team Quering database's by using SQL in shell scripts can make the whole script unreadable. Very oftent the query is unredable too, due to the variable usage. This situation make the script debugging a pain. Templating simplify the script by taking(…)
Oracle Want to easily test Dbvisit StandbyMP for Oracle SE? 23.02.2023 by Marc Wagner As you might know Dbvisit StandbyMP is a great Disaster Recovery solution for Oracle SE databases. Dbvisit recently communicated, providing now, a Test Drive system for customer to easily try the product and for partner to easily have a Demo(…)
Database Administration & Monitoring, Database management, Oracle, Security Oracle TDE part II : Encrypting Data 23.02.2023 by Oracle Team By Mouhamadou Diaw In the first part of this blog, we activate TDE in the database, in this part we will see how we can encrypt data. I am using Oracle 19c for the tests As specified before TDE(…)
Database Administration & Monitoring, Database management, Oracle, Security Oracle TDE part I : Configuring the Encryption 23.02.2023 by Oracle Team By Mouhamadou Diaw Oracle gives us some tools to secure our data in transit and in rest. Oracle Transparent Data Encryption will allow us to encrypt data in rest. Oracle TDE need The Oracle Advanced Security License Oracle TDE(…)