My Oracle Support Banner

ORA-01565 ORA-27041 ORA-01078 Failure in Processing System Parameters in RAC with ASM (Doc ID 577732.1)

Last updated on DECEMBER 10, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.2 and later
Oracle Database Cloud Schema 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

-- Problem Statement:
On 10.2.0.2.0 in Production:
When attempting to startup database
the following error occurs:

ERROR
ORA-01565: error in identifying file +'/dev/raw/+ASM-spfile.ora'
<HOSTNAME>:ora.<HOSTNAME>.ASM2.asm:ORA-27041: unable to open file
<HOSTNAME>:ora.<HOSTNAME>.ASM2.asm:Linux-x86_64 Error: 24: Too many open files
<HOSTNAME>:ora.<HOSTNAME>.ASM2.asm:Additional information: 2
<HOSTNAME>:ora.<HOSTNAME>.ASM2.asm:
<HOSTNAME>:ora.<HOSTNAME>.ASM2.asm:ORA-01078: failure in processing system +parameters

Changes

Added more memory to server then changed the mapper script to see new memory then rebooted server.

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
Changes
Cause
Solution

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