Oracle ASMLIB v/s Oracle ASM Filter Driver (ASMFD)

Oracle ASM Filter Driver (Oracle ASMFD) is installed with an Oracle Grid Infrastructure installation. If you have an existing Oracle ASM library driver (Oracle ASMLIB) configuration, then depending on whether you want to use Oracle ASMLIB or Oracle ASMFD, consider the following scenarios: If you use Oracle ASMLIB to manage your Oracle ASM devices and […]

Read More

Back Up & Restore an Oracle ASM Password File with pwget Command

In this article we are showing how to backup and restore password file of Oracle ASM with pwget command. pwget Purpose Returns the location of the password file for the Oracle ASM or database instance. pwcopy Purpose Copies an Oracle ASM or database instance password file to the specified location. pwset Purpose Sets the location […]

Read More

Different ways to find spfile location in Oracle RAC

1. By using SqlPlus $ sqlplus / as sysasm SQL> show parameter spfile NAME    TYPE      VALUE ——     ——     ————————————————- spfile     string     +DATA/ASM/ASMPARAMETERFILE/registry.253.822856169 SQL> 2. By using ASMCMD find command $ asmcmd find –type ASMPARAMETERFILE +DATA “*” +DATA/ASM/ASMPARAMETERFILE/REGISTRY.253.822856169 3. By using spget command ASMCMD> spget +DATA/ASM/ASMPARAMETERFILE/REGISTRY.253.822856169 […]

Read More

Use spget and spmove command in Oracle ASM

Starting with ASM version 11.2, the ASM spfile can be stored in an ASM disk group. Indeed, during a new ASM installation, the Oracle Universal Installer (OUI) will place the ASM spfile in the disk group that gets created during the installation. New ASMCMD commands To support this feature, new ASMCMD commands were introduced to […]

Read More

Rename Empty Diskgroup on ASM 11gR2

The goal here is to rename the DATA diskgroup to DG_PROD_DATA – here is the situation before the rename operation : # asmcmd lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED NORMAL N 512 4096 1048576 32756 31828 244 15792 0 N DATA_OCR/ MOUNTED EXTERN N 512 4096 1048576 16378 […]

Read More

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

Upgrade Oracle Grid and Database (11.2.0.1 to 11.2.0.4)

This article is about upgrade of oracle database 11.2.0.1_to 11.2.0.4). [oracle@india2 grid]$ ./runcluvfy.sh stage -pre crsinst -upgrade -n india1,india2 -rolling -src_crshome /u01/11.2.0/grid -dest_crshome /u01/11.2.4/grid -dest_version 11.2.0.4.0 -fixup -fixupdir /home/oracle/logs -verbose |tee /home/oracle/logs/runcluvfy1210.out [oracle@india2 logs]$ more runcluvfy.out |grep -i ‘failed’ india2        missing                   9413827 or 9706490        failed india1        missing                   9413827 or 9706490        failed Result: Check for Oracle patch […]

Read More

Converting Standard to Flex Cluster

Introduction Oracle Real Application Cluster (RAC) is a well-known product among Oracle’s solutions to maintain high availability of your business data. Oracle RAC allows the work load to be shared among all the cluster nodes, with N-1 tolerance configuration in case of node failures, where N is the total number of nodes. Oracle RAC is […]

Read More

Converting Standard to Flex ASM

Today we are going to have a look on converting a standard cluster to flex cluster. I wish this information is useful for you.Oracle Flex Clusters contribute a platform for Oracle Real Application Clusters databases with stupendous numbers of nodes, to support massive parallel query operations. Oracle Flex Clusters also provide a platform for other […]

Read More

File Group in a Flex Disk Group

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. In the goal here is to know a bit more about the Flex Disk Group. Let’s see here what a File Group is. In a Flex Disk Group we can separate our databases, be they PDBs, CDBs or non-CDBs, in different File Group. Each […]

Read More