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…