ORA-09795: szrbuild: malloc of role structure failed.

Cause : The allocation of memory for an internal structure used to hold a role descriptor failed.

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

Check the UNIX error number for a possible operating system failure.

update : 30-04-2017

ORA-09795 - szrbuild: malloc of role structure failed.
ORA-09795 - szrbuild: malloc of role structure failed.

  • ora-01153 : an incompatible media recovery is active
  • ora-13031 : Invalid Gtype in the SDO_GEOMETRY object for point object
  • ora-36846 : (XSLMGEN16) AW name is greater than 30 bytes
  • ora-27031 : mirror resilvering functions not supported
  • ora-10263 : Don't free empty PGA heap extents
  • ora-19609 : %s is from different backup set: stamp string count string
  • ora-26021 : index string.string partition string loaded successfully with string keys
  • ora-00295 : datafile/tempfile number string is invalid, must be between 1 and string
  • ora-23431 : wrong state: string
  • ora-10580 : Can not modify datafile header during test recovery
  • ora-16702 : generic resource guard warning
  • ora-32017 : failure in updating SPFILE
  • ora-40215 : model string is incompatible with current operation
  • ora-32809 : foreign queue string is already registered
  • ora-01422 : exact fetch returns more than requested number of rows
  • ora-16140 : standby online logs have not been recovered
  • ora-01266 : Unable to create unique file name
  • ora-03263 : cannot drop the first file of tablespace string
  • ora-06572 : Function string has out arguments
  • ora-36290 : (EIFMAKEF14) You cannot export object workspace object, because EIFVERSION is set to number. That version does not support dimensions of type NUMBER.
  • ora-39113 : Unable to determine database version
  • ora-29344 : Owner validation failed - failed to match owner 'string'
  • ora-12449 : Labels specified for user must be of type USER
  • ora-01175 : data dictionary has more than the string files allowed by the instance
  • ora-06010 : NETASY: dialogue file too long
  • ora-12473 : The procedure is disabled when Label Security is used with OID.
  • ora-19640 : datafile checkpoint is SCN string time string
  • ora-12925 : tablespace string is not in force logging mode
  • ora-07622 : smscre: $CREATE failure
  • ora-13787 : missing SQL profile for statement object "string" for tuning task "string"
  • 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.