This content has been marked as final. Show 7 replies
Its show you ASM instance not using the spfile. its using pfile. please find out using unix find command and then, create new spfile from pfile and start you instance with that spfile.
ASM instance can start without any parameter file. To create spfile, use:
SQL> create spfile from memory;
This will update OCR (or Grid profile).
But How to change location of SPFILE of ASM instance in 11gR2 ?
Now : asmcmd spget
But OCR DATA asm dik group have been deleted and created new : OCR_DATA .
How to update spfile location to new disk Group +OCR_DATA ?
Edited by: user11977218 on May 3, 2013 7:41 AM
I think your response is not correct. The ASM instance will require a parameter file, just like any other Oracle instance. As of 11gR2, the ASM spfile is stored automatically in the first disk group created during the Grid Infrastructure installation.
The trick is that ASM can read the spfile stored on ASM disks through the css cluster daemon and reading the ASM device header. People here in the forum and on the Internet have written good and detailed information about this, for instance:
Where is my Oracle ASM Instance spfile
I think your response is not correct. The ASM instance will require a parameter file, just like any other Oracle instance.ASM can start with dummy file as RMAN. You can delete all parameter files for ASM and see.
But How to change location of SPFILE of ASM instance in 11gR2 ?You can use ASMCMD spmove.
Ok , according to the documentation:
A PFILE or SPFILE is required if your configuration uses non-default initialization parameters for the Oracle ASM instance.