Skip to content

Oracle Team

Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.

1,009 posts since December 2010

Oracle 21c Gradual Password Rollover : Tracking old password usage

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 using new parameter PASSWORD_ROLLOVER_TIME. The question that comes may be: Can the DBA track if old passwords are still being used?… 

Migrating Non-CDB to Multitenant

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 Target : Oracle Enterprise Linux 8 with multitenant The database version is Oracle 19c Installing Oracle Binaries… 

Migration with Data Guard: Oracle on Windows AWS to Oracle Cloud Infrastructure (OCI)

Oracle offers a number of methods to migrate Oracle databases to the Oracle Cloud Infrastructure (OCI). From Data Pump through RMAN, Data Guard and even Golden Gate there should be a solution for just about everyone. However, most of these managed migration services require that the source system is running Linux. So what do you do when you’re running Windows?… 

A generic jdbc tester (part III)

A generic utility to test JDBC connections to any RDBMS or no SQL data source whose JDBC drivers are provided. Firebird, SQL Server, HSQLDB, MongoDB, Excel, conclusion.

Upgrade OEM 13c from R4 to R5

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 tasks -Copy the key in the repository -set the parameter “_allow_insert_with_update_check” to true You can now stop… 

Hashicorp Vault. Install and quick first configuration

by Alexandre Nestor Introduction Keeping and using passwords in scripts is often an overlooked task, at least in the initial stages of development.This behavior poses serious security problems, and quite often, especially in scripts, one can find plaintext passwords.If the project uses Git, then the versions of git that contain the passwords are visible in the project history.The use of… 

Patching ODA HA from 19.10 to 19.17

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 are done from one node. If there are some tasks needed on both nodes, we will specify.… 

Create and manage Ansible Execution Environments

by Alexandre Nestor Introduction What is an Ansible Execution Environnement, by the way ? As per RedHat definition an Ansible Execution Environment (EE) is a standard way to build and distribute the environment that automation runs in, which reduces complexity and makes it faster and simpler to develop and deploy automation. More simple, an EE is a container, by default… 

Applying RU on Enterprise Manager 13c R5

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 used the following patches Patch 34601305: Oracle Enterprise Manager 13c Release 5 Update 11 (13.5.0.11) for Oracle… 

Access OCI cloud using session token

by Alexandre Nestor In the previous article A step by step guide to install and configure OCI client the oci client configuration. OCI provides also token access. Note: The tenancy name can be found on the page “Tenancy details“ Let’s try out the OCI output suggestion: The $HOME/.config file was updated with the token and the session parameters are in… 

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

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 is shown below After researches on the net, we found following Oracle document ODA: Create-prepatchreport fails with… 

How to Setup Dataguard on PDB Level (DGPDB)

Introduction One of the long requested features in case of Multitenant was the possibility to create and manage a data guard configuration on pdb level. Now with the Release Update 21.6 this was finaly implemented and the name of the new feature ist called DGPDB. If you want to know more about the data guard on pdb level and how…