在ASM实例中更改spfile路径时遇到错误ORA-17502和ORA-15177，解决方案是仅指定磁盘组名进行`createspfile`操作，如`createspfile='+CRS' from pfile='/home/grid/tmp/pfile1.ora';`。使用`spget`和`spset`命令可以定位和设置ASM实例的spfile。
经测试，在ASM实例中，执行 createspfile from pfile;重新创建 spfile文件时，会报如下错误：
SQL> createspfile='+CRS/rac-cluster/ASMPARAMETERFILE/REGISTRY.253.858642645' frompfile='/home/grid/tmp/pfile1.ora';
createspfile='+CRS/rac-cluster/ASMPARAMETERFILE/REGISTRY.253.858642645' frompfile='/home/grid/tmp/pfile1.ora'
*
ERROR atline 1:
ORA-17502:ksfdcre:4 Failed to create file
+CRS/rac-cluster/ASMPARAMETERFILE/REGISTRY.253.858642645
ORA-15177:cannot operate on system aliases
SQL> create spfile frompfile='/home/grid/tmp/pfile1.ora';
create spfile frompfile='/home/grid/tmp/pfile1.ora'
*
ERROR atline 1:
ORA-17502:ksfdcre:4 Failed to create file
+CRS/rac-cluster/asmparameterfile/registry.253.923332571
ORA-15177:cannot operate on system aliases
进 asmcmd中执行 spget如下命令，发现spfile不见了：
ASMCMD[+CRS/rac-cluster/ASMPARAMETERFILE] > spget
ASMCMD[+CRS/rac-cluster/ASMPARAMETERFILE] > ls -l
ASMCMD-08002: entry'ASMPARAMETERFILE' does not exist in directory '+CRS/rac-cluster/'
原来，指定create spfile路径时，只给磁盘组名就可以了，如下：
SQL> createspfile='+CRS' from pfile='/home/grid/tmp/pfile1.ora';
File created.
ASMCMD[+CRS/rac-cluster/ASMPARAMETERFILE] > spget
+CRS/rac-cluster/asmparameterfile/registry.253.923332973
发现，自动生成并重新命名一个spfile文件了。
spget和spset命令是GPnP方式定位和设置ASM实例spfile文件的方法。具体用法详见《Oracle 11gR2用gpnpprofile存放ASM的spfile路径》
扫一扫
256
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
