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 […]
Articles Tagged: RAC
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 […]
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 […]
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 ##################################################### […]
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 […]
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 […]
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 […]
opatch version – Initial heap size set to a larger value than the maximum heap size
The below issue was faced by my fellow DBA while in checking OPatch version in Grid Home, Interestingly the same OPatch utility works fine in RDBMS Home Issue-OPatch version command failed with below error on GRID_HOME but it was working fine on DB home Error:- opatch version Error occurred during initialization of VM Initial heap […]
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. […]
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 […]