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 : 30-04-2017

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

  • ora-38716 : Must supply an integer for the TYPE option.
  • ora-38429 : invalid datatype for a stored attribute: string
  • ora-32314 : REFRESH FAST of "string"."string" unsupported after deletes/updates
  • ora-12686 : Invalid command specified for a service
  • ora-01561 : failed to remove all objects in the tablespace specified
  • ora-30116 : syntax error at 'string' following 'string'
  • ora-00443 : background process "string" did not start
  • ora-16253 : Logical Standby cannot start due to incomplete terminal apply
  • ora-24342 : unable to destroy a mutex
  • ora-27512 : IPC error posting a process
  • ora-02463 : Duplicate HASH IS option specified
  • ora-14084 : you may specify TABLESPACE DEFAULT only for a LOCAL index
  • ora-24124 : invalid ACTION parameter passed to DBMS_REPAIR.string procedure
  • ora-01683 : unable to extend index string.string partition string by string in tablespace string
  • ora-13147 : failed to generate MBR
  • ora-29290 : invalid offset specified for seek
  • ora-13109 : spatial table string exists
  • ora-02819 : Write failed
  • ora-24384 : Application context size is not initialized
  • ora-12151 : TNS:received bad packet type from network layer
  • ora-19110 : unsupported XQuery expression
  • ora-02722 : osnpui: cannot send break message to orapop
  • ora-38853 : cannot mark instance string (redo thread string) as disabled
  • ora-07276 : no dba group in /etc/group.
  • ora-25964 : column type incompatible with join column type
  • ora-38796 : Not enough flashback database log data to undo FLASHBACK.
  • ora-14637 : cannot merge a subpartition with itself
  • ora-01564 : rollback segment is not PUBLIC
  • ora-12048 : error encountered while refreshing materialized view "string"."string"
  • ora-16039 : RFS request version mismatch
  • 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.