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
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
Setting up Network Encryption in our Oracle environment is very easy, we just need to add these lines to the sqlnet.ora on server side: Ideally, on the client side we should add these too: But since ENCRYPTION_CLIENT by default is ACCEPTED, if we see this chart, connection would be encrypted (ACCEPTED – REQUESTED case) Lets... » read more
We had this error while trying to open a DB: Digging a bit on the enviroment, we noticed server had a power cut and DB did not stop gracefully. This is how we fixed: 1:- Start DB in mount and list log files: 2:- Recover Database: (we need to input the failed log file): 3:-... » read more