ORA-19336: Missing XML root element

Cause : The XLM bein ggenertaed dose not ahve ane nclosnig roo telemetn.

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

The XLM genearted msut hav ea roo telemetn

update : 18-08-2017
ORA-19336

ORA-19336 - Missing XML root element
ORA-19336 - Missing XML root element

  • ora-16744 : the DG_CONFIG list of LOG_ARCHIVE_CONFIG parameter is full
  • ora-01033 : ORACLE initialization or shutdown in progress
  • ora-32110 : Connection not specified
  • ora-21527 : internal OMS driver error
  • ora-28357 : password required to open the wallet
  • ora-16138 : end of log stream not received from primary
  • ora-16058 : standby database instance is not mounted
  • ora-22132 : hexadecimal string does not correspond to a valid REF
  • ora-02482 : Syntax error in event specification (string)
  • ora-31492 : could not set session parameters for LogMiner session
  • ora-36690 : (NTEXTCNV01) Error during conversion from NTEXT to TEXT.
  • ora-00118 : Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified
  • ora-07499 : spglk: Cannot reschedule.
  • ora-13236 : internal error in R-tree processing: [string]
  • ora-04069 : cannot drop or replace a library with table dependents
  • ora-19029 : Cannot convert the given XMLType to the required type
  • ora-38729 : Not enough flashback database log data to do FLASHBACK.
  • ora-01229 : data file string is inconsistent with logs
  • ora-02466 : The SIZE and INITRANS options cannot be altered for HASH CLUSTERS.
  • ora-25175 : no PRIMARY KEY constraint found
  • ora-36994 : (XSRELGID11) The SURROGATE DIMENSION workspace object must be numeric.
  • ora-29917 : cannot lock a table which gets its rows from a collection operand
  • ora-14294 : Number of partitions does not match number of subpartitions
  • ora-13013 : the specified topology was not INTERIOR or BOUNDARY
  • ora-06404 : NETCMN: invalid login (connect) string
  • ora-28354 : wallet already open
  • ora-13444 : GeoRaster metadata SRS error
  • ora-28132 : Merge into syntax does not support security policies.
  • ora-07287 : sksagdi: unsupported device for log archiving.
  • ora-14164 : subpartition "string": INITRANS value must be less than MAXTRANS value
  • 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.