ORA-13837: invalid HASH_VALUE

Cause : An invalid HASH_VALUE was passed to a create SQL profile operation

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

Verify the HASH_VALUE.

update : 20-08-2017

ORA-13837 - invalid HASH_VALUE
ORA-13837 - invalid HASH_VALUE

  • ora-16501 : the Data Guard broker operation failed
  • ora-16569 : Data Guard configuration is not enabled
  • ora-12609 : TNS: Receive timeout occurred
  • ora-06141 : NETTCP: no privilege for user
  • ora-19526 : only one location allowed for parameter string
  • ora-26055 : Invalid buffer specified for direct path unload
  • ora-39504 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-30194 : reserved for future use
  • ora-23449 : missing user name
  • ora-12205 : TNS:could not get failed addresses
  • ora-01255 : cannot shutdown - file string in recovery manager backup
  • ora-12719 : operation requires database is in RESTRICTED mode
  • ora-25448 : rule string.string has errors
  • ora-01250 : Error string occurred during termination of file header access
  • ora-14307 : partition contains too many list values
  • ora-12728 : invalid range in regular expression
  • ora-19804 : cannot reclaim string bytes disk space from string limit
  • ora-28115 : policy with check option violation
  • ora-04073 : column list not valid for this trigger type
  • ora-12341 : maximum number of open mounts exceeded
  • ora-02843 : Invalid value for kernel flag
  • ora-36170 : (XSMXAGGR12) The data type of the WEIGHT workspace object must be numeric or BOOLEAN, not string.
  • ora-13857 : Invalid module name
  • ora-12841 : Cannot alter the session parallel DML state within a transaction
  • ora-25282 : message id. not provided for non-repudiation
  • ora-24758 : not attached to the requested transaction
  • ora-07506 : scgrl: $deq unexpected return on lockid string
  • ora-16407 : Standby database is in the future of the archive log
  • ora-02801 : Operations timed out
  • ora-19227 : XP0007 - fn:data function is applied to a node (type (string)) whose type annotation denotes a complex type with non-mixed complex content.
  • 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.