BE SHARING

Mouhamadou Diaw

Unplug/Plug PDB in TDE Environment

14.03.2023 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 database We plan to(…)

Database Administration & Monitoring

Oracle TDE part II : Encrypting Data

23.02.2023 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 will allow encryption at(…)

Database Administration & Monitoring

Oracle TDE part I : Configuring the Encryption

23.02.2023 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 allow to do encryption(…)

Database Administration & Monitoring

The Option -applyRU of runInstaller

18.02.2023 by Mouhamadou Diaw

RU, MRP should be applied to database home as soon as possible. Usually we often nstall the base version and after install the RU on top on the base version For example we want to have the version21.8 We usually(…)

Database Administration & Monitoring

Oracle 21c Gradual Password Rollover : Tracking old password usage

17.02.2023 by Mouhamadou Diaw

In a previous blog, I talked about the new feature in Oracle 21c, which allows an old and new password to be valid during a period of time. This feature, Gradual Database Password Rollover, is possible(…)

Database Administration & Monitoring

Migrating Non-CDB to Multitenant

14.02.2023 by Mouhamadou Diaw

Dealing these last days to database migration with a customer, I write this blog to describe the main tasks The context is to migrate databases to a new infrastructure. Below the configuration Source : Linux Suse in a non-multitenant architecture(…)

Database Administration & Monitoring

Upgrade OEM 13c from R4 to R5

24.01.2023 by Mouhamadou Diaw

Upgrading Enterprise Manger Cloud Control can be tricky. In this blog I am describing an upgrade I did for a client. The source version is OEM13c R4 And the target version will be EM13c R5 Before starting I did following(…)

Database Administration & Monitoring

Patching ODA HA from 19.10 to 19.17

12.01.2023 by Mouhamadou Diaw

In this blog I am describing an ODA HA (serveroda1 and serveroda2) patch from 19.10 to 19.17. The process is the same that patching a non-HA ODA. Few tasks may need to be done on both servers, otherwise all steps(…)

Database Administration & Monitoring

Applying RU on Enterprise Manager 13c R5

16.12.2022 by Mouhamadou Diaw

We often apply Oracle Database RU. Like database Release Update can also be passed on Enterprise Manager. On this blog I am describing how we can update an OEM 13cR5 Update 10 to OEM 13cR5 Update 11. For this I(…)

Database Administration & Monitoring

ODA : Do You Know The MOVE Table In MySQL DB Repository

08.11.2022 by Mouhamadou Diaw

During a consulting on a customer, we faced the following issue when trying to delete a dbhome Message: DCS-10001:Internal error encountered: PRGO-2470 : Working copy “OraDB19000_home1” is involved in an incomplete move or upgrade operation The result of the job(…)