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 : 18-08-2017

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

  • ora-07253 : spdes: semctl error, unable to destroy semaphore set.
  • ora-29800 : invalid name for operator
  • ora-09202 : sfifi: error identifying file
  • ora-38449 : table "string" does not exist or is not accessible
  • ora-12450 : LOB datatype disabled in LBAC initialization file
  • ora-29550 : Java session state cleared
  • ora-31211 : DBMS_LDAP: PL/SQL - Invalid LDAP entry dn.
  • ora-04061 : existing state of string has been invalidated
  • ora-02444 : Cannot resolve referenced object in referential constraints
  • ora-19503 : cannot obtain information on device, name="string", type="string", parms="string"
  • ora-13148 : failed to generate SQL filter
  • ora-12688 : Login failed: the SecurID server rejected the new pincode
  • ora-09978 : skxfqhdel: Error Disconnecting from another endpoint.
  • ora-16074 : ARCH processes must be active
  • ora-30484 : missing window specification for this function
  • ora-23325 : parameter type is not string
  • ora-23495 : serial propagation can not be used for "string"
  • ora-22053 : overflow error
  • ora-32020 : SID=* clause needed to modify this parameter
  • ora-01217 : logfile member belongs to a different logfile group
  • ora-32004 : obsolete and/or deprecated parameter(s) specified
  • ora-06035 : NETDNT: connect failed, insufficient resources
  • ora-08457 : syntax error in SEPARATE CHARACTER option of SIGN clause
  • ora-24903 : invalid namespace attribute passed into OCI call
  • ora-39045 : invalid metadata remap name string
  • ora-09913 : Malloc of dummy name failed.
  • ora-12207 : TNS:unable to perform navigation
  • ora-29504 : invalid or missing schema name
  • ora-40206 : invalid setting value for setting name string
  • ora-36740 : A CHILDLOCK was detected in your valueset
  • 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.