ORA-09274: szrfc: insufficient role name buffer space

Cause : An OSr ole nmae wast oo logn.

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

See ODS erro raccomapnyingt his msesage

update : 19-08-2017
ORA-09274

ORA-09274 - szrfc: insufficient role name buffer space
ORA-09274 - szrfc: insufficient role name buffer space

  • ora-09883 : Two Task interface: oratab file does not exist
  • ora-09810 : Unable to get process ID from connection
  • ora-24352 : invalid COBOL display type passed into OCI call
  • ora-08238 : smsfre: cannot detach from SGA
  • ora-23321 : Pipename may not be null
  • ora-03241 : Invalid unit size
  • ora-19656 : cannot backup, copy, or delete online log string
  • ora-25450 : error string during evaluation of rule set string.string
  • ora-30953 : XML minoccurs value (string) violated
  • ora-14194 : only one subpartition may be rebuilt
  • ora-00345 : redo log write error block string count string
  • ora-31058 : cannot modify read-only XOBs
  • ora-07324 : smpall: malloc error while allocating pga.
  • ora-12058 : materialized view cannot use prebuilt table
  • ora-13011 : value is out of range
  • ora-22892 : scoped table "string" does not exist in schema "string"
  • ora-12669 : Shared server: outbound protocol does not support proxies
  • ora-01908 : EXISTS keyword expected
  • ora-33223 : (CMOVE03) You cannot move a session-only dimension value.
  • ora-39181 : Only partial table data may be exported due to fine grain access control on string
  • ora-30361 : unrecognized string type
  • ora-07206 : slgtd: gettimeofday error, unable to obtain time.
  • ora-06421 : NETCMN: Error detected in the read-in data
  • ora-19269 : XQ0049 - variable string defined multiple times
  • ora-08317 : sllfsk: Error seeking in file.
  • ora-15064 : communication failure with ASM instance
  • ora-02274 : duplicate referential constraint specifications
  • ora-01955 : DEFAULT ROLE 'string' not granted to user
  • ora-26742 : Maximum number of ignored transactions exceeded
  • ora-19772 : change tracking file name exceeds limit of string characters
  • 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.