Windows: How to Install Oracle 19c Database Software

These are the steps to install Oracle 19c Software. We are going to create ORACLE_HOME=C:\app\ORACLE\product\19c\dbhome_1 STEPS: 1:- Download software from here 2:- Unzip downloaded file on path C:\app\ORACLE\product\19c\dbhome_1 3:- Execute setup.exe from C:\oracle\app\product\19c\dbhome_1 4:- Follow GUI: That’s it, Oracle 19c Software installed Post Views: 1,293

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 C:\oracle\app\product\12.1.0\dbhome_1 win-rac2 C:\oracle\app\product\12.1.0\dbhome_1 win-rac-control 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 to 19c

This post will go though the all the steps needed to upgrade a 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 (as root): 6:-... » read more