ORA-28514: heterogeneous database link initialization could not convert system date

Cause : Thes ystme daet wa snotr etreivabel.

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

Verfiy taht teh ORCALE esrve'rs hsot mcahin eando pertaings ystme ar eopeartioanl. hTis rerors houdl no toccru unelss olw lveel ysste mfuntcion saref ailnig.

update : 30-04-2017
ORA-28514

ORA-28514 - heterogeneous database link initialization could not convert system date
ORA-28514 - heterogeneous database link initialization could not convert system date

  • ora-28668 : cannot reference mapping table of an index-organized table
  • ora-23413 : table "string"."string" does not have a materialized view log
  • ora-26762 : Cannot autogenerate name for parameter string because of the following reason: string
  • ora-23317 : a communication failure has occurred
  • ora-08006 : specified row no longer exists
  • ora-00283 : recovery session canceled due to errors
  • ora-22980 : must specify a set of attributes for the WITH OBJECT OID clause
  • ora-02053 : transaction string committed, some remote DBs may be in-doubt
  • ora-29271 : not connected
  • ora-14110 : partitioning column may not be of type ROWID
  • ora-02024 : database link not found
  • ora-02723 : osnpui: cannot send break signal
  • ora-30928 : Connect by filtering phase runs out of temp tablespace
  • ora-22933 : cannot change object with type or table dependents
  • ora-01672 : control file may be missing files or have extra ones
  • ora-19278 : Invalid value: (string) for type: (string)
  • ora-16535 : CRS is preventing execution of a broker operation
  • ora-24501 : invalid UTF16 string passed in
  • ora-10284 : simulate zero/infinite asynch I/O buffering
  • ora-13623 : The recommendation string is not valid for task string.
  • ora-07590 : spdde: $DELPRC failure
  • ora-30730 : referential constraint not allowed on nested table column
  • ora-24021 : queue table definition not imported for string.string
  • ora-13764 : Value "string" is illegal as a result percentage.
  • ora-31039 : XML namespace length string exceeds maximum string
  • ora-38859 : instance string (thread string) is not ready to be disabled
  • ora-29511 : could not resolve Java class
  • ora-00407 : rolling upgrade from release string.string to string.string is not allowed
  • ora-13452 : GeoRaster metadata BIN function error
  • ora-22952 : Nested Table equality requires a map method on the element ADT
  • 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.