ASM -(Sector Disk Drives)

This post is about ASM’s attribute deep knowledge. Before going ahead we must have an idea about the topic. Let’s some line must explain about  ASM -(Sector Disk Drives). The database and Oracle’s Automatic Storage Management (ASM) volume manager explicitly understood 4k devices. In this and subsequent versions of ASM, disk groups created on native mode […]

Read More

ASM Disk Group Attributes

We are the part of RDBMS world. As a student when we entered in the world of RDBMS we learned about the attributes of the entity.  I hope you have the idea what we are going to do in this post.  As the heading of the post explains. Today we are going to have look at ASM Disk […]

Read More

Shutdown mode in Oracle ASM Instance

Being an Oracle DBA we have learned about the db instance in Oracle database. As we know db instance has shutdown mode. In this post, we are going to have look at Oracle ASM Instance. The ASM shutdown process is initiated when you run the SHUTDOWN command in SQL*Plus. While running this command we must ensure […]

Read More

ASM Dynamic Performance Views

We are going to have look at the ASM Dynamic Performance Views.  In the database, we have learned about views. Here we are going to focus on ASM Dynamic Performance Views. As we know An ASM instance does not have a data dictionary. The information relating to its configuration and operation is available by querying a set of […]

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 Change RAC Database Name

This article explains the steps which DBA must use to Change RAC Database Name. Before we must start the steps to change database name. Every DBA must know the condition in which have to change the name of a database.  When cloning the database on the same server. When we need to refresh the data.  […]

Read More

How To Convert A Non ASM Instance To ASM Instance

Let’s have fun with instance today. Being an Oracle DBA we are well known for Instance. DBA’s life starts from Instance. In early days of DBA training, we introduced with Instance. When we enter to the new part of Oracle. we notice new teams. Now I am going to focus on ASM instance. Some starting lines remind the […]

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

How To Find The Cluster Name In Oracle RAC

This article is short and simple. It explains the ways to find the cluster name in Oracle RAC. First few lines explain about the cluster. A cluster comprises multiple co-ordinated computers or servers that appear as if they are one server to end users and applications. Oracle RAC enables you to cluster Oracle databases. Oracle RAC uses […]

Read More

PRVF-5424 : Clock Time Offset Check Failed

We are going to have look on the steps which use to solve  RAC database installation INFO: PRVF-9652 : Cluster Time Synchronization Services check failed. While installing Oracle RDBMS home on Oracle Grid, you may get an error as below. ERROR: Clock Synchronization – This test checks the Oracle Cluster Time Synchronization Services across the cluster nodes. Error: […]

Read More