How to create an Oracle WALLET for Applications to use

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

RMAN duplicate for standby fails with ORA-19845

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

How to Install Windows 2012R2 Standard Edition in VirtualBox

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 win-rac2 win-rac-control Here the steps to create WIN-RAC-CONTROL (the controller) on... » read more

How to Upgrade Oracle 12c to 19c on a Window Failover Cluster Manager environment

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