Convert local listeners to Oracle Grid managed listeners

Intro One of the advantages of Oracle grid Infrastructure is to restart all managed resources (databases, asm, listeners,โ€ฆetc)  automatically whenever you (re)start the cluster service (crs) or reboot the whole server. I recently had to patch an oda where the client still had few listeners (with non default ports) managed locally and not through grid. …

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 …

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

MAA setupโ€“ Creating Single instance Physical Standby for RAC Primary – 12c

Introduction: Oracle provides many options for preventing downtime and data loss, all of which make up the Maximum Availability Architecture (MAA). The Oracle Maximum Availability Architecture offers a set of standard reference architectures–Bronze, Silver, Gold, and Platinum Solutions– that comply with Customer Business Objectives. With multiple instances, the RAC system gives a transparent HA and …