SPFILE of a DB instance will be created within 'DB_UNKNOWN' directory on ASM storage (Doc ID 743073.1)

Last updated on SEPTEMBER 30, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.0 [Release 10.1 to 11.2]
Information in this document applies to any platform.

***Checked for relevance on 30-Sep-2013***

Symptoms

You create a SPFILE from a PFILE of a database instance and store the SPFILE on ASM storage.
After its creation the SPFILE got placed within a directory called DB_UNKNOWN.

Example:
SQL> create spfile='+ASMDATA' from pfile='$ORACLE_HOME/dbs/initTEST.ora';
File created.

SQL>exit;

ASMCMD> pwd
+ASMDATA/TEST

ASMCMD> ls -l
Type Redund Striped Time Sys Name
N spfiletest.ora =>+ASMDATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.393.668068961

The SPFILE of the database was created within the sub-directory DB_UNKNOWN instead in a sub-directory TEST like expected.

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