Sample Code for Oracle ASM instance Configuration

Are you very worried about the actual configuration of Oracle ASM instances? If this is the case, the following articles will give you the corresponding solutions. The following articles mainly introduce the Oracle ASM instance configuration solution. The following describes the specific content.

3.1 initialization parameters

 
 

  
  
[oracle@node1 bin]$ export ORACLE_SID=+ASM1  
  
  
[oracle@node1 bin]$ sqlplus / as sysdba  
  
  
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Feb 21 19:10:51 2010  
  
  
Copyright (c) 1982, 2005, Oracle. All rights reserved.  
  
  
Connected to:  
  
  
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production  
  
  
With the Partitioning, Real Application Clusters, OLAP and Data Mining options  
  
  
SQL> create pfile from spfile;  
  
  
File created.  
  
  
SQL> show parameter asm  
  
  
NAME TYPE VALUE  
  
  
asm_diskgroups string FLASH_RECOVERY_AREA, DATA  
  
  
asm_diskstring string  
  
  
asm_power_limit integer 1  
  
  
[oracle@node2 dbs]$ pwd  
  
  
/u01/app/oracle/product/10.2.0/db_1/dbs  
  
  
[oracle@node2 dbs]$ ls  
  
  
ab_+ASM2.dat hc_rac2.dat initrac2.ora orapwrac2  
  
  
hc_+ASM2.dat init+ASM2.ora orapw+ASM2  
  
  
[oracle@node2 dbs]$ more init+ASM1.ora  
  
  
+ASM2.asm_diskgroups='FLASH_RECOVERY_AREA'#Manual Dismount  
  
  
+ASM1.asm_diskgroups='FLASH_RECOVERY_AREA','DATA'#Manual Mount  
  
  
*.asm_diskgroups='FLASH_RECOVERY_AREA','DATA'  
  
  
*.background_dump_dest='/u01/app/oracle/admin/+ASM/bdump' 
  
  
*.cluster_database=true 
  
  
*.core_dump_dest='/u01/app/oracle/admin/+ASM/cdump' 
  
  
+ASM2.instance_number=2  
  
  
+ASM1.instance_number=1  
  
  
*.instance_type='asm' 
  
  
*.large_pool_size=12M 
  
  
*.remote_login_passwordfile='exclusive' 
  
  
*.user_dump_dest='/u01/app/oracle/admin/+ASM/udump' 
 
 

Instructions:

The memory required by the SGA of the Oracle ASM instance is small. Generally, the default value is enough without modification. The default value of asm sga is as follows:

 
 

  
  
SHARED_POOL_SIZE = 48M 
  
  
LARGE_POOL_SIZE = 12M 
  
  
SHARED_POOL_RESERVED_SIZE = 24M 
  
  
SGA_MAX_SIZE = 88M 
 
 

These default values can be viewed through show parameter in sqlplus.

Instance_type: for ASM instances, set this parameter to Oracle ASM. For database instances, set this parameter to RDBMS.

DB_UNIQUE_NAME: use the default value + ASM.

 
 

  
  
SQL> show parameter asm_power_limit  
  
  
NAME TYPE VALUE  
  
  
asm_power_limit integer 1  
 
 

Oracle ASM_POWER_LIMIT: When a disk is added to or deleted from a disk group, the disk group automatically allocates data between the new and old disks to achieve scattered IO. This process is called Rebalance );

This action moves data between disks. Therefore, although online operations still affect some performance, it must be performed when the system is idle. This parameter controls the Rebalance speed. The value range is 0-11. the minimum value 0 indicates that Rebalance is not performed. The maximum value 11 indicates the fastest speed and seriously affects performance. 1 indicates the slowest speed and the minimum performance impact. In addition to defining this parameter in the initialization parameter, you can also specify this parameter during the operation.