My Oracle Support Banner

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

Last updated on AUGUST 04, 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 FILE_ALIAS, DISKGROUP_NAME from v$asm_alias a, v$asm_diskgroup b
where a.group_number=b.group_number and like '%spfile%';

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

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.