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 : 23-07-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-02340 : invalid column specification
  • ora-25133 : duplicate SINGLE TABLE option specified
  • ora-24044 : source string and destination string object types do not match
  • ora-08232 : smsdes: cannot detach from SGA
  • ora-19230 : XP0010 - unsupported axis string
  • ora-03127 : no new operations allowed until the active operation ends
  • ora-31202 : DBMS_LDAP: LDAP client/server error: string
  • ora-36280 : (XSCGMDLAGG08) Valueset workspace object does not contain values of any dimension of the current model.
  • ora-15014 : location 'string' is not in the discovery set
  • ora-02213 : duplicate PCTUSED option specification
  • ora-02066 : missing or invalid DISPATCHERS text
  • ora-12014 : table 'string' does not contain a primary key constraint
  • ora-36951 : (XSFCAST28) The ALLOCLAST parameter cannot be set to YES unless PERIODICITY specifies more than one cycle.
  • ora-16737 : the redo transport service for standby database "string" has an error
  • ora-08466 : raw buffer length string is too short for string
  • ora-30104 : 'string' is not a legal integer for 'string'
  • ora-01570 : MINEXTENTS must be no larger than the string extents currently allocated
  • ora-39317 : call to DBMS_SCHEMA_COPY.VALIDATION_CHECK is not legal
  • ora-13348 : polygon boundary is not closed
  • ora-07255 : spini: cannot set up signal handler.
  • ora-10572 : Test recovery canceled due to errors
  • ora-13523 : unable to allocate required space for return type
  • ora-36972 : (XSRELTBL13) Relation workspace object must be dimensioned by workspace object.
  • ora-09987 : unable to attach to SGA in READ-ONLY mode
  • ora-01865 : not a valid era
  • ora-10945 : trace name context forever
  • ora-19668 : cannot do full restore of datafile string
  • ora-12804 : parallel query server appears to have died
  • ora-14457 : disallowed Nested Table column in a Temporary table
  • ora-09915 : Password encryption failed.
  • 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.