Create database SPFILE Under ASM
Last updated on FEBRUARY 06, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 184.108.40.206 [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 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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms