ORA-16527: unable to allocate SGA heap

Cause : The Dat aGuard borker wasu nable t oallocat ea heap iwthin th eSGA.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Increas eSGA memroy.

update : 29-05-2017

ORA-16527 - unable to allocate SGA heap
ORA-16527 - unable to allocate SGA heap

  • ora-32844 : exceeded maximum number of string values
  • ora-30932 : Reference node 'string' not contained in specified parent node 'string'
  • ora-01101 : database being created currently mounted by some other instance
  • ora-06571 : Function string does not guarantee not to update database
  • ora-19594 : control file already included as string
  • ora-07284 : sksaprd: volume size specification not terminated properly.
  • ora-00322 : log string of thread string is not current copy
  • ora-21780 : Maximum number of object durations exceeded.
  • ora-01879 : the hh25 field must be between 0 and 24
  • ora-13158 : Oracle object string does not exist
  • ora-01238 : cannot shrink datafile string
  • ora-26035 : Error attempting to encrypt or decrypt column
  • ora-01574 : maximum number of concurrent transactions exceeded
  • ora-16953 : Type of SQL statement not supported.
  • ora-23310 : object group "string"."string" is not quiesced
  • ora-00165 : migratable distributed autonomous transaction with remote operation is not allowed
  • ora-23600 : cannot create PROPAGATION, string already exists
  • ora-08176 : consistent read failure; rollback data not available
  • ora-12011 : execution of string jobs failed
  • ora-31620 : file or device "string" cannot be specified for string operation
  • ora-07596 : sptpa: $GETJPIW failure
  • ora-14042 : partition bound may not be specified for a partition being moved, modified or rebuilt
  • ora-30013 : undo tablespace 'string' is currently in use
  • ora-31064 : Cannot instantiate abstract element or property [string]
  • ora-25005 : cannot CREATE INSTEAD OF trigger on a read-only view
  • ora-13365 : layer SRID does not match geometry SRID
  • ora-08308 : sllfop: Cannot open file
  • ora-16950 : Remote mapped cursors are not supported by this feature.
  • ora-04007 : MINVALUE cannot be made to exceed the current value
  • ora-37040 : (XSACQUIRE_DEP_LOCKED) Composite, concat, dimension map, or internal partition workspace object is locked by another user.
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.