How to install Goldengate 21c in silent mode

Usually we do the installation using the graphical interface. Let’s try this time the silent mode: This is my environment: Download the software from: https://www.oracle.com/middleware/technologies/goldengate-downloads.html#license-lightbox Copy the file to a staging location on the server. In my case will be “/u01/software”: Step 1) Unzip the software Step 2) Create Response File This is my response…

Rolling Database Upgrade from 19.3.0.0 to 19.11.0.0 Using Transient Logical Standby

Rolling upgrade with Transient Logical Standby is known as a MAA (Maximum Availability Architecture) technique, to minimize downtime during upgrade of Oracle database.  Approaches: There are several methods which can be used: Manually from command line Manually using phsyru.sh script which is available since 11g (Doc ID 949322.1) Use DBMS_ROLLING package which is available since 12.1.0.1 (Doc ID 2086512.1) Note: for both manual…

How to have your own online VSCode Server

I’ve found this very interesting, having my online VSCode accessible from any laptop / tablet within my network. Bellow I will describe the steps I took to make that possible: To install a VS Code server, we will use code-server by coder. To install it, run the following command: This is the output: The installation is very minimal…

Broker configuration show ROLLING DATABASE MAINTENANCE IN PROGRESS after upgrade using dbms_rolling procedure

After executing an upgrade exercise in a dataguard environment (19c), the broker was still showing the status: “ROLLING DATABASE MAINTENANCE IN PROGRESS” This is due to a bug: Bug 26921039 – INCORRECT DGMGRL SHOW CONFIGURATION STATUS AFTER POST ROLLING UPGRADE SWITCHOVER Solution is simple: Execute the following statement on PRIMARY database and bounce it: Let’s…

ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version 32 into a target database with TSTZ version 31.

I got this error while trying to perform an import from another 19c database but apparently with a higher TZ version: The solution is to perform the TZ upgrade of the database. Check the current time zone version: Let’s see what’s the latest time zone to which we can upgrade to: We can see that…