Create database SPFILE Under ASM
(Doc ID 413360.1)
Last updated on JULY 01, 2021
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 220.127.116.11 [Release 10.1 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 27-Feb-2011***
***Checked for relevance on 04-Jul-2014***
On 10.2.0.1 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';
Under ASM , the spileosmdr.ora is link to the wrong location under ASM
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?
IT'S EXPECTED BEHAVIOR
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