Skip to main content

Posts

Oracle RAC Architecture, Processes and Services Guide

Introduction Oracle Real Application Clusters lets more than one database instance mount and open the same physical database at the same time, with each instance running on its own server node. The instances share the underlying datafiles, control files, and redo threads through shared storage, while each node runs its own memory structures and background processes. This post lays out the architecture, the key differences from a standalone database, the processes that keep a RAC cluster running, what is shared versus what is node-specific, and the listener and service layer that routes client connections, including the practical srvctl commands for managing services day to day. Quick Glossary A few acronyms come up repeatedly below. Worth skimming once before the rest of the post, especially if RAC is new territory. Term Meaning GI Grid Infrastructure, the combined Clusterware and ASM software stack underneath the database ASM Automatic Storage Management, the shared storage ...

Oracle 19.33 Patching on 19c RAC using Out-of-Place Method

Introduction Out-of-place patching builds a brand new Oracle home that already contains the Release Update, then moves the cluster or the database over to it. The old home stays untouched on disk, so the running environment is never modified and going back is a matter of pointing at the old path again. This guide patches a two-node Oracle 19c RAC from the base 19.3 release to 19.33, covering both the Grid Infrastructure home and the Database home, with each node switched one at a time so the database stays available on the other node. The sequence is: capture a baseline, install the new Grid home with the RU applied, switch Grid on Node 1, install the new Database home, switch the database on Node 1, switch Grid on Node 2, run datapatch once, and verify. Prerequisites Check the following before starting. A working two-node Oracle 19c RAC at the base 19.3 release, with the Grid home at /u01/app/grid/19c/grid_1 and the database home at /u01/app/oracle/19c/db_1 . The oracl...
↑