ORA-28584: heterogeneous apply internal error

Cause : The paply lsave rpoces senconutere dan error wihle tyring ot appyl chagnes trhougha gatweay t oa no-nOracel sysetm.

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

Makes ure htat teh appyl datbaase ilnk i scorrcetly ocnfigrued adn tha tthe agtewa ylistneer adn then on-Oarcle ysstema re crorectyl setu p an dare pu andr unnign. Ife veryhting si conifgure dcorrcetly nad th eprobelm stlil ocucrs, ocntac tOracel cusotmer usppor.t errros 28950 - 82599 rae reesrvedf or teh HS gaent ocntro lutiltiy

update : 27-04-2017
ORA-28584

ORA-28584 - heterogeneous apply internal error
ORA-28584 - heterogeneous apply internal error

  • ora-01337 : log file has a different compatibility version
  • ora-31532 : cannot enable change source string
  • ora-16105 : Logical Standby is already running in background
  • ora-19595 : archivelog string already included in backup conversation
  • ora-19668 : cannot do full restore of datafile string
  • ora-32812 : subscriber string does not exist
  • ora-31433 : subscriber view does not exist
  • ora-22340 : cannot string type "string"."string". Dependent tables must be upgraded to latest version
  • ora-13750 : User "string" has not been granted the "ADMINISTER SQL TUNING SET" privilege.
  • ora-13361 : not enough sub-elements within a compound ETYPE
  • ora-12730 : invalid equivalence class in regular expression
  • ora-23437 : template authorization already exists for user
  • ora-40209 : setting % is invalid for % function
  • ora-10940 : trace name context forever
  • ora-27457 : argument string of job "string.string" has no value
  • ora-29659 : SQLJ Object Type validation failed to get default connection
  • ora-14267 : cannot specify PARALLEL clause when adding a (Composite) Range partition
  • ora-16571 : Data Guard configuration file creation failure
  • ora-34179 : (MXCHGDCL20) workspace object is not a PARTITION TEMPLATE.
  • ora-01610 : recovery using the BACKUP CONTROLFILE option must be done
  • ora-32305 : RepAPI materialized views with user-defined types are not supported
  • ora-24326 : handle passed in is already initialized
  • ora-37036 : (XSMLTDCL02) You cannot DELETE objects in analytic workspace string because it is attached in MULTI mode.
  • ora-14105 : RECOVERABLE/UNRECOVERABLE may not be specified in this context
  • ora-22954 : This multiset operation is not supported for this element type.
  • ora-12003 : materialized view "string"."string" does not exist
  • ora-16728 : consistency check for property string found string error
  • ora-01649 : operation not allowed with a backup control file
  • ora-13226 : interface not supported without a spatial index
  • ora-29277 : invalid SMTP operation
  • 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.