Create database SPFILE Under ASM
(Doc ID 413360.1)
Last updated on MAY 22, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.4 [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.
*** ***
Symptoms
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';
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 =>
+DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.272.613162051
ASMCMD>
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
Cause
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
Symptoms |
Cause |
Solution |
TESTCASE |
References |