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 : 25-04-2017
ORA-28521

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

  • ora-32766 : instr with negative offset: use varchar semantics on LOBs
  • ora-31621 : error creating master process
  • ora-38777 : database must not be started in any other instance.
  • ora-06142 : NETTCP: error getting user information
  • ora-00489 : ARB* process terminated with error
  • ora-26736 : Data Pump error
  • ora-29822 : selectivity cannot be specified for the type of object
  • ora-06005 : NETASY: dialogue file read failure
  • ora-24000 : invalid value string, string should be of the form [SCHEMA.]NAME
  • ora-36831 : (XSLMGEN01) View token cannot be NA
  • ora-16659 : failover operation in progress
  • ora-07227 : rtneco: unable to set noecho mode.
  • ora-31643 : unable to close dump file "string"
  • ora-12336 : cannot login to database (link name string)
  • ora-01429 : Index-Organized Table: no data segment to store overflow row-pieces
  • ora-03238 : unable to extend LOB segment string.string subpartition string by string in tablespace string
  • ora-37044 : (XSACQUIRE_OLDGEN) Cannot acquire object workspace object without resync.
  • ora-00063 : maximum number of log files exceeded string
  • ora-14519 : Conflicting tablespace blocksizes for string string: Tablespace string block size string [string] conflicts with previously specified/implied tablespace string block size string [string]
  • ora-01029 : internal two task error
  • ora-06536 : IN bind variable bound to an OUT position
  • ora-19375 : no CREATE TABLE privilege on schema "string"
  • ora-39114 : Dump files are not supported for network jobs.
  • ora-01646 : tablespace 'string' is not read only - cannot make read write
  • ora-27007 : failed to open file
  • ora-09792 : sllfop: cannot allocate read buffer.
  • ora-27196 : skgfpbk: sbtpcbackup returned error
  • ora-16805 : change of LogXptMode property violates overall protection mode
  • ora-04083 : invalid trigger variable 'string'
  • ora-13065 : cannot delete a child layer with a parent layer
  • 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.