2 Replies Latest reply: Feb 11, 2010 10:46 PM by Surachart Opun RSS

    ASM init.ora

    728256
      Hi,

      Can we create SPFILE for ASM instance. I am sure it has init+ASM.ora. But I am not sure if this can create SPFILE. If so, how can we do this and where can we put this.

      I got this doubt becuase, while we start a RAC database. First we start the ASM instacne. Does this mean that we are reading 2 different files on both the instances. Or do we need to put seperate shared storage for ASM init.ora file .
        • 1. Re: ASM init.ora
          Cerreia
          Hi Rakesh ,

          Can we create SPFILE for ASM instance.
          Yes, sure You can do that. For example, I'm using a clustered ASM using one spfile for both instances and each instance has its init files (local under $ASM_HOME/dbs) and it is pointing to a common spfile.
          I am sure it has init+ASM.ora. But I am not sure if this can create SPFILE. If so, how can we do this and where can we put this.
          Well, depends on Your version. For 10.2 and 11.1, You have to put the spfile under a raw device or a cluster file system. But for 11.2 You can put it under an ASM disk group.

          Take a look in this part of the documentation:

          10.2 Version)
          +"For ASM installations in clustered environments, server parameter files (SPFILEs) are not used unless there is a shared ASM Oracle home. Without a shared ASM Oracle home, each ASM instance gets its own text initialization parameter file (PFILE)."+

          PS: Anyway, I had put a spfile under a raw device (shared by both nodes) and each ASM instance has its init.ora pointo to this raw device.

          11.2 Version)
          "You can use an SPFILE or a text-based initialization parameter file (PFILE) as the Oracle ASM instance parameter file. If you use an SPFILE in a clustered Oracle ASM environment, then you must place the SPFILE in a disk group, a shared raw device, or on a cluster file system. Oracle recommends that the Oracle ASM SPFILE is placed in a disk group. You cannot use a new alias created on an existing Oracle ASM SPFILE to start the Oracle ASM instance"

          PS: In this version You have the option of put the spfile under a ASM disk group too.


          Hope it helps,
          Cerreia
          • 2. Re: ASM init.ora
            Surachart Opun
            Can we create SPFILE for ASM instance. I am sure it has init+ASM.ora. But I am not sure if this can create SPFILE. If so, how can we do this and where can we put this.
            We can create spfile from pfile:
            http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_6016.htm#SQLRF01315

            Example:
            export ORACLE_SID=+ASM1
            sqlplus / as sysdba
            or
            sqlplus / as sysasm
            SQL>create spfile='/Share/spfile+ASM.ora' from pfile='/oracle/dbs/init+ASM1.ora'

            I got this doubt becuase, while we start a RAC database. First we start the ASM instacne. Does this mean that we are reading 2 different files on both the instances. Or do we need to put seperate shared storage for ASM init.ora file .
            How did you start ASM on RAC?

            If you start it AUTO... please check

            node01:
            sqlplus / as sysdba
            or
            sqlplus / as sysasm
            SQL> show parameter spfile;

            You should use spfile file and share on storage (both nodes) ### pfile can not share both node...