Infrastructure at your Service

ASM Archives - Blog dbi services

Daniel Westermann

udev rules for ASM devices on RHEL 7

By | Database Administration & Monitoring | 2 Comments

Preparing the storage devices for use with ASM is one of the first tasks you should do. When you do not want to use ASMLib then udev is what you should use for this. As the order/naming of the devices in the device tree is not guaranteed (e.g. dm-1 is not guaranteed to be the same device after a reboot of the system) you need a way to fix this and that is what udev…

 
Read More
Franck Pachot

Where is the ASM SPFILE?

By | Database Administration & Monitoring | No Comments

In the previous blog post, to the question “where is the ASM SPFILE” I answered by running ‘asmcmd spget’. But this is available only if the ASM instance is started. If you have corrupted your SPFILE (and it’s easy to do it) you can start with a local PFILE and the CREATE SPFILE= FROM PFILE. But then you get the location of the local one you used. If you need to know the shared location,…

 
Read More
Franck Pachot

Extended clusters and asm_preferred_read_failure_groups

By | Database Administration & Monitoring | One Comment

When you have 2 sites that are not too far you can build an extended cluster. You have one node on each site. And you can also use ASM normal redundancy to store data on each site (each diskgroup has a failure group for each site). Writes are multiplexed, so the latency between the two sites increases the write time. By default, reads can be done from one or the other site. But we can,…

 
Read More
Daniel Westermann

Upgrading the Grid Infrastructure from 12.1.0.1 to 12.1.0.2 on the command line

By | Database Administration & Monitoring | 2 Comments

A lot of people use the graphical way to upgrade Oracle software from one version to another. While there is nothing to say against that the same can be done without any graphical tools. This post outlines the steps to do so. Currently my cluster is running Grid Infrastructure 12.1.0.1 without any PSU applied. The node names are racp1vm1 and racp2vm2: [grid@racp1vm2 ~]$ /u01/app/12.1.0/grid_1_0/bin/crsctl query crs softwareversion Oracle Clusterware version on node [racp1vm2] is [12.1.0.1.0]…

 
Read More
David Hueber

ODA – VMs possibilities & performances

By | Hardware & Storage | No Comments

As you know it is possible to install the ODA in a virtualized mode and to take avantages from all cores not licensed with Enterprise Edition for additional VMs. The question is what could we do with it and which performances could we expect… The answer to the first question is indeed pretty simple….almost everything. If you have and ODA X5-2 with the version 12.1.2.3.0 implemented in virtualized mode then you are running an OVM…

 
Read More
Oracle Team

Oracle Database 12c: ACFS – un système de fichier pour vos bases

By | Technology Survey | One Comment

La version 12c d’Oracle Grid Infrastructure introduit de nombreuses nouveautés dans le support d’ACFS, le système de fichiers clusterisés d’Oracle. Nous abordons dans ce posting la capacité d’ACFS d’être le système de fichier de votre base de données ainsi que sa capacité de mise en œuvre des snapshots. Rappel sur ACFS Ce système de fichier est apparu avec la version 11.2 du cluster Oracle. Il s’appuie sur ASM ainsi qu’ADVM pour ASM Dynamic Volume Manager. Il est…

 
Read More
Oracle Team

Oracle Database 12c: Grid Infrastructure, quoi de neuf?

By | Operation systems | One Comment

A la lecture du New Features Guide, on trouve dans le chapitre sur Grid Infrastructure beaucoup de nouvelles fonctionnalités pour Grid Infrastructure, ASM et ACFS, mais l’événement est l’annonce d’une grosse évolution dans l’architecture du cluster. Flex Cluster En effet, cette version 12c introduit une nouvelle architecture nommée Flex Cluster dont voici un aperçu: Schema Oracle documentation Les objectifs annoncés sont “évolutivité, flexibilité et facilité de gestion”. Ainsi, nous pourrons choisir l’organisation “topologie” de notre…

 
Read More