ORA-28510: heterogeneous database link initialization failed

Cause : nItiaiilazitnoo f aehetoregenuo sadatabesl ni kota n noO-arlc eystsmef iael dud eota nreor rdineitifdeb yht egane tof rhtsin noO-arlc eystsme.

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

aMeks ru eht eon-nrOcaels syet msiu pna durnnni gna dhttaa llo fht eneivormnne tna dnitiaiilazitnov laeu sof rht egane tra ees tocrrcelt.y

update : 19-08-2017

ORA-28510 - heterogeneous database link initialization failed
ORA-28510 - heterogeneous database link initialization failed

  • ora-38419 : invalid identifier in attribute : string
  • ora-33018 : (XSAGDNGL08) In AGGMAP workspace object, the data type of workspace object must be TEXT, not string.
  • ora-30972 : invalid ALTER INDEX option for XML Index
  • ora-15048 : ASM internal files cannot be deleted
  • ora-22370 : incorrect usage of method string
  • ora-03286 : ALLOCATE EXTENT not valid for HASH CLUSTERS
  • ora-33334 : (DSSEXIST04) Analytic workspace string is not attached.
  • ora-19251 : XQ0031 - unsupported query version
  • ora-12571 : TNS:packet writer failure
  • ora-13346 : the coordinates defining an arc are collinear
  • ora-07494 : scgcm: unexpected error.
  • ora-40306 : wide data not supported for decision tree model create
  • ora-01061 : cannot start up a V8 server using a V7 client application
  • ora-23357 : the propagator does not exist
  • ora-09976 : skxfqdini: Error Creating Port
  • ora-27463 : invalid program type string
  • ora-24052 : cannot propagate object type payloads with LOB attributes to an 8.0 release
  • ora-02196 : PERMANENT/TEMPORARY option already specified
  • ora-39203 : Partition selection is not supported over a network link.
  • ora-13904 : The file has been dropped and recreated during the procedure call.
  • ora-31227 : DBMS_LDAP: invalid LDAP MESSAGE handle
  • ora-02096 : specified initialization parameter is not modifiable with this option
  • ora-00038 : Cannot create session: server group belongs to another user
  • ora-01219 : database not open: queries allowed on fixed tables/views only
  • ora-32310 : object materialized views must select from an object table
  • ora-27208 : syntax error in device PARMS - environment variable value missing
  • ora-19102 : XQuery string literal expected
  • ora-28501 : communication error on heterogeneous database link
  • ora-01424 : missing or illegal character following the escape character
  • ora-39076 : cannot delete 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.