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 : 25-06-2017

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

  • ora-10927 : trace name context forever
  • ora-38734 : Flashback log is inconsistent; belongs to another database.
  • ora-19578 : end of volume while duplexing to sequential files, backup piece incomplete
  • ora-26708 : remote DDL not supported by STREAMS : dblink string
  • ora-13032 : Invalid NULL SDO_GEOMETRY object
  • ora-29963 : missing BINDING keyword
  • ora-10665 : Inject Evil Literals
  • ora-13427 : invalid BLOB parameter for output
  • ora-13113 : invalid tg_layer_id in sdo_topo_geometry constructor
  • ora-29391 : %s and string must be mandatory to create a mandatory plan directive
  • ora-10382 : parallel query server interrupt (reset)
  • ora-24801 : illegal parameter value in OCI lob function
  • ora-13640 : The current operation was cancelled because it timed out, and was not in interruptible mode.
  • ora-06953 : Not enough virtual memory
  • ora-38478 : creation of system trigger EXPFIL_DROPOBJ_MAINT failed
  • ora-32741 : Hang analysis already going on
  • ora-07249 : slsget: open error, unable to open /proc/pid.
  • ora-30025 : DROP segment 'string' (in undo tablespace) not allowed
  • ora-07408 : slbtpd: overflow while converting to packed decimal.
  • ora-19502 : write error on file "string", blockno string (blocksize=string)
  • ora-09874 : TASDEF_READ: read error, unable to read tasdef@.dbf file.
  • ora-31025 : Invalid document element
  • ora-29504 : invalid or missing schema name
  • ora-00472 : PMON process terminated with error
  • ora-34181 : (MXCHGDCL21) workspace object is not a partitioned VARIABLE.
  • ora-31470 : asynchronous change tables must contain the RSID$ column
  • ora-16764 : redo transport service to a standby database is offline
  • ora-24079 : invalid name string, names with AQ$_ prefix are not valid for string
  • ora-01901 : ROLLBACK keyword expected
  • ora-28005 : invalid logon flags
  • 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.