My Oracle Support Banner

Resolving ORA-27123 Error (Doc ID 115753.1)

Last updated on NOVEMBER 21, 2023

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 7.0.16.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Generic UNIX

Purpose

 

You are trying to start your database and are getting one of the following errors:

   ORA-27123: Unable to attach a shared memory segment
      Error:   ORA-27123
      Text:    unable to attach to shared memory segment
      Cause:   shmat() call failed 
      Action:  check permissions on segment, contact Oracle support

This error may be accompanied by one of the following:   

   A) SVR4 error 12: not enough space
   B) SVR4 error 22: Invalid argument (you are trying to increase SGA and SHMMAX is large enough)
   C) SVR4 error 22: Invalid argument 
   D) SVR4 error 22: Invalid argument 
   E) UNIX error 13 (Permission Denied)
   F) SVR4 error 24 - too many open files.

Scope

 

Details

To view full details, 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 a vibrant support community of peers and Oracle experts.