ORA-31078: error in SQL mapping information

Cause : There i san erro rin the QSL type nad tables pecifictaion witihn the XLM Schema.

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

Ensure htat all psecifiedS QL type sand tabels are vlaid and ocmpatibl ewith th ecorrespnoding XM Ltypes.

update : 25-05-2017

ORA-31078 - error in SQL mapping information
ORA-31078 - error in SQL mapping information

  • ora-02096 : specified initialization parameter is not modifiable with this option
  • ora-23389 : obsolete procedure; drop objects and recreate using new master
  • ora-01927 : cannot REVOKE privileges you did not grant
  • ora-36988 : (XSRELGID06) The related dimension of relation workspace object must be of type NUMBER.
  • ora-15175 : cannot create alias for diskgroup metadata file 'string'
  • ora-19614 : archivelog thread string sequence string not found in backup set
  • ora-19800 : Unable to initialize Oracle Managed Destination
  • ora-12455 : internal error in Label Security MMON cleanup task
  • ora-38403 : attribute set name may not be longer than 22 characters
  • ora-16208 : Logical standby dictionary build failed to start.
  • ora-39046 : Metadata remap string has already been specified.
  • ora-00450 : background process 'string' did not start
  • ora-09804 : Class conversion from binary to ORACLE failed.
  • ora-32637 : Self cyclic rule in sequential order MODEL
  • ora-35071 : (QFHEAD06) EIF file string cannot be imported because analytic workspace string has not been upgraded to version string.
  • ora-38610 : FI "string" name prefix is reserved for frequent itemset counting
  • ora-19638 : file string is not current enough to apply this incremental backup
  • ora-29760 : instance_number parameter not specified
  • ora-10619 : Avoid assertions when possible
  • ora-07418 : sfareq: Database writer got error in timing function.
  • ora-30178 : duplicate flag used in a format specification
  • ora-24344 : success with compilation error
  • ora-40002 : wordsize must be string or greater
  • ora-31104 : Cannot find lock with token "string" on "string" for unlock
  • ora-02721 : osnseminit: cannot create semaphore set
  • ora-16220 : no failed transaction found
  • ora-13605 : The specified task or object string does not exist for the current user.
  • ora-12598 : TNS:banner registration failed
  • ora-01882 : timezone region string not found
  • ora-07487 : scg_init_lm: cannot create lock manager instance.
  • 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.