DB startup with spfile on ASM RAC failed with errors ORA-01078 ORA-17510 (Doc ID 1646400.1)

Last updated on FEBRUARY 21, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

 Database startup using the spfile created on ASM failed and spfile creation from pfile is successful. And pfile and spfile created on local file system is successful to start the database.

- startup pfile=/u01/app/oracle/product/11.2.0.3/dbhome_1/dbs/inittest2_1.ora  
The database starts up successfully

- create spfile='+IBM1_DATA/TEST2/PARAMETERFILE/spfileTEST2.ora' from
pfile='/u01/app/oracle/product/11.2.0.3/dbhome_1/dbs/inittest2_1.ora'
Created the spfile from working pfile

- Verifed spfile in ASM:
 
@ ASMCMD [+IBM1_DATA/TEST2/PARAMETERFILE] > pwd
+IBM1_DATA/TEST2/PARAMETERFILE
ASMCMD [+IBM1_DATA/TEST2/PARAMETERFILE] > ls -l
Type           Redund  Striped  Time             Sys  Name
PARAMETERFILE  UNPROT  COARSE   JUN 20 14:00:00  Y    spfile.320.818596011
PARAMETERFILE  UNPROT  COARSE   JUN 27 17:00:00  Y    spfile.356.819206379
PARAMETERFILE  UNPROT  COARSE   JUN 27 17:00:00  Y    spfile.357.819221223
                                                N    spfileTEST2.ora =>

 But startup failed with below errors.

PRCR-1079 : Failed to start resource ora.odsprod.db
CRS-5017: The resource action "ora.odsprod.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-17510: Attempt to do i/o beyond file size
. For details refer to "(:CLSN00107:)" in "/app/1120/grid/log/lusporac01/agent/crsd/oraagent_oracle/oraagent_oracle.log".

CRS-5017: The resource action "ora.odsprod.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-17510: Attempt to do i/o beyond file size
. For details refer to "(:CLSN00107:)" in "/app/1120/grid/log/lusporac02/agent/crsd/oraagent_oracle/oraagent_oracle.log".

CRS-2674: Start of 'ora.odsprod.db' on 'lusporac01' failed
CRS-2674: Start of 'ora.odsprod.db' on 'lusporac02' failed
CRS-2632: There are no more servers to try to place resource 'ora.odsprod.db' on that would satisfy its placement policy

 The /app/1120/grid/log/lusporac01/agent/crsd/oraagent_oracle/oraagent_oracle.log log shows as below:

2014-04-10 18:23:47.488: [ora.odsprod.db][3413497600]{1:16852:52235} [start] Container:start oracle home /app/oracle/product/11204
2014-04-10 18:23:47.488: [ora.odsprod.db][3413497600]{1:16852:52235} [start] InstConnection::connectInt: server not attached
2014-04-10 18:23:47.500: [ora.odsprod.db][3413497600]{1:16852:52235} [start] InstConnection:connectInt connected
2014-04-10 18:23:47.500: [ora.odsprod.db][3413497600]{1:16852:52235} [start] InstAgent::startup
2014-04-10 18:23:47.598: [ora.odsprod.db][3413497600]{1:16852:52235} [start] ORA-01078: failure in processing system parameters
ORA-17510: Attempt to do i/o beyond file size

2014-04-10 18:23:47.598: [ora.odsprod.db][3413497600]{1:16852:52235} [start] InstAgent::start: 1 errcode 1078
2014-04-10 18:23:47.598: [ora.odsprod.db][3413497600]{1:16852:52235} [start] InstAgent::start: untrapped error

 ASM instance startup also fails with below error if the ASM spfile/pfile is there in 4K sector size diskgroup

SQL> startup
ORA-01565: error in identifying file '+dg01/test.ora'
ORA-17503: ksfdopn:2 Failed to open file +dg01/test.ora
ORA-15077: could not locate ASM instance serving a required diskgroup

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms