Shulou(Shulou.com)06/01 Report--

[fault handling] alarm log report "ORA-01565 Unable To open Spfile"

1.1 BLOG document structure map

1.2 Fault analysis and resolution process 1.2.1 introduction to the fault environment

Project

Source db

Db Typ

RAC

Db version

12.1.0.2.0

Db storage

ASM

OS version and kernel version

SuSE Linux Enterprise Server (SLES 11) 64 bit

1.2.2 failure phenomena and error messages the customer's 12.1.0.2 RAC library alerts the log of ORA-01565: Unable To open Spfile error, one of which is at more than 3: 00 a.m. every day, and the other at more than 1: 00 a.m.

1.2.3 the failure analysis and resolution process is queried according to MOS How to troubleshoot ORA-01565 being reported in alert log (document ID 1950208.1) due to the inconsistency between the query results of $ORACLE_HOME/dbs/init$ORACLE_SID and the configuration in OCR (srvctl config db-d racdb1).

Solution: just change the configuration of the two to be consistent.

You can set the trace event to track the problem, generate a trace, and then turn off the trace event:

Alter system set events' 1565 trace name errorstack level 10'

Alter system set events' 1565 trace name context off'

In addition, in RAC of 12.1.0.2, the file "/ dbs/init.ora" is no longer used:

The only reference to the incorrect spfile name is in / dbs/init.ora which isn't being used in 12.1.0.2:

$cat initeaipprd1.ora

SPFILE='+DATA/eaipprd/spfileeaipprd.ora'

1.3 MOS1.3.1 Grid Infrastructure 12.1.0.2 ORA-01565 Unable To open Spfile (document ID 1970979.1)

In this Document

Symptoms

Cause

Solution

References

APPLIES TO:

Oracle Database-Enterprise Edition-Version 12.1.0.2 and later

Information in this document applies to any platform.

SYMPTOMS

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/eaipprd/spfileeaipprd.ora.

Wed Nov 19 10:00:40 2014

ORA-01565: Unable to open Spfile + DATA/eaipprd/spfileeaipprd.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 eaipprd

Database unique name: eaipprd

Database name: eaipprd

Oracle home: / oracle/oracle/product/12.1.0.2_eaip

Oracle user: oracle

Spfile: + DATA/EAIPPRD/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 / dbs/init.ora which isn't being used in 12.1.0.2:

$cat initeaipprd1.ora

SPFILE='+DATA/eaipprd/spfileeaipprd.ora'

CAUSE

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

BUG 20025790-EM CAUSES ORA-1565 TO BE GENERATED DUE TO DBCA ISSUE

The exact cause wasn't determined.

SOLUTION

After applied 12.1.0.2 GI PSU2, the issue stopped.

1.3.2 How to troubleshoot ORA-01565 being reported in alert log (document ID 1950208.1)

In this Document

Goal

Solution

References

APPLIES TO:

Oracle Database-Enterprise Edition-Version 12.1.0.2 and later

Information in this document applies to any platform.

GOAL

Troubleshooting "ORA-01565: Unable to open Spfile"

SOLUTION

When "ORA-01565: Unable to open Spfile" is being reported in the instance alert log, then some process is trying to access the spfile but referring to the incorrect location

Database Instance alert log reports the following errors

Wed Nov 19 19:26:44 2014

ORA-01565: Unable to open Spfile + DATA/racdb1/spfileracdb1.ora.

Wed Nov 19 19:26:44 2014

ORA-01565: Unable to open Spfile + DATA/racdb1/spfileracdb1.ora.

Wed Nov 19 19:26:44 2014

ORA-01565: Unable to open Spfile + DATA/racdb1/spfileracdb1.ora.

Wed Nov 19 19:26:44 2014

ORA-01565: Unable to open Spfile + DATA/racdb1/spfileracdb1.ora.

Wed Nov 19 19:26:44 2014

ORA-01565: Unable to open Spfile + DATA/racdb1/spfileracdb1.ora.

In a situation where the error is not generating any trace files we need to set the following event at the database level

Alter system set events' 1565 trace name errorstack level 10'

Once the above event is set we can see messages as follows in the alert log when the issue occurs again

From alert log

Mon Dec 01 19:26:44 2014

ORA-01565: Unable to open Spfile + DATA/racdb1/spfileracdb1.ora.

Mon Dec 01 19:26:44 2014

Errors in file / u01/app/oracle/diag/rdbms/racdb1/racdb1/trace/racdb1_ora_3106.trc:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.