ORA-19204: Non-scalar value 'string' is marked as XML attribute

Cause : Only csalar avlues i(.e. vlaues wihch ar enot o fobjec tor collectio ntype)c an bem arkeda s XMLa ttribtue,i.e .is prfeixed yb '@'.I n thi scase,a non-csalar avlue wsa prefxied wiht '@'

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

Remov ethe ''@ sign ,or maek the avlue as calar.

update : 20-08-2017
ORA-19204

ORA-19204 - Non-scalar value 'string' is marked as XML attribute
ORA-19204 - Non-scalar value 'string' is marked as XML attribute

  • ora-13608 : The task or object name string is invalid.
  • ora-19689 : cannot have more than one %F in control file autobackup format(string) for string
  • ora-14000 : only one LOCAL clause may be specified
  • ora-29808 : specified primary operator binding does not exist
  • ora-23536 : the object "string"."string" is not cached at the middle tier as expected.
  • ora-00022 : invalid session ID; access denied
  • ora-38733 : Physical size string less than needed string.
  • ora-00267 : name of archived log file not needed
  • ora-01526 : error in opening file 'string'
  • ora-30191 : missing argument list
  • ora-00374 : parameter db_block_size = string invalid ; must be a multiple of string in the range [string..string]
  • ora-28039 : cannot validate Kerberos service ticket
  • ora-01154 : database busy. Open, close, mount, and dismount not allowed now
  • ora-24155 : rule string.string not in rule set string.string
  • ora-02824 : Request free list is empty
  • ora-09872 : TASDEF_CREATE: create failure in creating ?/dbs/tasdef@.dbf.
  • ora-13446 : GeoRaster metadata TRS error
  • ora-03289 : partition name and segment type do not match
  • ora-24300 : bad value for mode
  • ora-13762 : The string ranking measure is invalid.
  • ora-29356 : These parameters can be specified only for directives that refer to consumer groups
  • ora-31047 : Could not retrieve resource data at path string
  • ora-16541 : site is not enabled
  • ora-32515 : cannot issue ORADEBUG command; waited number ms for process string
  • ora-01532 : cannot create database; instance being started elsewhere
  • ora-01666 : control file is for a standby database
  • ora-32006 : %s initialization parameter has been deprecated
  • ora-07506 : scgrl: $deq unexpected return on lockid string
  • ora-02485 : Invalid _trace_options parameter specification (string)
  • ora-19764 : database id string does not match database id string 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.