ORA-09986: wrong number of bytes read from SGA definition file

Cause : Struct skgmsdef size differs from no. of bytes read from SGA file

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

Compare the two struct definitions and ensure that they are identical in size and structure.

update : 22-09-2017
ORA-09986

ORA-09986 - wrong number of bytes read from SGA definition file
ORA-09986 - wrong number of bytes read from SGA definition file

  • ora-28364 : invalid wallet operation
  • ora-27504 : IPC error creating OSD context
  • ora-07562 : sldext: extension must be 3 characters
  • ora-23304 : malformed deferred rpc at arg string of string in call string, in tid string
  • ora-06953 : Not enough virtual memory
  • ora-36274 : (XSCGMDLAGG05) The operator used in this equation needs a weight variable.
  • ora-15083 : failed to communicate with ASMB background process
  • ora-00229 : operation disallowed: already hold snapshot control file enqueue
  • ora-09856 : smpalo: vm_allocate error while allocating pga.
  • ora-27414 : Invalid BY value type
  • ora-00065 : initialization of FIXED_DATE failed
  • ora-15150 : instance lock mode 'string' conflicts with other ASM instance(s)
  • ora-09802 : Conversion of binary label to string failed.
  • ora-06265 : NETNTT: break protocol error
  • ora-39038 : Object path "string" is not supported for string jobs.
  • ora-07255 : spini: cannot set up signal handler.
  • ora-25202 : invalid value NULL, string should be non-NULL
  • ora-02739 : osncon: host alias is too long
  • ora-36667 : (XSDPART05) string is not a legal CONCAT partition.
  • ora-30122 : value 'string' for 'string' must be between 'number' and 'number'
  • ora-24076 : cannot perform operation string for NON_PERSISTENT queue string.string
  • ora-26723 : user "string" requires the role "string"
  • ora-02720 : osnfop: shmat failed
  • ora-22981 : must specify a table/view having system generated OID
  • ora-01138 : database must either be open in this instance or not at all
  • ora-13776 : User "string" has not been granted the "SELECT" privilege on the "SQL tuning set" DBA views.
  • ora-32838 : exceeded maximum number of properties
  • ora-13013 : the specified topology was not INTERIOR or BOUNDARY
  • ora-02258 : duplicate or conflicting NULL and/or NOT NULL specifications
  • ora-19334 : Invalid column specification for CREATE_DBURI operator
  • 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.