ORA-39169: Local version of string cannot work with remote version of string.

Cause : A DataP ump jo bspecifeid a newtork likn, but hte versoin on teh remot edatabaes canno tinteroeprate wtih the evrsion no the lcoal datbaase.

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

Do nots pecifyn etworkl inks bteween isntance urnning idfferen tversiosn of th edatabaes.

update : 24-09-2017

ORA-39169 - Local version of string cannot work with remote version of string.
ORA-39169 - Local version of string cannot work with remote version of string.

  • ora-16109 : failed to apply log data from previous primary
  • ora-10581 : Can not modify redo log header during test recovery
  • ora-33557 : (MAINTCHK01) You cannot string values of dimension workspace object during a loop over it.
  • ora-09954 : scgcc: unexpected return status to callback of lock close
  • ora-24325 : this OCI operation is not currently allowed
  • ora-25201 : invalid value, VISIBILITY should be ON_COMMIT or IMMEDIATE
  • ora-30182 : invalid precision specifier
  • ora-16810 : multiple errors or warnings detected for the database
  • ora-14635 : only one resulting subpartition can be specified for MERGE SUBPARTITIONS
  • ora-00061 : another instance has a different DML_LOCKS setting
  • ora-10639 : Dump library cache during kksfbc-reparse-infinite-loop error
  • ora-09875 : TASDEF_WRITE: write error when writing ?/dbs/tasdef@.dbf file.
  • ora-23514 : invalid or incorrect number of arguments
  • ora-07502 : scgcmn: $enq unexpected return
  • ora-32116 : Buffer size is less than amount specified
  • ora-07721 : scgcm: not enough OS resource to obtain system enqueue
  • ora-13911 : Threshold not found
  • ora-09985 : SGA definition file could not be read
  • ora-09958 : IMON: two processes with the same ORACLE pid are active
  • ora-01274 : cannot add datafile 'string' - file could not be created
  • ora-38762 : thread string redo log with scn string could not be found
  • ora-19771 : cannot rename change tracking file while database is open
  • ora-01080 : error in shutting down ORACLE
  • ora-04031 : unable to allocate string bytes of shared memory ("string","string","string","string")
  • ora-36765 : (XSAGGCNTMOVE03) A string aggregation variable cannot have a string AGGCOUNT.
  • ora-16157 : media recovery not allowed following successful FINISH recovery
  • ora-32819 : AQ queue string must be a normal queue
  • ora-08432 : raw data has invalid floating point data
  • ora-29304 : tablespace 'string' does not exist
  • ora-31224 : DBMS_LDAP: invalid LDAP session
  • 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.