Unable to Create spfile ORA-15005 (Doc ID 1440742.1)

Last updated on MARCH 27, 2012

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms


Unable to create spfile for database instance in ASM diskgroup as it failed with below:


SQL> create spfile='+DATA/PROD/spfilePROD.ora' from pfile='/u01/app/oracle/product/dbhome_1/11.2.0/dbs/initPROD.ora';
create spfile='+DATA/PROD/spfilePROD.ora' from pfile='/u01/app/oracle/product/dbhome_1/11.2.0/dbs/initPROD.ora'
*
ERROR at line 1:
ORA-17502: ksfdcre:4 Failed to create file +DATA/PROD/spfilePROD.ora
ORA-15005: name "PROD/spfilePROD.ora" is already used by an existing alias

But no alias file named spfilePROD.ora is present as confirmed with below query


SQL> col file_alias format a35
select a.name FILE_ALIAS, b.name DISKGROUP_NAME from v$asm_alias a, v$asm_diskgroup b
where a.group_number=b.group_number and a.name like '%spfile%';

FILE_ALIAS DISKGROUP_NAME
----------------------------------- ------------------------------
spfile.271.751552369 DATA


->asmcmd
ASMCMD> ls
DATA1/
FRA1/
ASMCMD> rmalias +DATA/PROD/spfilePROD.ora
ASMCMD-08002: entry 'spfilePROD.ora' does not exist in directory '+DATA/PROD/'


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms