Why is an Oracle database not starting when SGA size is bigger than 200GB?

Solution Verified - Updated -

Issue

  • When trying to start Oracle database in case SGA memory segment is bigger than 200GB,it will reject to start
  • Unable to connect to database due to 'ORA-27123' error

Environment

  • Red Hat Enterprise Linux 5.7
  • Oracle 10.2 and later

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.