We are running datapatch on a Windows environment after a BP patching, but it was failing with: For the fix, we applied solution suggested on: 12.1: datapatch -verbose Fails with Following Error”PLS-00201: identifier ‘UTL_FILE’ must be declared” (Doc ID 2265408.1):
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
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
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
After client performed a manual upgrade of a DB from 12c to 19c, we noticed we could not update configuration at cluster level and we faced these errors: This is what we did to fix it:
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
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
I faced this error a few times so I though to write a quick note for an easy fix. While you try to start DB, it gets this error. I know… this is 10g, but sometimes Clients do not want to upgrade and you have to deal with it… If you check alert log, you... » read more
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
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