HOME > > Create and Configure ASM Instance and ASM DISK Groups

Create and Configure ASM Instance and ASM DISK Groups

Anup - Tuesday, October 4, 2022

We can use two methods “DBCA” or “Manual”, for creating ASM Instance and Disk group. Here I will describe both methods. You can choose one of them.


By “DBCA”


Step 1 log in as a ORACLE user , set following environment and invoke DBCA :

$export ORACLE_HOME=/export/oracle/oracle/product/10.2.0/db

$export PATH=$ORACLE_HOME/bin:$PATH

$dbca


Step 2 Choose oracle RAC database configurations.







Step 3 Choose “Configure Automatic Storage Management”




Step 4 Choose BOTH NODE.





Step 5 Choose As per screen Shot




Step 6 Clicks on Create New.


 




Step 7 Create Disk Group as per screen shot.




Step 8 Choose As per screen Shot. Create Disk Group as per screen shot.



Step 9 oracle Automatically create ASM, ASM Disk group and mount the Instance and Disk group on both node.


Step 10 Verify status of services. 

$/export/home/oracle/oracle/product/10.2.0/crs/bin/crs_stat –t


By “MANUAL”


Step 1 Create parameter files (int+ASM1.ora) for ASM instance on the first node.


Create init+ASM1.ora file for ASM Instance and put it default location.

Cluser_database=true

asm_diskgroups='DATA',‘RECOVERY’

#asm_diskstring='/dev/rdsk/c0d1s*'

background_dump_dest=/export/home/oracle/oracle/admin/+ASM/bdump

core_dump_dest==/export/home/oracle/oracle/admin/+ASM/cdump

user_dump_dest==/export/home/oracle/oracle/admin/+ASM/udump

instance_type=asm

large_pool_size=16M

remote_login_passwordfile=exclusive

+ASM1.instance_number=1

+ASM2.instance_number=2


Step 2 Create password file for the ASM instance on first node. Using the orapwd utility, create an orapw+ASM1 file in $ORACLE_HOME/dbs on the second node.


$orapwd file=orapwd+ASM1 password=sys entries=5


Step 3 Start the first ASM instance (+ASM1). 


$ export ORACLE_SID=+ASM1

$ sqlplus / as sysdba


SQL*Plus: Release 10.2.0.2.0 - Production on Thu Oct 26 18:43:14 2009

 Copyright (c) 1982, 2004, Oracle.  All rights reserved.

 Connected to an idle instance.


SQL> startup nomount


ASM instance started 

Total System Global Area 125829120 bytes 

Fixed Size 769268 bytes 

Variable Size 125059852 bytes 

Database Buffers 0 bytes 

Redo Buffers 0 bytes

ORA-15110: no diskgroups mounted

SQL>


Step 4 create Disk Group


SQL> create diskgroup DATA normal redundancy

failgroup one disk '/dev/rdsk/c0d1s3'

failgroup two disk '/dev/rdsk/c0d1s4';


Diskgroup created. 


SQL> create diskgroup RECOVERY external redundancy disk '/dev/rdsk/c0d1s5';

Diskgroup created.


Step 5 Create parameter files (int+ASM2.ora) for ASM instance on the second node.


Create init+ASM1.ora file for ASM Instance and put it default location.

Cluser_database=true

asm_diskgroups='DATA',‘RECOVERY’

#asm_diskstring='/dev/rdsk/c0d1s*'

background_dump_dest=/export/home/oracle/oracle/admin/+ASM/bdump

core_dump_dest==/export/home/oracle/oracle/admin/+ASM/cdump

user_dump_dest==/export/home/oracle/oracle/admin/+ASM/udump

instance_type=asm

large_pool_size=16M

remote_login_passwordfile=exclusive

+ASM1.instance_number=1

+ASM2.instance_number=2


Step 6 Create password file for the ASM instance on second node. Using the orapwd utility, create an orapw+ASM2 file in $ORACLE_HOME/dbs on the second node.


$orapwd file=orapwd+ASM2 password=sys entries=5


Step 7 Start the second ASM instance (+ASM2). 


$ export ORACLE_SID=+ASM2

$ sqlplus / as sysdba


SQL*Plus: Release 10.2.0.2.0 - Production on Thu Oct 26 18:43:14 2009

 Copyright (c) 1982, 2004, Oracle.  All rights reserved.

 Connected to an idle instance.


SQL> startup nomount


ASM instance started 

Total System Global Area 125829120 bytes 

Fixed Size 769268 bytes 

Variable Size 125059852 bytes 

Database Buffers 0 bytes 

Redo Buffers 0 bytes

ORA-15110: no diskgroups mounted

SQL>


Step 8 Register the ASM instances with CRS. 


For higher availability, register the ASM instances with the CRS. When registered, the CRS should detect any failed instances and automatically attempt to start up the instances. The CRS should also automatically start up the instances when the servers are rebooted.

 

On node RCA1: 


$ srvctl add asm -n rac1 -i +ASM1 -o /export/home/oracle/oracle/product/10.2.0/db

$ srvctl start asm -n rac1 

$ srvctl status asm -n rac1

ASM instance +ASM1 is running on node rac1.

 

On node RAC2: 


$ srvctl add asm -n rac2 -i +ASM2 -o /export/home/oracle/oracle/product/10.2.0/db

$ srvctl start asm -n rac2

$ srvctl status asm -n rac2 

ASM instance +ASM2 is running on node rac2.  


Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me