ORA-01565: Unable to Open Spfile for ASM Instance

刘泽宇

现象：
The ASM instance is unable to open the spfile, resulting in the error ORA-01565. The error message indicates that the spfile located at ?=/dbs/spfile@.ora is unavailable. Diagnostic outputs from ASMCMD show that the spfile<dbname>.ora is expected to be located at +DATA/ASM/ASMPARAMETERFILE/registry.253.1234525743, but it does not exist.


原因：
The root cause of the issue is that the spfile set at the ASM layer is not available in the diskgroup. Further investigation using ASMCMD commands reveals that the ASMPARAMETERFILE directory does not exist in the +DATA/ASM/ directory, which confirms that the spfile is missing.


ASMCMD> spget
+DATA/ASM/ASMPARAMETERFILE/registry.253.1234525743


ASMCMD> ls '+DATA/ASM/ASMPARAMETERFILE/registry.253.1234525743'
ASMCMD-8002: entry 'ASMPARAMETERFILE' does not exist in directory '+DATA/ASM/'


处理方法：
To resolve this issue, you will need to create a new spfile and set it with the ASM resource using asmcmd command. Here are the step-by-step instructions:

1.Create a pfile with the necessary parameters.
2.Use the pfile to create a new spfile.
CREATE SPFILE='<spfile location>' FROM PFILE='<pfile location>';
3.Set the new SPFILE with the ASM resource using asmcmd command.
If you do not have the parameters needed for the spfile, you can retrieve them from the alert log.
After creating and setting the new spfile, verify that it exists in the expected location and that it can be accessed by the ASM instance.
Use ASMCMD commands to confirm that the new spfile has been successfully created and set:

·spget command to verify that a valid path for an existing parameter file has been provided
·ls command on '+DATA' or relevant directories where your files reside
·set the new SPFILE with the ASM resource using "asmcmd spset" command.
ASMCMD> spset +DATA/asm/asmparameterfile/asmspfile.ora