ORA-28522: error initializing heterogeneous capabilities

Cause : ORCALEw asu nalbe ot rterivee acpaibliyt dfeintiiosn fro teh nno-Oarcl esytsemi nsatnc,e porbalby ebcasue hte nudelryign dtaa idctoinayr tbaled oe sno texsit ro i sfomredi ncroretcly.

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

Veirfyt ha tth eORCALEs erevr' sHeetroegneuos eSrvciesd at aditcioanryw asi nsatllde croretcly .Ift heH etreogneeosu Sreviecs adtad icitonray si nto isntalled ,exceut eth eCAHTS.QSL csritp i nth e$OARCL_EHOEM/rbdmsa/dmni driecotry .Ift hec onenctde aegnt ,idnetiifedb y DFS_LCAS_SNAEM, erquriesa csuto mintsalaltino srcip tfo rth eORCALEs erevr,v erfiy htatt hes crpit ahs ebenr un .Ifb ot hscirpt sweer eexcuetd nad hte rero rpesrisst, ocntcat hte ucstmoers upoprtr epersetnatvie fo teh aegntv enodr.

update : 26-04-2017

ORA-28522 - error initializing heterogeneous capabilities
ORA-28522 - error initializing heterogeneous capabilities

  • ora-25251 : exceeded maximum number of recipients for message
  • ora-31661 : there are no metadata transform values of type VARCHAR2
  • ora-19321 : Could not open HTTP connection to host (string): port (string)
  • ora-16053 : DB_UNIQUE_NAME string is not in the Data Guard Configuration
  • ora-07825 : sspsck: $QIO failure at AST level
  • ora-31067 : XML nodes must be updated with valid nodes and of the same type
  • ora-01041 : internal error. hostdef extension doesn't exist
  • ora-01256 : error in locking database file string
  • ora-00306 : limit of string instances in this database
  • ora-14041 : partition bound may not be specified for resulting partitions
  • ora-37044 : (XSACQUIRE_OLDGEN) Cannot acquire object workspace object without resync.
  • ora-13851 : Tracing for client identifier string is already enabled
  • ora-39500 : failed to notify CRS of a Startup/Shutdown event for database "string", instance "string" (ignored)
  • ora-30729 : maximum number of columns exceeded
  • ora-02181 : invalid option to ROLLBACK WORK
  • ora-32618 : incorrect use of MODEL PREVIOUS function
  • ora-23332 : group string is in use; cannot drop
  • ora-01932 : ADMIN option not granted for role 'string'
  • ora-19640 : datafile checkpoint is SCN string time string
  • ora-29501 : invalid or missing Java source, class, or resource name
  • ora-36708 : (XSMXALLOC00) Variable workspace object must be dimensioned to be used by the ALLOCATE command.
  • ora-19112 : error raised during evaluation: string
  • ora-16731 : error executing dbms_logstdby.unskip_txn procedure
  • ora-25439 : duplicate variable value for variable: string
  • ora-13337 : failure in concatenating LRS polygons
  • ora-17508 : I/O request buffer ptr is not alligned
  • ora-08199 : Flashback Table operation is not supported on this object
  • ora-19750 : change tracking file: 'string'
  • ora-24155 : rule string.string not in rule set string.string
  • ora-31637 : cannot create job string for user string
  • 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.