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)
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
Oracle 11gR2 (11.2.0.1) Unable To Create ASM Spfile Standalone
The Problem Unable to create spfile due to the next error: SQL> startup pfile='init+ASM.ora'; ASM instance started Total System Global Area 283930624 bytes Fixed Size 2206088 bytes Variable Size 256558712 bytes ASM Cache 25165824 bytes ASM diskgroups mounted SQL> create spfile='+DGR1' from pfile='init+ASM.ora'; create spfile='+DGR1' from pfile='init+ASM.ora' * ERROR at line 1: ORA-17502: ksfdcre:4 Failed to create file +DGR1 ORA-15221: ASM operation requires compatible.asm of … [Read more...] about Oracle 11gR2 (11.2.0.1) Unable To Create ASM Spfile Standalone
How to move ASM spfile to a shared device in RAC
If you are using pfile, it must be a text file on local filesystem. If using spfile, then it can be in the following locations. a filesystem file spfile on local filesystem spfile on shared device a ASM file in a ASM diskgroup (only for spfile for instances after 11.2) Here are steps to put ASM spfile on a shared device. 1. Edit the pfile and make sure all the parameters could be used for all instances. 2. Login to ASM with sqlplus and startup nomount with pfile. 3. Run the … [Read more...] about How to move ASM spfile to a shared device in RAC
How to recreate the spfile for RAC instances where the spfile is stored in ASM
Question: How do I recreate an spfile for a RAC database that is stored in ASM when the RAC instances cannot be started using the parameters currently held in that spfile? The spfile has a parameter set which is not allowing the database instance to start using the spfile. The parameter settings used to start the instance can be located from the alert.log for the instances. These entries can be used to created a valid spfile. If you have a valid pfile then you will NOT need to perform step 1 … [Read more...] about How to recreate the spfile for RAC instances where the spfile is stored in ASM
How To Create An ASM Diskgroup Using XML code in ASMCMD
The post provides you an example about how to create an ASM diskgroup using XML code through the asmcmd command. 1. Create a XML file (e.g. diskgroup.xml) with the next code: <dg name="datadg" redundancy="normal"> <fg name="SAN1"> <dsk string="ORCL:ASMDISK1"/> <dsk string="ORCL:ASMDISK2"/> </fg> <fg name="SAN2"> <dsk string="ORCL:ASMDISK3"/> <dsk string="ORCL:ASMDISK4"/> </fg> <a name="compatible.asm" value="11.2"/> <a … [Read more...] about How To Create An ASM Diskgroup Using XML code in ASMCMD