Create database SPFILE Under ASM

(Doc ID 413360.1)

Last updated on FEBRUARY 06, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 27-Feb-2011***
***Checked for relevance on 04-Jul-2014***


On in Production:

-- Suppose that the database instance name is "osmdr"  

-- In the database instance

When trying to create a new spfile from a pfile under sqlplus

SQL> create SPFILE='+DATA/osmdr/spfileosmdr.ora' from pfile='/home/oracle/osmdr.init';
File created.


SQL>create SPFILE='+DATA/osmdr/spfileosmdr.ora' from PFILE='/home/oracle/osmdr.init';   File created

Under ASM , the spileosmdr.ora is link to the wrong location under ASM

ASMCMD> ls -alr
Type Redund Striped Time Sys Name
N spfileosmdr.ora =>

Q. Why it will create +DATA/DB_UNKNOWN instead of +DATA/osmdr ?

The same question can be like that

Q. Why does the spfile get created in the directory DB_UNKNOWN?



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