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 : 27-06-2017
ORA-28521

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

  • ora-01734 : illegal parameters - EXTENT MIN higher than EXTENT MAX
  • ora-14405 : partitioned index contains partitions in a different tablespace
  • ora-36861 : (XSTFRC01) SQL Cache ID parameter is invalid or missing.
  • ora-29329 : Table not of type XMLType
  • ora-31626 : job does not exist
  • ora-16186 : Modifying LOG_ARCHIVE_CONFIG requires SID='*' qualifier
  • ora-39045 : invalid metadata remap name string
  • ora-19200 : Invalid column specification
  • ora-27501 : IPC error creating a port
  • ora-02051 : another session in same transaction failed
  • ora-14004 : missing PARTITION keyword
  • ora-19930 : file string has invalid checkpoint SCN string
  • ora-37105 : (XSVPART05) Only variables dimensioned by a CONCAT PARTITION TEMPLATE can have string partitions.
  • ora-14644 : table is not subpartitioned by Hash method
  • ora-19287 : XP0017 - invalid number of arguments to function - string:string
  • ora-00057 : maximum number of temporary table locks exceeded
  • ora-06720 : TLI Driver: SID lookup failure
  • ora-38780 : Restore point 'string' does not exist.
  • ora-01779 : cannot modify a column which maps to a non key-preserved table
  • ora-38462 : invalid attribute list
  • ora-28173 : certificate not provided by proxy
  • ora-27250 : OS system call failure
  • ora-04931 : unable to set initial sequence number value
  • ora-02285 : duplicate START WITH specifications
  • ora-17510 : Attempt to do i/o beyond file size
  • ora-22951 : NULL returned by ORDER method
  • ora-22889 : REF value does not point to scoped table
  • ora-33911 : (MAKEDCL29) You cannot define a string in analytic workspace string because it has not been upgraded to version string.
  • ora-38401 : synonym string not allowed
  • ora-26680 : object type not supported
  • 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.