• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

How to start up the ASM instance when the spfile is misconstrued or lost

by admin

The Problem

CRS and the ASM instance can not start up because the spfile is misconstrued or lost.

– Starting ASM instance fails with error:

SQL> startup;
ORA-00099: warning: no parameter file specified for ASM instance
ORA-00304: requested INSTANCE_NUMBER is busy

– Starting up the CRS services fails with error

# crsctl start crs
CRS-4640: Oracle High Availability Services is already active
CRS-4000: Command Start failed, or completed with errors

– Checked the GPnP profile and found that it referred to an spfile which did not exist in the ASM (or shared storage). For example:

$ cat /u01/app/11.2.0/grid/gpnp/gps-rac2/profiles/peer/profile.xml

The Solution

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.

Filed Under: ASM, oracle

Some more articles you might also be interested in …

  1. How to Change default Oracle database listener port (1521)
  2. ORA-12547: TNS:lost Contact (Oracle 12c2)
  3. How to monitor Undo Tablespace Usage and the Free Space in Oracle Database
  4. Oracle Interview Questions – Flash Recovery Area
  5. Log/Trace files Generated during the EM Cloud Control OMS Startup
  6. Beginners Guide to RMAN compression for backups
  7. How to set udev rule for setting the disk permission on ASM disks when using multipath on CentOS/RHEL 6
  8. SQL*Plus Editing Commands
  9. Auto Space Management for Flashback Logs in the Fast Recovery Area – Oracle 19c New Feature
  10. Oracle Net New Features in Oracle Database 12c

You May Also Like

Primary Sidebar

Recent Posts

  • What are /dev/zero and /dev/null files in Linux
  • grpck command – Remove corrupt or duplicate entries in the /etc/group and /etc/gshadow files.
  • xxd command – Expressed in hexadecimal form
  • sesearch: command not found

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright