Upgrading GoldenGate when the source is DB2 for z/OS is not quite the same exercise as upgrading a GoldenGate installation for Oracle. Most of what I described in my generic blogs about planning a GoldenGate upgrade and migrating from Classic to Microservices Architecture is still valid. However, there is an extra layer to deal with. It has to do with…
Configuring an NGINX reverse proxy for GoldenGate is well documented by Oracle, but what is not is the implication of adding or removing deployments. In fact, when modifying your GoldenGate deployments, you will have to reconfigure the NGINX reverse proxy. If you don’t, part of your installation will not be working anymore. This is what will happen in the web…
Troubleshooting Oracle Data Guard when your standby database has errors or is not in sync
Attention.log is a feature, which was introduced in Oracle Database 21c, designed to capture high-level summaries of significant database events and activities. It differs from the alert.log in following points: High-Level Summaries: The attention.log focuses on summarizing critical and significant events rather than logging every minor detail, including database startups and shutdowns, major configuration changes, errors or warnings that need…
Introduction Oracle 23c is not yet available on Oracle Database Appliance (ODA), but it should be ready in 2024. As 23c is the next Long Term release, 19c databases will probably migrate to 23c in the coming years. If you decided to use DB Systems on your ODA, you might think that migration will not be that easy. But it’s…
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 -Install the LINUX.X64_213000_db_home.zip- – And then apply the RU 21.8 34527084 But another method is to apply…
Introduction On Oracle Database, Multitenant feature will be turning 9 in July, but it’s not yet widely deployed as most of the databases are still running on non-CDB architecture. With 19c, Multitenant is now mature and free if you stick to a maximum of 3 PDBs per CDB. If the benefits of Multitenant are not obvious at first glance, it’s…
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…
By Mouhamadou Diaw Dbvisit 11 is released since a few months ans now is referenced as Dbvisit Standby MultiPlatform v11 ( Dbvisit StandbyMP 11 ) for Linux and Windows. It brings revolutionary improvements, including being able to manage both Oracle and SQL Server DR from a single GUI. In this blog I am showing how to install Dbvisit StandbyMP on…
The increasing popularity of tools like SQL Developer and Toad, sometimes comes hand in hand with an increase of stuck sessions.This is especially seen in cases where: User A does a change (neither committed nor rolled back). Then, switches to another task, or even leaves for lunch. Then, User B updates the same row and stays there, stuck for hours.…
By Mouhamadou Diaw One question we may ask is that if it is possible to deploy an Oracle 21c database in an ODA as the latest version for ODA is actually 19.x The answer is Yes. Since ODA release 19.12, we can install a DB system with Oracle 21c while the bare metal system runs Oracle Grid Infrastructure 19.x. To…
By Mouhamadou Diaw An observer is an OCI client that connects to the primary and target standby databases using the same SYS credentials you used when you connected to the Oracle Data Guard configuration with DGMGRL. The observer is highly recommended in a Data Guard environment. But it is mandatory if a Fast-Start Failover is configured. Since Oracle 12.2 we…
