Oracle ODA: How to use Data Preserving Reprovisioning? 22.07.2022 by Jérôme Dubar Introduction Oracle Database Appliance has a global patch available each quarter, so all the components can be patched together on a regular basis. Most of the time, applying the patch on your ODA will be OK, but sometimes you will(…)
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, Oracle Upgrade to Oracle 19c – performance issue 15.10.2020 by Oracle Team In this blog I want to introduce you to a workaround for a performance issue which randomly appeared during the upgrades of several Oracle 12c databases to 19c I performed for a financial services provider. During the upgrades we ran(…)
Database Administration & Monitoring, Database management, Oracle Focus on 19c NOW! 29.11.2019 by Jérôme Dubar Introduction For years, Oracle used the same mechanism for database versioning. A major version, represented by the first number. And then a release number, 1 for the very first edition, and a mature and reliable release 2 for production databases.
Database Administration & Monitoring, Database management, Development & Performance, Hardware & Storage, Oracle When you change the UNDO_RETENTION parameter, the LOB segment’s retention value is not modified 18.03.2019 by Oracle Team Below, I will try to explain, a particular case for the general error : ORA-01555 snapshot too old error.. Normally, when we have this error, we are trying to adapt the retention parameters or to tune our queries. SQL> show(…)
Database Administration & Monitoring, Database management, Oracle Create a primary database using the backup of a standby database on 12cR2 21.02.2019 by Oracle Team The scope of this blog will be to show how to create a primary role database based on a backup of a standby database on 12cR2. Step1: We are assuming that an auxiliary instance has been created and started in(…)
Database Administration & Monitoring, Database management, Development & Performance, Oracle Recover a corrupted datafile in your DataGuard environment 11G/12C. 30.01.2019 by Oracle Team On a DG environment, a datafile needs to be recovered on the STANDBY site, in two situations : when is deleted or corrupted. Below, I will explain how to recover a corrupted datafile, in order to be able to(…)
Database Administration & Monitoring, Oracle Reimaging an old X3-2/X4-2 ODA 26.10.2018 by Jérôme Dubar Introduction X3-2 and X4-2 ODAs are still very capable pieces of hardware in 2018. With 256GB of RAM and at least 16 cores per node, and with 18TB RAW disk capacity as a standard these appliances are far from obsolete(…)
Application integration & Middleware, Database Administration & Monitoring, Database management, Oracle How to migrate Grid Infrastructure from release 12c to release 18c 12.10.2018 by Oracle Team Oracle Clusterware 18c builds on this innovative technology by further enhancing support for larger multi-cluster environments and improving the overall ease of use. Oracle Clusterware is leveraged in the cloud in order to provide enterprise-class resiliency where required and dynamic(…)
Database Administration & Monitoring, Database management, Oracle Upgrade Oracle Grid Infrastructure from 12.1.0.2.0 to 12.2.0.1.0 03.08.2018 by Oracle Team The following blog will provide the necessary steps to upgrade the Grid Infrastructure from 12.1 to 12.2, for a Standalone Server. One of the new features of GI 12.2 is the usage of the AFD (Oracle ASMFD Filter Driver).