ORA-28523: ORACLE and heterogeneous agent are incompatible versions

Cause : An operation on a database link attempted to connect to a non-Oracle system, but the ORACLE instance and the agent process for the non-Oracle system are incompatible.

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

Ask your DBA to confirm configuration of both the ORACLE instance and the agent. Additional information on the version incompatibility is logged in trace (*.TRC) files, the ORACLE instance and the agent, and in the ORACLE instance's alert log. Check the documentation for your agent to find out which releases of the Oracle Server are supported.

update : 25-04-2017

ORA-28523 - ORACLE and heterogeneous agent are incompatible versions
ORA-28523 - ORACLE and heterogeneous agent are incompatible versions

  • ora-00252 : log string of thread string is empty, cannot archive
  • ora-16104 : invalid Logical Standby option requested
  • ora-09914 : Unable to open the ORACLE password file.
  • ora-27212 : some entrypoints in Media Management Library are missing
  • ora-07324 : smpall: malloc error while allocating pga.
  • ora-09360 : Windows 3.1 Two-Task driver unable to allocate context area
  • ora-25187 : specified exceptions table form incorrect
  • ora-01101 : database being created currently mounted by some other instance
  • ora-09750 : pw_attachPorts: port_rename failed.
  • ora-22064 : invalid NLS parameter string [string]
  • ora-30346 : hierarchy name must be unique within a dimension
  • ora-16719 : unable to query V$ARCHIVE_DEST fixed view
  • ora-03247 : Invalid block number specified
  • ora-25185 : index column other than last can not be specified for INCLUDE clause
  • ora-36208 : (XSAGOP05N) In AGGMAP workspace object, you can only specify NAOPERATOR string with the PROPORTIONAL or EVEN operators, not string.
  • ora-00825 : cannot set db_block_buffers if sga_target set
  • ora-30747 : cannot create substitutable tables or columns of non final type string.string
  • ora-30483 : window functions are not allowed here
  • ora-32844 : exceeded maximum number of string values
  • ora-24009 : invalid value string, QUEUE_TYPE should be NORMAL_QUEUE or EXCEPTION_QUEUE
  • ora-12806 : could not get background process to hold enqueue
  • ora-33297 : (DBERR22) Analytic workspace string cannot be opened because it was last modified by an incompatible version of string.
  • ora-30021 : Operation not allowed on undo tablespace
  • ora-29360 : retry operation. Too much concurrent activity
  • ora-16621 : database name for ADD DATABASE must be unique
  • ora-07226 : rtneco: unable to get terminal mode.
  • ora-00350 : log string of instance string (thread string) needs to be archived
  • ora-19558 : error de-allocating device
  • ora-10571 : Test recovery canceled
  • ora-39018 : master process received invalid message number 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.