You have a standby DB out of sync and all logs on primary are gone. At this stage you have 2 options: 1:- rebuild standby 2:- Rollforward standby What about a “one line” command that does automatically all the steps you usually do on a rollforward? Here is the magic: After this, you just need... » read more
While recreating an standby DB from an active primary RAC DB, rman might fail with these errors: This is not an actual issue on the standby side, but instead a RMAN config on primary. Since primary is a RAC DB, snapshot control file needs to be located on a shared location, so lets change to:... » 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
This is an easy one. This is the error/warning you might while connecting to RMAN: The way to fix it is running this: And error gone! Post Views: 1,638
We are going to install Windows 2012R2 Standard Edition in VirtualBox as part of creating a Oracle Windows Cluster. We want to have 3 server: 1 Controller + 2 Database servers: Server Name Public IP: Private IP: win-rac1 192.168.56.151 192.168.10.151 win-rac2 192.168.56.152 192.168.10.152 win-rac-control 192.168.56.153 192.168.10.153 Here the steps to create WIN-RAC-CONTROL (the controller) on... » 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 Post Views: 1,935
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): Post Views: 1,442
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