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 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

7
Read
Alex
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

0
Read
Alex
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

1
Read
Alex