• 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 Clone a Pluggable Database from an RMAN Container Database Backup
  2. How to Install/Uninstall/Upgrade Oracle SQLTXPLAIN (SQLT) Tool
  3. Oracle GoldenGate: Extract Sample Parameter File
  4. What are the implications of rebuilding indexes in Oracle Database
  5. Beginners Guide to Monitoring SQL Statements with Real-Time SQL Monitoring in Oracle Database
  6. Rman Backups Failing with RMAN-20004
  7. How to check which options or features are used in the Oracle database
  8. What are Oracle Data Guard Protection Modes (redo transport rules) and how to configure them
  9. Oracle Database – How to Rename a Datafile with Special Characters Created by Mistake
  10. How to Audit Alter Tablespace in Oracle 12c database

You May Also Like

Primary Sidebar

Recent Posts

  • nixos-rebuild Command Examples in Linux
  • nixos-option: Command Examples in Linux
  • nixos-container : Command Examples in Linux
  • nitrogen Command Examples in Linux

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright