Basics This post describes some advantages the Linux specific ASM library provided by Oracle (herein "ASMLib") brings to the administration of a Linux system running Oracle. Linux often presents the challenge of disk name persistence. Change the storage configuration and a disk that appeared as /dev/sdg yesterday can appear as /dev/sdh after a reboot today. How can these changes be isolated so that they do not affect ASM? Why Not Let ASM Scan All Disks? ASM scans all disks it is allowed to … [Read more...] about Understanding Device Persistence and Oracle ASMLib
ASM
ASMLib-Managed Disks on Multipathed iSCSI Targets are not Discovered after Server Reboot in CentOS/RHEL 7
The Problem Oracle Real Application Clusters (RAC) servers run on CentOS/RHEL 7 and utilizing ASMLib-managed iSCSI multipathed disks. Upon server reboot, Oracle ASMLib disks are not automatically discovered at boot time causing Oracle Cluster Ready Services (CRS) to fail to start. ASM disks are, however, correctly discovered when manually running the oracleasm scandisks command soon after the server reboot. Following is the oracleasm configuration # cat … [Read more...] about ASMLib-Managed Disks on Multipathed iSCSI Targets are not Discovered after Server Reboot in CentOS/RHEL 7
How to load SELinux Module For Oracleasm
Question: How to load the SELinux module for oracleasm? When searching for the selinux oracleasm module with the locate command it may return as if the file exists: # locate /oracleasm.pp /etc/selinux/targeted/modules/active/modules/oracleasm.pp However, when running the command semodule to load the oracleasm.pp module it fails: # semodule --verbose -i /etc/selinux/targeted/modules/active/modules/oracleasm.pp Attempting to install module … [Read more...] about How to load SELinux Module For Oracleasm
How to extend ASM disk from OS level in CentOS/RHEL
Question: How to expand the physical raw disk which is part of ASM diskgroup? Below are the steps to extend the physical disk which is part of ASM diskgroup. 1. First, you have to unmount the disk you want to extend at the ASM level. 2. Check the disks present at the OS level and their size. # lsblk NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT sda 8:0 0 12G 0 disk ├─sda1 8:1 0 500M 0 part /boot └─sda2 8:2 0 11.5G 0 part ├─ol-root 251:0 0 10.3G 0 lvm / └─ol-swap 251:1 0 1.2G 0 lvm … [Read more...] about How to extend ASM disk from OS level in CentOS/RHEL
Beginners Guide to Automatic Storage Management (ASM)
The Basics Automatic Storage Management (ASM) provides vertical integration of the file system and the volume manager for Oracle database files. ASM can provide management for single symmetric multiprocessing (SMP) machines or across multiple nodes of a cluster for Oracle Real Application Clusters (RAC) support. Oracle ASM Cluster File System (ACFS) is a multi-platform, scalable file system, and storage management technology that extends ASM functionality to support application files outside … [Read more...] about Beginners Guide to Automatic Storage Management (ASM)
Beginners Guide to Working with spfile in Oracle ASM
Introduction 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. This is true for both Oracle Restart (single instance environments) and Cluster installations. It should be noted that the first disk group created during the installation is the default spfile location, but not a requirement. The spfile … [Read more...] about Beginners Guide to Working with spfile in Oracle ASM
How to Manage Oracle database Audit File Directory Growth with cron (ASM Instances Only)
The audit file destination directories for an ASM instance can grow to contain a very large number of files if they are not regularly maintained. Having a very large number of files can cause the file system to run out of free disk space or inodes, or can cause Oracle to run very slowly due to file system directory scaling limits, which can have the appearance that the ASM instance is hanging on startup. This post explains how to use the Linux cron utility to manage the number of files in the … [Read more...] about How to Manage Oracle database Audit File Directory Growth with cron (ASM Instances Only)
How to Force ASM to Scan the Multipathed Device First using ASMLIB/oracleasm
ASMLib/oracleasm can only be implemented on Linux OS. When using multipathing, you want to FORCE oracleasm to scan the multipathed devices first. This reduces the scan time as by default oracleasm tries to scan each and every device including the multiple paths to it. On all nodes: 1. Shutdown all (DB and ASM): You should stop all before restart ASMLib (eg: DB, ASM and HAS (crsctl stop crs for RAC) if you are in 11.2 - crsctl stop has): If the diskgroups are mounted, it will fail with … [Read more...] about How to Force ASM to Scan the Multipathed Device First using ASMLIB/oracleasm
Unable to create spfile for Oracle ASM instance
The Problem While trying to create spfile in asm instance, the following errors are encountered: SQL> create spfile='+' from pfile='/grid/dbs/init+ASM.ora'; create spfile='+' from pfile='/dbs/init+ASM.ora' * ERROR at line 1: ORA-01078: failure in processing system parameters ORA-00600: internal error code, arguments: [ksprcvsp:ksfdread_resilver], [0x09D00B1D0], [4], [0x7F01BA873800], [1024], [], [], [], [], [], [], [] The following disks are showing for ASM01 diskgroup: Sql> select … [Read more...] about Unable to create spfile for Oracle ASM instance
Oracle ASM 11gR2 instance is unable to start due to missing ASM spfile
The Problem 1) On ASM 11gR2 the ASM spfile initialization parameter file is now stored in the first created diskgroup (e.g. DATA). For example: SQL> show parameter instance_type NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ instance_type string asm SQL> show parameter spfile NAME TYPE VALUE … [Read more...] about Oracle ASM 11gR2 instance is unable to start due to missing ASM spfile