Friday, November 18, 2011

Creating ASM instance (Manually)

Manual creation of ASM instance is not complex at all as it seems. Following steps can be performed to create the ASM manually

  1. Directory creation for ASM instance
  2. Parameter file creation (PFILE)
  3. Start the ASM instance
  4. Create the ASM server parameter file (SPFILE)

Directory Creation for ASM instance:

Assuming you have defined $ORACLE_BASE parameter, following are the set of commands that can be used while creating the directories on LINUX


mkdir -p $ORACLE_BASE/admin/+ASM/bdump 

mkdir -p $ORACLE_BASE/admin/+ASM/cdump 
mkdir -p $ORACLE_BASE/admin/+ASM/hdump 
mkdir -p $ORACLE_BASE/admin/+ASM/pfile 
mkdir -p $ORACLE_BASE/admin/+ASM/udump

Parameter file creation (PFILE):
The ASM instance will require a parameter file like any other Oracle instance. However, the number of parameters that you will need to set for an ASM instance is relativity small and also some parameters are unique to ASM instance.Here is an example ASM parameters



# ASM_DISKGROUPs=’DISK GROUP_ROB1’


background_dump_dest=/u01/app/oracle/admin/+ASM/bdump 
core_dump_dest=/u01/app/oracle/admin/+ASM/cdump 
user_dump_dest=/u01/app/oracle/admin/+ASM/udump 

instance_type=asm 
compatible=11.1.0.6.0 
remote_login_passwordfile=exclusive 


# Note, the ASM_DISKGROUPS parameter is commented out for now.

Start the ASM instance :


The ASM instance can be started however, error will be generated (no disk group mounted) since the disk group has not been added as yet. Pl. see the post http://www.bash-dba.com/2011/11/adding-asm-disc-group.html on how to add the disk groups

Create ASM server parameter file (SPFILE)


After starting the instance, create SPFILE from PFILE as shown below
create spfile from pfile=’/u01/opt/oracle/admin/+ASM/pfile/init.ora’; 







No comments:

Post a Comment