Author

How to create an Oracle ACTIVE/PASSIVE environment on Windows Failover Cluster Manager

We are going to create an environment to have an Oracle database in Failover Cluster Manager. To have this, we need 3 Windows Servers ( 1 Working as controller) Server Name Public IP: Private IP: ORACLE_HOME win-rac1 192.168.56.151 192.168.10.151 C:\oracle\app\product\12.1.0\dbhome_1 win-rac2 192.168.56.152 192.168.10.152 C:\oracle\app\product\12.1.0\dbhome_1 win-rac-control 192.168.56.153 192.168.10.153 For how to install Windows VM’s here (in... » read more

How to Install TrueNAS in Virtual Box

Today we are going to install TrueNas in VirtualBox. Initially the plan was to use for database storage on a Failover Cluester Manager environment, but I managed to share disks in a different way. Since I already created this “How to”, I’ll leave in case someone needs it. TrueNAS software can be downloaded from here.... » read more

ORA-38706: Cannot turn on FLASHBACK DATABASE logging.

We had this issue while trying to enable flashback: In our case this was due to “ORA-4031 When Enabling Flashback In 19c (Doc ID 2896925.1)”: Since this was just for a one-off activity Client wanted to implement, we did not put the solution as we wanted to better have teh memory available for the DB... » read more

High Undo Tablespace Space Usage

We had this issue where undo space was not released even when having a low undo_retention (900). This was because TUNED_UNDORETENTION was very high: On this case, we followed “IF: Causes for High Undo Tablespace Space Usage (Doc ID 1951402.1)” and matched size with maxsize for the undo datafiles: After a few hours (changes are... » read more

Autoupgrade fails with: Execution of Oracle Base utility, /u01/app/oracle/product/19c/dbhome_1/bin/orabase, failed for entry upg1.

Yesterday I was upgrading a DB on our production environment and I was facing this error while running the deploy: We downloaded the latest autoupgrade version as recommended and used this simple config file: Prechecks/Analyse did not have any issues: Still, when we tried to run the deploy, we were getting this error: If we... » read more

How to AUTOUPGRADE from 12.1.0.2 to 19c

This post will go though the all the steps needed to upgrade a 12.1.0.2 database to a 19c using AUTOUPGRADE. Source DB: 1:- Create 19c directory and copy software: 2:- Create response file for a silent 19c Instalation: 3:- Execute 19c pre-requisites: 4:- Install 19c software in silent mode: 5:- Execute root.sh (as root): 6:-... » read more

How to Upgrade Oracle Grid from 12c to 19c

This post will go though the steps needed to upgrade an Oracle Grid High Availability Services (HAS) from version 12c (12.1.0.2) to 19c (19.13.0) on a Linux environment. 1:- As per document Doc ID 2539751.1, Patch 28553832 is a prerequisite for both GI and DB Upgrade. Here the steps to apply Oct 2021 PSU which... » read more

Oracle 12c: How to apply Oct 21 PSU – 12.1.0.2.211019

This activity is part of a GI upgrade from 12.1.0.2 to 19c, in which we need to apply latest PSU first, so here are the steps: 1:- Patches available here: 2:- (as ROOT) Update OPACH version to latest available. (p6880880_122010_Linux-x86-64.zip) 3:- (as ROOT) Run prepatch script. (RDBMS instances should be stopped first) 4:- GI patching:... » read more