Configuring Data Guard in Oracle Cloud Infrastructure (OCI)

In previous article, we saw the creation of Oracle RAC on Oracle Cloud Infrastructure (OCI) Installation of Oracle RAC on Oracle Cloud Infrastructure(OCI) In this post, we will see how to configure data guard with RAC on OCI. Assumption : Oracle RAC database is already installed and configured on OCI. Click on Displa Name: DBSVM […]

Read More

New Features of RAC & ASM in Oracle 19c

These are the new features for Oracle Automatic Storage Management 19c. SRVCTL command enhancements Flushing the password file metadata Automatic block corruption recovery with the CONTENT.CHECK disk group attribute New and updated ASMCMD commands The password option with the ASMCMD pwcreate command is now optional. The new ASMCMD setsparseparent command sets the parent for a sparse child file. The new ASMCMD mvfile command moves a […]

Read More

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 : [oracle@rac1 […]

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