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 : 24-06-2017
ORA-09795

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

  • ora-28101 : policy already exists
  • ora-09292 : sksabln: unable to build archive file name
  • ora-16260 : Waiting to replace partial or corrupt logfile (thread# string, sequence# string)
  • ora-12210 : TNS:error in finding Navigator data
  • ora-22309 : attribute with name "string" already exists
  • ora-02170 : FREELIST GROUPS storage option not allowed
  • ora-25271 : queue table not found for the given queue
  • ora-16625 : cannot reach the database
  • ora-23515 : materialized views and/or their indices exist in the tablespace
  • ora-09870 : spini: failure initializing maximum number of open files.
  • ora-30767 : OID type mismatch
  • ora-39141 : dump file "string" is a duplicate of dump file "string"
  • ora-02426 : privilege grant failed
  • ora-24780 : cannot recover a transaction while in an existing transaction
  • ora-10578 : Can not allow corruption for managed standby database recovery
  • ora-38405 : quotes not allowed in the attribute set name
  • ora-06775 : TLI Driver: error reading break mode
  • ora-31468 : cannot process DDL change record
  • ora-29905 : method string does not exist in type string.string
  • ora-12725 : unmatched parentheses in regular expression
  • ora-15079 : ASM file is closed
  • ora-13043 : failed to read metadata from the _SDOLAYER table
  • ora-09779 : snyGetPort: failure to allocate a port.
  • ora-36688 : (NTEXTCNV00) Error during conversion from TEXT to NTEXT.
  • ora-36271 : (XSCGMDLAGG11) workspace object is not in the dimension list of valueset workspace object.
  • ora-06262 : NETNTT: nfconn() failed
  • ora-07514 : scgcan: $deq unexpected return while canceling lock
  • ora-06137 : NETTCP: error during connection handshake
  • ora-01631 : max # extents (string) reached in table string.string
  • ora-28345 : cannot downgrade because there exists encrypted column
  • 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.