Manually Converting Non-RAC DB to RAC DB

In previous articles, we have seen various methods of converting Non-RAC database to RAC database. In this article, we will convert non-RAC database to RAC database using RMAN backup-restore utility. Single Instance DB Name RAC DB name RAC Instance Node RAC Instance Name RAC Node Name MGR MGR Node 1 db1 RAC1 Node 2 db2 […]

Read More

ORA-29702: ERROR OCCURRED IN CLUSTER GROUP SERVICE OPERATION

This is the post for the error “ORA-29702”. ORA-29702: ERROR OCCURRED IN CLUSTER GROUP SERVICE OPERATION Cause: An unexpected error occurred while performing a CGS operation.   Action: Verify that the LMON process is still active. Also, check the Oracle LMON trace files for errors. ##################################################### ORA-29702: ERROR OCCURRED IN CLUSTER GROUP SERVICE OPERATION ##################################################### […]

Read More

Converting RAC DB to Non-RAC on Normal File System

To convert RAC to Non-RAC DB on normal file system we need to first convert it into ASM storage Converting RAC db to Non-RAC db In this article we will see conversion database from ASM to Normal File System : Step 1 : Check details of ASM database and create pfile from spfile :

[…]

Read More

Converting RAC db to Non-RAC db

In previous Articles we have seen conversion from Single Instance DB to RAC db using various methods.In this Article we will see conversion of RAC to Normal DB[Single Instance]. Prerequisites : RAC Instance Node RAC Node Name RAC DB Name RAC Instance Name  Single Instance DB name Node 1 RAC1 test db1 test Node 2 […]

Read More

Convert Single Instance Database to Oracle RAC

In this post, we can perform Convert Single Instance Database to Oracle RAC in Oracle 11gR2. Prerequisites: we already have single instance ASM database up and running. we have already have second node with ASM running. If you want to how to convert non asm database to asm database with duplicate command: Click Here RAC […]

Read More

Oracle RAC 12c Setup Using Virtual Box

In this article, I have described each and every step required for setting up a 2 node RAC12c database using virtual box for testing purpose. Softwares Required: 1. Virtual box : 2. Linux 3. Oracle 12c home: 4. Oracle 12c Grid: Virtual Machine setup: Here we have to set up 2 nodes inside virtual box. […]

Read More

How To Move Voting Disk To Another ASM Disk

This article explains the steps which we use to move  VOTING DISK to another ASM DISK. In first few lines remind us about the definition of VOTING DISK and ASM DISK.  After complete, we have mentioned the way to add a voting disk to another ASM.  What is VOTING DISK? The Voting Disk File is a […]

Read More

Applying JVM Patch In Oracle 12c RAC

This article explains the steps for applying the jvm patch on RAC. In the last post of mine. I have gone through the Patches and its types. 1. check for conflict https://www.linkedin.com/in/dbaanuradhamudgalcd /softdump/patch/JVM/22139226 opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 12.1.0.1.10 Copyright (c) 2016, Oracle Corporation. All rights reserved. PREREQ session Oracle […]

Read More