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