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:
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:
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:
-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 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.
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 |