Grid Infrastructure 12.1.0.2: ORA-01565: Unable To open Spfile

刘泽宇

现象：
Newly created database using dbca, seeing the following in database alert.log frequently:

Wed Nov 19 10:00:40 2014
ORA-01565: Unable to open Spfile +DATA/<dbname>/spfile<dbname>.ora.
Wed Nov 19 10:00:40 2014
ORA-01565: Unable to open Spfile +DATA/<dbname>/spfile<dbname>.ora.
Wed Nov 19 10:00:41 2014
The spfile doesn't exist, the spfile in the OCR for the database is correct:

$ srvctl config database -d <dbname>
Database unique name: <dbname>
Database name: <dbname>
Oracle home: <ORACLE_HOME>
Oracle user: <user>
Spfile: +DATA/<dbname>/PARAMETERFILE/spfile.279.861715841
SQL> show parameter spfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/EAIPPRD/PARAMETERFILE/spfile.279.861715841

ASMCMD [+DATA/EAIPPRD/PARAMETERFILE] > ls -l
Type Redund Striped Time Sys Name
PARAMETERFILE UNPROT COARSE NOV 20 07:00:00 Y spfile.279.861715841
The only reference to the incorrect spfile name is in <DB_HOME>/dbs/init<ORACLE_SID>.ora which isn't being used in 12.1.0.2:

$ cat init<sid>.ora
SPFILE='+DATA/<dbname>/spfile<dbname>.ora'


原因：
The issue was investigated in multiple bugs:

BUG 20133332 - FREQUENT ALERT.LOG MSG: ORA-01565: UNABLE TO OPEN SPFILE +DATA/EAIPPRD/SPFILEEAI
BUG 19064439 - ORA-01565: UNABLE TO OPEN SPFILE ON AN IDLE SYSTEM - FOR 1 SECOND  and its a duplicate of Bug 19951840
BUG 20025790 - EM CAUSES ORA-1565 TO BE GENERATED DUE TO DBCA ISSUE

The exact cause wasn't determined.

处理方法：
After applied 12.1.0.2 GI PSU2, the issue stopped.