My Oracle Support Banner

Database Startup with SPFILE on ASM RAC Fails With Errors: ORA-01078 ORA-17510 (Doc ID 1646400.1)

Last updated on SEPTEMBER 25, 2023

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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.orcl.db
CRS-5017: The resource action "ora.orcl.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/racnode01/agent/crsd/oraagent_oracle/oraagent_oracle.log".

CRS-5017: The resource action "ora.orcl.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/racnode02/agent/crsd/oraagent_oracle/oraagent_oracle.log".

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

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

2014-04-10 18:23:47.488: [ora.orcl.db][3413497600]{1:16852:52235} [start] Container:start oracle home /app/oracle/product/11204
2014-04-10 18:23:47.488: [ora.orcl.db][3413497600]{1:16852:52235} [start] InstConnection::connectInt: server not attached
2014-04-10 18:23:47.500: [ora.orcl.db][3413497600]{1:16852:52235} [start] InstConnection:connectInt connected
2014-04-10 18:23:47.500: [ora.orcl.db][3413497600]{1:16852:52235} [start] InstAgent::startup
2014-04-10 18:23:47.598: [ora.orcl.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.orcl.db][3413497600]{1:16852:52235} [start] InstAgent::start: 1 errcode 1078
2014-04-10 18:23:47.598: [ora.orcl.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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.