My Oracle Support Banner

Spfile Stored in OCR is Not Used if One Exists in $ORACLE_HOME/dbs Location (Doc ID 1373622.1)

Last updated on FEBRUARY 08, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Oracle Database Cloud Schema 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
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

The purpose of this document is to show if spfile<SID>.ora exists in $ORACLE_HOME/dbs location, it could be used when using srvctl or crsctl commands to start the database/instances.

The following configuration show the spfile is stored in ASM diskgroup:

$ srvctl config database -d <RAC DB> -a
Database unique name: <RAC DB>
Database name: <RAC DB>
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/<RAC DB>/spfile<RAC DB>.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: <RAC DB>
Database instances: <RAC DB1>,<RAC DB2>
Disk Groups: DATA,FRA
Mount point paths:
Services: <RAC DB>
Type: RAC
Database is enabled
Database is administrator managed



When the database is started with the spfile stored in ASM/diskgroup, it should show:

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Fri Nov 4 08:37:41 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> show parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/<RAC DB>/spfile<RAC DB>.ora
SQL>



Now, if a spfile is created in $ORACLE_HOME/dbs directory:

$ ls -l $ORACLE_HOME/dbs/spfile*
-rw-r----- 1 oracle oinstall 4608 Sep 20 15:31 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfile<RAC DB>.ora


stop and restart the instance with srvctl command:

$ srvctl stop instance -d <RAC DB> -i <RAC DB1>
$ srvctl start instance -d <RAC DB> -i <RAC DB2>
$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Fri Nov 4 08:48:13 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> show parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/app/oracle/product/11.2.0
/dbhome_1/dbs/spfile<RAC DB>.ora
SQL>


Note: the spfile is pointed to $ORACLE_HOME/dbs, instead of ASM diskgroup

Possible error may return if another instance is started with a parameter set differently.

$ srvctl start instance -d <RAC DB> -i <RAC DB1>
PRCR-1013 : Failed to start resource ora.<RAC DB>.db
PRCR-1064 : Failed to start resource ora.<RAC DB>.db on node host01
CRS-5017: The resource action "ora.<RAC DB>.db start" encountered the following error:
ORA-01105: mount is incompatible with mounts by other instances
ORA-19808: recovery destination parameter mismatch


CRS-2674: Start of 'ora.<RAC DB>.db' on 'host01' failed



Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.