Database Startup with SPFILE on ASM RAC Fails With Errors: ORA-01078 ORA-17510

郑全

Database Startup with SPFILE on ASM RAC Fails With Errors: ORA-01078 ORA-17510 (Doc ID 1646400.1)  
In this Document
Symptoms
Cause
Solution
References
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
This is due to Bug 16870214 : DB STARTUP FAILS WITH ORA-17510 IF SPFILE IS IN 4K SECTOR SIZE DISKGROUP
SOLUTION
Download and Apply the patch for your respective version. And this issue is fixed in future release 12.2 version.
Workaround: The work-around for this bug is to use spfile in 512 bytes sector_size diskgroup.
REFERENCES
NOTE:16870214.8 - Bug 16870214 - DB startup fails with ORA-17510 if spfile is in 4k sector size diskgroup

  
Was this document helpful?

Yes
No
     
  
Document Details

Email link to this documentOpen document in new windowPrintable Page

Type:
Status:
Last Major Update:
Last Update:
PROBLEM
PUBLISHED
Dec 25, 2019
Jan 25, 2020

  
Related Products


Oracle Database Cloud Schema Service
Oracle Database Exadata Express Cloud Service
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine)
Oracle Cloud Infrastructure - Database Service
Oracle Database Backup Service
Show More
     
  
Information Centers

   
Oracle Catalog: Service Request Data Collections (SRDCs) for all Products and Services [51.2]
Oracle Catalog: Information Centers for All Products and Services [50.2]
Platform as a Service (PaaS) and Oracle Cloud Infrastructure (OCI) Information Center [2048297.2]
Index of Oracle Database Information Centers [1568043.2]
Information Center: Overview Database Server/Client Installation and Upgrade/Migration [1351022.2]
Show More
     
  
Document References

   
Bug 16870214 - DB startup fails with ORA-17510 if spfile is in 4k sector size diskgroup [16870214.8]
     
  
Recently Viewed

Database Startup with SPFILE on ASM RAC Fails With Errors: ORA-01078 ORA-17510 [1646400.1]
ORA-01078 When Running DBCA [2560474.1]
Using 4k Redo Logs on Flash, 4k-Disk and SSD-based Storage [1681266.1]
Bug 17309268 - RFS Fails with ORA-600 [kfk_verify_io9] [17309268.8]
4K sector sized diskgroup not listed on v$asm_diskgroup [2086746.1]
Show More
     
Didn't find what you are looking for?Ask in Community...

郑全

解决办法，就是把spfile放在本地磁盘上