– In general to be able to start up the CRS properly. There should be a proper pfile or spfile to let the ASM instance startup and/or the gpnp profile should indicate to a proper spfile.
$ export $ORACLE_SID=[asm instance name]$ export $ORACLE_HOME=[full path of the asm home]$ sqlplus / as sysdba
sql> startup pfile=[the full pathname of ora_+ASM1.ora]The ASM instance shall start up properly
3. Check if the ASM diskgroups are mounted properly or not.
sql> select name,state from v$asm_diskgroup;
4. Create the spfile:
sql> create spfile='+DATA/../spfileasm.ora' from pfile='[the full path name of ora_+ASM1.ora]5. In the GPnP profile we shall find that the spfile information set properly there.
In our case the spfile indicated in the GPnP profile was not found in the ASM diskgroup.
# cat /u01/app/11.2.0/grid/gpnp/gps-rac2/profiles/peer/profile.xml
– In general to be able to start up the CRS properly. There should be a proper pfile or spfile to let the ASM instance startup and/or the gpnp profile should indicate to a proper spfile.
1. Create a new ASM pfile.
# cat ora_+ASM1.ora +ASM1.asm_diskgroups='DATA','FRA'#Manual Mount +ASM2.asm_diskgroups='DATA','FRA'#Manual Mount *.asm_diskstring='/dev/rdsk/emcpower*' *.asm_power_limit=1 *.diagnostic_dest='/mnt/crs/oracle' *.instance_type='asm' *.large_pool_size=12M *.remote_login_passwordfile='EXCLUSIVE'
2. Start up the ASM instance on the first node:
$ export $ORACLE_SID=[asm instance name] $ export $ORACLE_HOME=[full path of the asm home] $ sqlplus / as sysdba
sql> startup pfile=[the full pathname of ora_+ASM1.ora] The ASM instance shall start up properly
3. Check if the ASM diskgroups are mounted properly or not.
sql> select name,state from v$asm_diskgroup;
4. Create the spfile:
sql> create spfile='+DATA/../spfileasm.ora' from pfile='[the full path name of ora_+ASM1.ora] 5. In the GPnP profile we shall find that the spfile information set properly there.
# cat /u01/app/11.2.0/grid/gpnp/gps-rac2/profiles/peer/profile.xml
6. We need to stop and startup the CRS to make sure that the ASM and the CRS stack startup automatically without any issues.