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 : 20-08-2017

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

  • ora-16004 : backup database requires recovery
  • ora-01253 : cannot start online backup - file string in recovery manager backup
  • ora-30028 : Automatic Undo Management event for NTP testing
  • ora-10586 : Test recovery had to corrupt 1 data block in order to proceed
  • ora-04053 : error occurred when validating remote object stringstringstringstringstring
  • ora-38497 : Expression Filter index does not exist
  • ora-39308 : application or database upgrade internal error: "string"
  • ora-19721 : Cannot find datafile with absolute file number string in tablespace string
  • ora-03002 : operator not implemented
  • ora-16125 : large transaction string string string is waiting for more data
  • ora-19020 : invalid dereference of XMLType columns
  • ora-32611 : incorrect use of MODEL CV operator
  • ora-01298 : conflicting dictionary option
  • ora-16764 : redo transport service to a standby database is offline
  • ora-00369 : Current log of thread string not useable and other log being cleared
  • ora-01147 : SYSTEM tablespace file string is offline
  • ora-29828 : invalid name for implementation type
  • ora-32303 : mviews with user-defined types cannot reference multiple master sites
  • ora-13366 : invalid combination of interior exterior rings
  • ora-16012 : Archive log standby database identifier mismatch
  • ora-38462 : invalid attribute list
  • ora-39012 : Client detached before the job started.
  • ora-23618 : Generation of script string is not complete.
  • ora-24777 : use of non-migratable database link not allowed
  • ora-13055 : Oracle object string does not exist in specified table
  • ora-25200 : invalid value string, QUEUE_NAME should be [SCHEMA.]NAME
  • ora-19284 : Encoding specification in version declaration not supported
  • ora-07205 : slgtd: time error, unable to obtain time.
  • ora-02066 : missing or invalid DISPATCHERS text
  • ora-01315 : Log file has been added or removed during select
  • 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.