Category: General

This article provides a step-by-step guide to changing the DB_UNIQUE_NAME parameter in Oracle Database after cloning, migration, or environment refreshes. It explains how to relocate database files, including datafiles, tempfiles, redo logs, control files, SPFILE, and password files, to a new directory structure in ASM or filesystem storage, while also covering for pdb$seed and Oracle Clusterware configuration.

This post discusses a perplexing issue with node evictions in an Oracle RAC setup, where node crashes occurred due to a loss of connection on a private interconnect despite redundancy. It highlights troubleshooting steps and findings, particularly focusing on the cluster_interconnects parameter. Ultimately, the solution involved resetting this parameter to default values, enabling the use of Highly Available IPs for improved reliability and communication in the cluster.

This blog introduces the concept of holistic patching for Oracle Enterprise Manager, which simplifies and consolidates patch management for its various components. The method aims to reduce complexity and downtime by bundling updates into a single package, allowing organizations to focus on core activities. The process involves updating the OMSPatcher and executing a simple command for patching, significantly streamlining the patching process for Enterprise Manager.