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

ORA-15073: Diskgroup Mounted By Another Instance

We know that in the database each and every  “Error “has its own reasons. Let’s have look on Error ORA-15073: Diskgroup Mounted By Another Instance. This article explains the cause and action for this error. Cause: An attempt was made to drop a diskgroup that is still mounted somewhere in the cluster by another instance. Action: dismount the […]

Read More

How To Rename ASM Diskgroup With RAC Database

  Below are the steps for renaming an ASM diskgroup with database files present inside for a running database.   EXAMPLE: In this article we will rename the diskgroup +DATATST to +NEWTST.  The database present inside the diskgroup is TESTDB2 . 1. Check configuration of the database: srvctl config database -d TESTDB2 srvctl config database -d […]

Read More

Steps for Copy ASM File From One Server To Another Server

In the world of Technology, we all know COPY and PASTE how much helpful for making any business operations. But in the field of Database, it is not same as in another area. Some different steps we have to use. Let’s have look on those steps which we use for Copy ASM File From One Server To Another Server. Copying file between […]

Read More

Move Datafile From File System To ASM Disk In 11g

Today, we are going to learn about those steps which use to move Datafile from file system to ASM disk in Oracle 11g.Being an Oracle DBA we have deep knowledge of Datafiles. We know there importance of Datafiles in the database. Somes lines explain about the technical definition. A data file is a file that is […]

Read More

Steps for Install Grid Infrastructure 12c On Standalone Server

Today, we are going to have look on the steps which is used for Install Grid Infrastructure 12c On Standalone Server. Grid installation on the standalone database server is also known as Oracle Restart. This is required if you wish you use ASM file system with Oracle restart feature. Oracle Restart Means, During any accidental Hardware or software […]

Read More

RMAN Active Cloning From RAC TO RAC

Being an Oracle DBA we know that what is cloning? This technical definition gives you a correct idea of the cloning. RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server with the same file structure, […]

Read More