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 : 24-05-2017

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

  • ora-22911 : duplicate storage specification for the nested table item
  • ora-01552 : cannot use system rollback segment for non-system tablespace 'string'
  • ora-28182 : cannot acquire Kerberos service ticket for client
  • ora-32020 : SID=* clause needed to modify this parameter
  • ora-00379 : no free buffers available in buffer pool string for block size stringK
  • ora-28365 : wallet is not open
  • ora-29549 : class string.string has changed, Java session state cleared
  • ora-38902 : errors in array insert exceed string
  • ora-25114 : invalid file number specified in the DUMP DATAFILE/TEMPFILE command
  • ora-09281 : sllfop: error opening file
  • ora-24406 : API mode switch is disallowed when a call is in progress.
  • ora-25117 : MIN/MAX/Block Number expected
  • ora-24355 : attempt to store a negative number in an Unsigned Display type.
  • ora-33468 : (ESDREAD13) Discarding compiled code for workspace object because number is no longer a surrogate of dimension workspace object.
  • ora-25272 : Signature does not exist for the given reciever and message id.
  • ora-03002 : operator not implemented
  • ora-00285 : TIME not given as a string constant
  • ora-07416 : slpath: pathname construction failed; lack of output buffer space.
  • ora-26660 : Invalid action context value for string
  • ora-33263 : Could not create analytic workspace string
  • ora-06401 : NETCMN: invalid driver designator
  • ora-22056 : value [string] is divided by zero
  • ora-02428 : could not add foreign key reference
  • ora-06903 : CMX: cannot read transport address of remote application
  • ora-36673 : (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the format.
  • ora-23309 : object string.string of type string exists
  • ora-06707 : TLI Driver: connection failed
  • ora-01662 : tablespace 'string' is non-empty and cannot be made temporary
  • ora-28117 : integrity constraint violated - parent record not found
  • ora-25002 : cannot create INSTEAD OF triggers on tables
  • 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.