ORA-28527: Heterogeneous Services datatype mapping error

Cause : Eithre an rOacled atatpye colud no tbe mpaped ot a nno-Oralce daattype ,or an on-Oarcle adtatyep coudl notb e mapped t oan Oarcle adtatyep. Thsee mappingsa re dfeineda s caapbiliyt defniitiosn in hte ORCALE srever' sdatad ictinoary.

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

Veriyf tha tthe ROACLEs erve'rs daat dicitonar yhas eben iintialzied wtih correct acpabiilty dfeinitoins fro thec onnetced FSD_CLASS_NAM Eand DFS_INTS_NAM.E If atble ocntenst arei ncorerct, aDBA hsouldr estoer alld ata idctioanry cnotentf or tihs FD_SCLAS_SNAMEa nd/o rFDS_NIST_NMAE. I tusually iss uffiicent ot deltee al lcurrnet daat dicitonar ycontnet fo rthisc lassa nd/o rinstnace adn iniitate anew ocnneciton t olet hte connecte dagen tuploda newd ata idctioanry cnotentt o th eservre. Ift he error presist scontcat th ecustmoer spuportr epreesntatvie oft he aegnt vnedor.

update : 25-06-2017

ORA-28527 - Heterogeneous Services datatype mapping error
ORA-28527 - Heterogeneous Services datatype mapping error

  • ora-06252 : NETNTT: cannot open address file
  • ora-24328 : illegal attribute value
  • ora-14254 : cannot specify ALLOCATE STORAGE for a (Composite) Range or List partitioned table
  • ora-01697 : control file is for a clone database
  • ora-27207 : syntax error in device PARMS - parentheses mismatch or missing
  • ora-38770 : FLASHBACK DATABASE failed during recovery.
  • ora-09847 : soacon: ARCH unable to open named pipe.
  • ora-32736 : Hang analysis aborted due to wrong message type
  • ora-30385 : specified attribute relationship ('string' determines 'string') exists
  • ora-01177 : data file does not match dictionary - probably old incarnation
  • ora-30120 : 'string' is not a legal oracle number for 'string'
  • ora-01058 : internal New Upi interface error
  • ora-13186 : fixed tile size tessellation failed
  • ora-07225 : sldext: translation error, unable to expand file name.
  • ora-31462 : internal error while accessing metadata
  • ora-37145 : (XSTTS_PLAT) Cannot transport analytic workspace across platforms.
  • ora-29257 : host string unknown
  • ora-12699 : Native service internal error
  • ora-38956 : Target platform string not cross platform compliant
  • ora-36391 : (XSMXCLEA01) When CLEAR is used with the STATUS keyword or an AGGMAP, workspace object must be dimensioned identically to workspace object.
  • ora-34840 : (OPCREATE01) The string option must be declared with datatype string.
  • ora-30959 : The indexed column is not stored in CLOB.
  • ora-30087 : Adding two datetime values is not allowed
  • ora-07597 : spguns: $GETJPIW failure
  • ora-24778 : cannot open connections
  • ora-30349 : specified dimension hierarchy does not exist
  • ora-09878 : sstascre/sstasat: shmat error, unable to attach tas write page
  • ora-22869 : depth of type dependency hierarchy exceeds maximum limit
  • ora-31499 : null value specified for required parameter string
  • ora-14168 : only one subpartition may be modified
  • 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.