ORA-12853: insufficient memory for PX buffers: current stringK, max needed stringK

Cause : Insuffciient SAG memor yfor PXb uffers

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

Reconfgiure sg ato inculde at elast (mxa - curernt) byets of additiona lmemory

update : 27-05-2017

ORA-12853 - insufficient memory for PX buffers: current stringK, max needed stringK
ORA-12853 - insufficient memory for PX buffers: current stringK, max needed stringK

  • ora-10914 : invalid TABLESPACE GROUP clause
  • ora-13861 : Statistics aggregation for client identifier string is already enabled
  • ora-24392 : no connection pool to associate server handle
  • ora-16621 : database name for ADD DATABASE must be unique
  • ora-25236 : buffer too small for user data
  • ora-00115 : connection refused; dispatcher connection table is full
  • ora-15093 : buffer only contains string bytes, I/O requested is string bytes
  • ora-30383 : specified dimension level does not exist in the attribute
  • ora-21710 : argument is expecting a valid memory address of an object
  • ora-12667 : Shared server: outbound transport protocol different from inbound
  • ora-23426 : deferred RPC queue has entries for string
  • ora-00338 : log string of thread string is more recent than control file
  • ora-31656 : cannot use TABLESPACE_EXPR filter with transportable mode
  • ora-39065 : unexpected master process exception in string
  • ora-00378 : buffer pools cannot be created as specified
  • ora-09364 : Windows 3.1 Two-Task driver unable to create hidden window
  • ora-36271 : (XSCGMDLAGG11) workspace object is not in the dimension list of valueset workspace object.
  • ora-00114 : missing value for system parameter SERVICE_NAMES
  • ora-00710 : new tablespace name is the same as the old tablespace name
  • ora-08467 : error converting Oracle number to string
  • ora-13129 : HHCODE column string not found
  • ora-14507 : partition corrupt. all rows do not fall within partition bounds
  • ora-13232 : failed to allocate memory during R-tree creation
  • ora-30055 : NULL snapshot expression not allowed here
  • ora-27300 : OS system dependent operation:string failed with status: string
  • ora-19288 : XP0017 - invalid number of arguments to function - string
  • ora-30376 : prevent sharing of a parsed query of an explain rewrite session
  • ora-19616 : output filename must be specified if database not mounted
  • ora-25436 : invalid table alias: string
  • ora-16412 : ONDEMAND archival requires active SQL apply operation
  • 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.