Unable to Create spfile ORA-15005

(Doc ID 1440742.1)

Last updated on MARCH 19, 2018

Applies to:

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


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%';

----------------------------------- ------------------------------
spfile.271.751552369 DATA

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


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