标题: Database Startup with SPFILE on ASM RAC Fails With Errors: ORA-01078 ORA-17510 [打印本页] 作者: 郑全 时间: 2020-11-27 18:28 标题: 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...