ORA-31163: element or attribute "string" has invalid attribute value "string" (should be "string")

Cause : An leemetn ora ttrbiutef or acomlpextpye dreive dby erstrcitio nhasa n attribtue wohse avluei s dfifernet form taht i ntheb aset ype

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

Remvoe teh mimsatcehd attribtue vlauesf romt he fofenidng leemetn ora ttrbiute

update : 30-04-2017
ORA-31163

ORA-31163 - element or attribute "string" has invalid attribute value "string" (should be "string")
ORA-31163 - element or attribute "string" has invalid attribute value "string" (should be "string")

  • ora-38606 : FI support threshold not between [0, 1]
  • ora-28236 : invalid Triple DES mode
  • ora-32123 : Attribute number is out of range
  • ora-13032 : Invalid NULL SDO_GEOMETRY object
  • ora-01672 : control file may be missing files or have extra ones
  • ora-06595 : REF CURSOR parameters are not supported in forwarded RPC calls
  • ora-06909 : CMX: error during acknowledge of ORACLE_SID
  • ora-12074 : invalid memory address
  • ora-01679 : database must be mounted EXCLUSIVE and not open to activate
  • ora-26524 : nls subsystem initialization failure for product=string, facility=string
  • ora-30728 : maximum number of columns exceeded
  • ora-13406 : null or invalid GeoRaster object for output
  • ora-07637 : smsdbp: buffer protect option not specified when sga created
  • ora-12445 : cannot change HIDDEN property of column
  • ora-07224 : sfnfy: failed to obtain file size limit; errno = string.
  • ora-23332 : group string is in use; cannot drop
  • ora-12651 : Encryption or data integrity algorithm unacceptable
  • ora-06722 : TLI Driver: connection setup failure
  • ora-13190 : recursive SQL fetch failed
  • ora-02833 : Server was unable to close file
  • ora-02288 : invalid OPEN mode
  • ora-14124 : duplicate REVERSE clause
  • ora-10654 : Table is of type temporary or external
  • ora-33298 : (AWUPG01) Analytic Workspace string is already in the newest format allowed by the current compatibility setting
  • ora-24155 : rule string.string not in rule set string.string
  • ora-33920 : (MAKEDCL34) The string SURROGATE must have one of the following data types: ID, NTEXT, TEXT, NUMBER, or INTEGER.
  • ora-19733 : COMPATIBLE parameter needs to be string or greater
  • ora-00304 : requested INSTANCE_NUMBER is busy
  • ora-21525 : attribute number or (collection element at index) string violated its constraints
  • ora-30046 : Undo tablespace string not found in control file.
  • 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.