Add SCAN VIPs to Oracle RAC with zero β€œlistener” downtime

Intro Infrastructure teams are usually more keen to maintain a network stability rather than altering their existing configuration every other day.This means that once the application and database hosts are provisioned and running, the DBA won’t witness a topology change unless a migration of the servers/applications are in the pipes. But for highly available environment …

AHF Cheatsheet

Do You Speak AHF ? Oracle Autonomous Health Framework (AHF) presents the next generation of All in one solution that includes tools which work together autonomously 24×7 to keep database systems healthy and running. It does so while minimizing human reaction time using existing components like orachk, TFA and many more. I started digging about …

GoldenGate : setup Bi-Directional Replication in Multitenant environment (PDBs)

Intro GoldenGate replication solution allows you to capture, replicate, filter, transform, and deliver real time transactional data across Oracle or heterogeneous environments. Goldengate 12c features along with Oracle multitenant architecture introduced some changes to the way replication works (see Fig-1). Another interesting fact is that few of Oracle Streams features have now found their way …

Clone a RAC 12c VM environment with Virtualbox (import/export)

  Intro Have you ever finished a lab in your laptop with several virtual machines connected to each other and thought β€œWell that was neat! but how can I create a backup in my external hard drive and run it again at work or in any other computer?” The answer lays in this very article. …

Oracle Cloud 2nd gen DBAAS Tutorial: Deploy a 2 Nodes RAC database service

Intro Oracle Database Cloud Service (DBaaS) provides a platform to create full Oracle database instances in a virtual machine (VM). It’s the same familiar Oracle Database, now in Oracle cloud. Oracle made things even easier since you can now Sign Up for Free Oracle Cloud service and Get $300 of free credits good for up …