最近在做ORACLE 11.2.0.4 rac for rhel6.9 到ORACLE 19.11.1 rac for rhel7.8的升级测试,过程中需要将ORACLE 11.2.0.3 rac for rhel6.8的数据库试用rman恢复到ORACLE 11.2.0.4 rac for rhel6.9集群中,在做create spfile的过程中遭遇报错:
SQL> Create spfile='+datadg/orcl/spfileorcl.ora' from pfile ='/tmp/orcl.ora';
Create spfile='+datadg/orcl/spfileorcl.ora' from pfile ='/tmp/orcl.ora'
*
ERROR at line 1:
ORA-17502: ksfdcre:4 Failed to create file +datadg/orcl/spfileorcl.ora
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
SQL>
看到这种报错,第一直觉看了下裸设备的权限,是按照oracle官方设置的:
[root@rl69url78n1 ~]# ls -l /dev/raw/*
crw-rw---- 1 grid asmadmin 162, 1 Aug 19 07:32 /dev/raw/raw1
crw-rw---- 1 grid asmadmin 162, 2 Aug 19 06:36 /dev/raw/raw2
crw-rw---- 1 grid asmadmin 162, 3 Aug 19 06:36 /dev/raw/raw3
crw-rw---- 1 grid asmadmin 162, 0 Aug 18 20:44 /dev/raw/rawctl
[root@rl69url78n1 ~]#
再看集群状态都是正常的,grid查看磁盘组正常:
[root@rl69url78n1 ~]# /u01/app/11.2.0/grid/bin/crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
----------