Quorum failure group in Oracle ASM

Voting files manage information about node membership. OCR is a system that manages cluster and Oracle Real Application Clusters (Oracle RAC) database configuration information. A quorum failure group is a special type of failure group and disks in these failure groups do not contain user data. A quorum failure group is not considered when determining […]

Read More

Changing password securely in Oracle

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – We are living in the world of username and password life. We all have countless password due to technology’s development. Password plays an important role in our life. Oracle Database leads the industry in security. To maximize the security […]

Read More

Deleting diskgroup via asmcmd

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. The goal here is to show that via asmcmd it is also possible to remove a disk group. Let’s briefly see how to do this. We list the disk groups:

So we tried to delete the diskgroup:

Note that […]

Read More

ORA-15032: Not All Alterations Performed

While setting attribute on a ASM diskgroup, we got below error.

Solution: Alter operations on ASM diskgroups need to be done from sysman user , instead of sysdba user.

Read More

Introducing new disks to ASM using ASMFD

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. This article provides the information to create new disks to ASM using ASMFD. In my cluster, I have 2 nodes: london1 and london2. From one of the ready nodes the newly added shared disk:

Note that this disk has […]

Read More

Separating OCR and Voting Disk in Oracle Clusterware 12c

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Objective: Describe the advantages of separating OCR and RV and also present the process needed to do this. NOTE: Although the procedure was performed in version 11gR2, the steps are the same for version 12c. In this article, we will […]

Read More

Creating diskgroup via asmcmd

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – This article is about creating disk-group via asm cmd. Being an Oracle DBA we have knowledge of ASM. Automatic Storage Management (ASM) is Oracle’s logical volume manager, it uses OMF (Oracle Managed Files) to name and locate the database files. […]

Read More