ORA-01565: error in identifying file '+DATA/DB_NAME/spfileDB_NAME.ora'

ISSUE :- 
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/DB_NAME/spfileDB_NAME.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/DB_NAME/spfileDB_NAME.ora
ORA-27140: attach to post/wait facility failed
ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
ORA-27301: OS failure message: Operation not permitted
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = 501 (oinstall), current egid = 502 (dba)
SQL>
SQL>

Solution :- 

SQL> exit
Disconnected
[ora12c@Server2 ~]$
[ora12c@Server2 ~]$
[ora12c@Server2 ~]$ . ./.bash_profile_asm         //Set ASM Profile
[ora12c@Server2 ~]$
[ora12c@Server2 ~]$ asmcmd                        //Connect to ASM prompt
ASMCMD> ls                                        // Check where sp file is present
DATA/
FRA/
OCR_VOTING/

ASMCMD> cd DATA/

ASMCMD> ls
DB_NAME/

ASMCMD> cd DB_NAME/

ASMCMD> ls
CONTROLFILE/
DATAFILE/
ONLINELOG/
PARAMETERFILE/
PASSWORD/
TEMPFILE/

ASMCMD> cd PARAMETERFILE/
ASMCMD> ls
spfile.932.934567412

ASMCMD> pwd
+DATA/DB_NAME/PARAMETERFILE          //Location for current SP file

ASMCMD> cd ..                         


ASMCMD> pwd
+DATA/DB_NAME/            //Location where we have to create SP file
         

Create alias for spfile to location +DATA/DB_NAME/  as per error

ASMCMD> mkalias +DATA/DB_NAME/PARAMETERFILE/spfile.932.934567412  spfileDB_NAME.ora

ASMCMD> ls -l
Type  Redund  Striped  Time   Sys  Name
                               Y    ARCHIVELOG/
                               Y    CONTROLFILE/
                               Y    DATAFILE/
                               Y    ONLINELOG/
                               Y    PARAMETERFILE/
                               Y    TEMPFILE/
                               N    spfileDB_NAME.ora => +DATA/DB_NAME/PARAMETERFILE/spfile.932.934567412 

ASMCMD> exit
[ora12c@Server2 ~]$ which crsctl
/rdbms/app/12.1.0.2/grid/bin/crsctl
[ora12c@Server2 ~]$
[ora12c@Server2 ~]$

Stop the cluster :-

[ora12c@Server2 ~]$ sudo /rdbms/app/12.1.0.2/grid/bin/crsctl stop crs      
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'Server2'
CRS-2673: Attempting to stop 'ora.crsd' on 'Server2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'Server2'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'Server2'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'Server2'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'Server2'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'Server2' succeeded
CRS-2673: Attempting to stop 'ora.Server2.vip' on 'Server2'
CRS-2677: Stop of 'ora.FRA.dg' on 'Server2' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'Server2' succeeded
CRS-2673: Attempting to stop 'ora.OCR_VOTING.dg' on 'Server2'
CRS-2677: Stop of 'ora.OCR_VOTING.dg' on 'Server2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'Server2'
CRS-2677: Stop of 'ora.asm' on 'Server2' succeeded
CRS-2677: Stop of 'ora.Server2.vip' on 'Server2' succeeded
CRS-2672: Attempting to start 'ora.Server2.vip' on 'Server1'
CRS-2676: Start of 'ora.Server2.vip' on 'Server1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'Server2'
CRS-2677: Stop of 'ora.ons' on 'Server2' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'Server2'
CRS-2677: Stop of 'ora.net1.network' on 'Server2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'Server2' has completed
CRS-2677: Stop of 'ora.crsd' on 'Server2' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'Server2'
CRS-2673: Attempting to stop 'ora.evmd' on 'Server2'
CRS-2673: Attempting to stop 'ora.storage' on 'Server2'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'Server2'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'Server2'
CRS-2677: Stop of 'ora.storage' on 'Server2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'Server2'
CRS-2677: Stop of 'ora.ctssd' on 'Server2' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'Server2' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'Server2' succeeded
CRS-2677: Stop of 'ora.evmd' on 'Server2' succeeded
CRS-2677: Stop of 'ora.asm' on 'Server2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'Server2'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'Server2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'Server2'
CRS-2677: Stop of 'ora.cssd' on 'Server2' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'Server2'
CRS-2677: Stop of 'ora.gipcd' on 'Server2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'Server2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[ora12c@Server2 ~]$
[ora12c@Server2 ~]$
[ora12c@Server2 ~]$

Start the cluster :-

[ora12c@Server2 ~]$ sudo /rdbms/app/12.1.0.2/grid/bin/crsctl start crs
CRS-4123: Oracle High Availability Services has been started.


Thats it :)

No comments:

Post a Comment