ORA-28521: no heterogeneous capability information available

Cause : Th eORCALEs erevr' sdaat dcitinoar ydi dno tcotnai ncaapbiiltyd efniitoinsf ort hec onenctde nno-Oarcl esytsem ,an dauotmaitc eslfr-egsitrtaio n(dtaa idctoinayr ulpoa)d wsa dsiabeld.

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

As ka BDA ot rseolev tihs rpobelm.T hee aseistr esloutoin si t oenbalea utmoatci slef-ergitsraitonb y esttnig hte ROACEL sreve'rs SH_ATUO_ERGITSERi niitalziatoin apraemte rtoT RU.E A naletrntaiv eist o oladt heH etreogneeosu Sreviecs adtad icitonray iwthi nfromaitons peicfi cfo rth eno-nOrcales ysetm yb eexcuitnga SLQ srcip tsupplide b yth eagnet evndro. fI teh srcip tisr una ndt hee rrro presitss,c onatctt hec usotme rsuppor trerpesnetaitveo f hte gaen tvednor.

update : 24-05-2017

ORA-28521 - no heterogeneous capability information available
ORA-28521 - no heterogeneous capability information available

  • ora-30205 : invalid Character set
  • ora-31442 : operation timed out while acquiring lock on string
  • ora-12424 : length exceeds binary label size
  • ora-15039 : diskgroup not dropped
  • ora-26523 : rpc termination error
  • ora-36691 : (NTEXTCNV02) Invalid escape sequence in argument to UNISTR function: string.
  • ora-36814 : (XSTBLFUNC07) The datatype of the column used in the ROW2CELL clause of a LIMITMAP must be RAW(16).
  • ora-27020 : named devices not supported
  • ora-23535 : instantiating templates from multiple back ends is not allowed.
  • ora-15066 : offlining disk "string" may result in a data loss
  • ora-23330 : column group string already exists
  • ora-36692 : (XSRELTBL00) The format of the HIERHEIGHT command is: HIERHEIGHT relation1[(dimension dimvalue, ...)] into relation2 [using relation3 | a | d] [levelorder lovs] [inhierarchy {variable | valueset}].
  • ora-19335 : Invalid format type object
  • ora-36712 : (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be used as a SOURCE or BASIS with ALLOCATE.
  • ora-15019 : discovered duplicate path 'string' for 'string'
  • ora-32060 : channel failure
  • ora-19668 : cannot do full restore of datafile string
  • ora-00608 : testing error [string] [string] [string] [string] [string]
  • ora-16147 : standby database referenced by multiple archive log destinations
  • ora-18003 : an outline already exists with this signature
  • ora-00151 : invalid transaction ID
  • ora-08000 : maximum number of session sequence lists exceeded
  • ora-02459 : Hashkey value must be a positive integer
  • ora-12997 : cannot drop primary key column from an index-organized table
  • ora-16198 : Timeout incurred on internal channel during remote archival
  • ora-23322 : Privilege error accessing pipe
  • ora-36694 : (XSRELTBL01) The value cannot be added to dimension workspace object.
  • ora-38440 : attribute set string does not exist
  • ora-25144 : invalid option for CREATE TABLESPACE with TEMPORARY contents
  • ora-32611 : incorrect use of MODEL CV operator
  • 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.