ASM Filter driver (ASMFD) is the replacement for ASMLIB but since there are not many good guides out there on how to use, a common approach is installing an old version of the kernel and keep using ASMLIB…. this is not great as introduces bugs/problems having and old version. The goal of this page is... » read more
A couple of days ago we had this issue where all the DB instances on one server of a RAC were failing with this error: Checking alert log it was like if a rogue process was still using memory segments: But nothing was in use: After a failed attempt with an Oracle SR, we noticed... » read more
We had this error after a what it seems a successfull rman active duplication to another server. DB mounts ok, but when we try to open, alert log gets flooded with these errors (and db is not usable). After scratching my head thinking there was some issue with the disks, (as fdisk -l was listing... » read more
This is an easy one: I have been requested to show how Application could make use of Oracle Wallets instead of hard copying user password on the code, so here is it: 1:- Create a user on target DB: 2:- Create WALLET on App server, this case we will use directory /u01/admin/orcl/wallet: 3:- Update tnsnames.ora... » read more
We are trying to create a DB on a new RAC enviroment in silent mode like: But DBCA was failing with: In this case, we have a separate role for GRID (as oragrid user) and RDBMS (as oracle user), so we checked: 1:- ASM disks are under the right group name (asmadmin this case): 2:-... » read more
On this post we are going to upgrade Oracle 12c to 19c on an ACTIVE/PASSIVE setup on Windows Failover Cluster Manager: Server Name DBNAME 12c Oracle Home 19c Oracle Home win-rac1 DBPROD C:\oracle\app\product\12.1.0\dbhome_1 C:\oracle\app\product\19c\dbhome_1 win-rac2 DBPROD C:\oracle\app\product\12.1.0\dbhome_1 C:\oracle\app\product\19c\dbhome_1 This is the current patch level of both 12c and 19c homes (on both nodes!): Its worth... » read more
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
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