Visit Counter

Wednesday, October 28, 2015

ORA-01565: error in identifying file '+DATA/orcl/spfileorcl.ora'



SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/orcl/spfileorcl.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora
ORA-15056: additional error message
ORA-17503: ksfdopn:DGOpenFile05 Failed to open file +DATA/orcl/spfileorcl.ora
ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora
ORA-15173: entry 'spfileorcl.ora' does not exist in directory 'orcl'





[oracle@ora11 bin]$ ./crsctl stat res -t -init

--------------------------------------------------------------------------------

Name Target State Server State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.DATA.dg

ONLINE OFFLINE ora11 STABLE

ora.LISTENER.lsnr

ONLINE ONLINE ora11 STABLE

ora.asm

ONLINE ONLINE ora11 Started,STABLE

ora.ons

OFFLINE OFFLINE ora11 STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

1 ONLINE ONLINE ora11 STABLE

ora.diskmon

1 OFFLINE OFFLINE STABLE

ora.evmd

1 ONLINE ONLINE ora11 STABLE

ora.oraafi.db

1 ONLINE OFFLINE STABLE

ora.orabig.db

1 ONLINE OFFLINE STABLE

ora.oradb.db

1 ONLINE OFFLINE STABLE

--------------------------------------------------------------------------------

[oracle@ora11 bin]$










Solution
----------

[oracle@ora11 bin]$ ./crsctl start resource -all

CRS-5702: Resource 'ora.LISTENER.lsnr' is already running on 'ora11'

CRS-5702: Resource 'ora.asm' is already running on 'ora11'

CRS-5702: Resource 'ora.cssd' is already running on 'ora11'

CRS-5702: Resource 'ora.evmd' is already running on 'ora11'

CRS-2501: Resource 'ora.ons' is disabled

CRS-2672: Attempting to start 'ora.DATA.dg' on 'ora11'

CRS-2672: Attempting to start 'ora.diskmon' on 'ora11'

CRS-2676: Start of 'ora.diskmon' on 'ora11' succeeded

CRS-2676: Start of 'ora.DATA.dg' on 'ora11' succeeded

CRS-2679: Attempting to clean 'ora.oraafi.db' on 'ora11'

CRS-2679: Attempting to clean 'ora.orabig.db' on 'ora11'

CRS-2679: Attempting to clean 'ora.oradb.db' on 'ora11'

CRS-2681: Clean of 'ora.oraafi.db' on 'ora11' succeeded

CRS-2672: Attempting to start 'ora.oraafi.db' on 'ora11'

CRS-2681: Clean of 'ora.orabig.db' on 'ora11' succeeded

CRS-2672: Attempting to start 'ora.orabig.db' on 'ora11'

CRS-2681: Clean of 'ora.oradb.db' on 'ora11' succeeded

CRS-2672: Attempting to start 'ora.oradb.db' on 'ora11'

CRS-5010: Update of configuration file "/ora/oracle/app/oracle/product/12.1.0/grid/srvm/admin/oratab.bak.ora11" failed: details at "(:CLSN00011:)" in "/ora/oracle/app/oracle/product/12.1.0/grid/log/ora11/agent/ohasd/oraagent_oracle/oraagent_oracle.log"

 

CRS-2676: Start of 'ora.oraafi.db' on 'ora11' succeeded

CRS-5702: Resource 'ora.oraafi.db' is already running on 'ora11'

CRS-2676: Start of 'ora.oradb.db' on 'ora11' succeeded

CRS-2676: Start of 'ora.orabig.db' on 'ora11' succeeded

CRS-5702: Resource 'ora.orabig.db' is already running on 'ora11'

CRS-4000: Command Start failed, or completed with errors.

[oracle@ora11 bin]$

[oracle@ora11 bin]$



[oracle@ora11 bin]$ ./sqlplus /nolog

SQL*Plus: Release 12.1.0.1.0 Production on Thu Oct 29 02:32:07 2015

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

SQL> conn / as sysdba

Connected.

SQL> exit



[oracle@ora11 bin]$ ./crsctl stat res -t -init

--------------------------------------------------------------------------------

Name Target State Server State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.DATA.dg

ONLINE ONLINE ora11 STABLE

ora.LISTENER.lsnr

ONLINE ONLINE ora11 STABLE

ora.asm

ONLINE ONLINE ora11 Started,STABLE

ora.ons

OFFLINE OFFLINE ora11 STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

1 ONLINE ONLINE ora11 STABLE

ora.diskmon

1 OFFLINE OFFLINE STABLE

ora.evmd

1 ONLINE ONLINE ora11 STABLE

ora.oraafi.db

1 ONLINE ONLINE ora11 Open,STABLE

ora.orabig.db

1 ONLINE ONLINE ora11 Open,STABLE

ora.oradb.db

1 ONLINE ONLINE ora11 Open,STABLE

--------------------------------------------------------------------------------

[oracle@ora11 bin]$







 

No comments:

Post a Comment