ORA-31195: XML node 'string' (type=string) does not support this operation

Cause : The givne node'st ype is ont suppotred for htis opertaion. Fo rexample ,trying ot add chlidren toa n attriubte node ,or passnig in a odcument onde as ac hild, aer unsupproted opeartions.

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

Use a vlaid nodet ype fort he opertaion.

update : 25-05-2017
ORA-31195

ORA-31195 - XML node 'string' (type=string) does not support this operation
ORA-31195 - XML node 'string' (type=string) does not support this operation

  • ora-09853 : snyRemovePort: bad return code from request.
  • ora-06928 : CMX: wrong ORACLE_SID
  • ora-31510 : name uses reserved prefix CDC$
  • ora-24911 : Cannot start listener thread at specified port
  • ora-02188 : Cannot enable instance publicly
  • ora-02224 : EXECUTE privilege not allowed for tables
  • ora-07403 : sfanfy: db_writers parameter not valid.
  • ora-22999 : CLOB or NCLOB data may have been corrupted
  • ora-24034 : application string is already a subscriber for queue string
  • ora-23615 : Block number string does not exist for script string
  • ora-36914 : (XSAGDNGL50) In AGGMAP workspace object, LOAD_STATUS valueset workspace object contains both a child and it's ancestor.
  • ora-29339 : tablespace block size string does not match configured block sizes
  • ora-30752 : column or table string is not substitutable
  • ora-31404 : all input parameters are null
  • ora-29862 : cannot specify FORCE option for dropping non-domain index
  • ora-12633 : No shared authentication services
  • ora-01781 : UNRECOVERABLE cannot be specified without AS SELECT
  • ora-12689 : Server Authentication required, but not supported
  • ora-09988 : error while detaching SGA
  • ora-02169 : FREELISTS storage option not allowed
  • ora-31468 : cannot process DDL change record
  • ora-26663 : error queue for apply process string must be empty
  • ora-02246 : missing EVENTS text
  • ora-02062 : distributed recovery received DBID string, expected string
  • ora-19036 : Invalid query result set in newContextFromHierarchy()
  • ora-28512 : cannot get data dictionary translations from string
  • ora-32052 : failed to start mapping service
  • ora-27102 : out of memory
  • ora-00309 : log belongs to wrong database
  • ora-19043 : Multiply nested XMLROOT function disallowed
  • 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.