ORA-17500: ODM err:string

Cause : An error returned by ODM library

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

Look at error message and take appropriate action or contact Oracle Support Services for further assistance

update : 25-04-2017

ORA-17500 - ODM err:string
ORA-17500 - ODM err:string

  • ora-29660 : Unable to find the class defined in the EXTERNAL NAME clause
  • ora-19038 : Invalid opertions on query context
  • ora-02784 : Invalid shared memory ID specified
  • ora-37001 : You have one or more attached but unupdated analytic workspaces.
  • ora-39778 : the parallel load option is not allowed when loading lob columns
  • ora-26085 : direct path operation must start its own transaction
  • ora-02046 : distributed transaction already begun
  • ora-07469 : sppst: mclear error, unable to clear semaphore.
  • ora-38904 : DML error logging is not supported for LOB column "string"
  • ora-19707 : invalid record block number - string
  • ora-12469 : no user levels found for user string and policy string
  • ora-15091 : operation incompatible with open handle in this session
  • ora-19505 : failed to identify file "string"
  • ora-26079 : file "string" is not part of table string.string
  • ora-25013 : OLD and PARENT values cannot be identical
  • ora-16564 : lookup failed, syntax error at string
  • ora-04021 : timeout occurred while waiting to lock object stringstringstringstringstring
  • ora-01045 : user string lacks CREATE SESSION privilege; logon denied
  • ora-29319 : datafile string is not correct
  • ora-14267 : cannot specify PARALLEL clause when adding a (Composite) Range partition
  • ora-02785 : Invalid shared memory buffer size
  • ora-10244 : make tranids in error msgs print as 0.0.0 (for testing)
  • ora-24775 : cannot prepare or commit transaction with non-zero lock value
  • ora-40213 : contradictory values for settings: string, string
  • ora-01344 : LogMiner coordinator already attached
  • ora-19606 : Cannot copy or restore to snapshot control file
  • ora-13791 : cannot resume a tuning task created to tune a single statement
  • ora-12033 : cannot use filter columns from materialized view log on "string"."string"
  • ora-25136 : this cluster can contain only one table
  • ora-24908 : invalid recipient presentation attribute
  • 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.