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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content