ORA-01565: ERROR IN IDENTIFYING FILE – ORA-01031: insufficient privileges startup

How to fix Oracle

The solution for Oracle Database insufficient privileges generic error is as follows.

[grid@testdb1 ~]$ srvctl start asm;

[grid@testdb1 ~]$ crsctl stat res -t

SQL> startup


ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file ‘+DATA/ORCL/PARAMETERFILE/spfileORCL.ora’
ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL/PARAMETERFILE/spfileORCL.ora
ORA-15056: additional error message
ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL/PARAMETERFILE/spfileORCL.ora
ORA-15001: diskgroup “DATA” does not exist or is not mounted ORA-06512: at line 4

[oracle@dbserver ~]$ asmcmd


ASMCMD> lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disksles Name


QUIESCING NORMAL N 512 4096 1048576 16588800 13289794 307200 6491297 0 N DATA/
QUIESCING NORMAL N 512 4096 1048576 614400 614 102400 -50893 0 N FRA/
QUIESCING NORMAL N 512 4096 1048576 6011 5388 2048 730 0 Y GRID/

[oracle@dbserver ~]$ sqlplus / as sysasm


SQL*Plus: Release 12.1.0.2.0 Production on Tue Aug 14 12:06:13 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production With the Real Application Clusters and Automatic Storage Management options

SQL> shutdown abort


ASM instance shutdown


SQL> startup


ASM instance started Total System Global Area 2147483648 bytes
Fixed Size 2926472 bytes
Variable Size 2111002744 bytes ASM
Cache 33554432 bytes ASM diskgroups mounted ASM diskgroups volume enabled

Comments