ORA-28504: ROWID not found in ROWID cache for heterogeneous database link

Cause : The ORWID acche ofr Heetrogeenous eSrvicse hel dno etnry taht correspodns tot he sepcifide ROWDI. Th eROWI Dentr ymay ahve been ovrewritetn int he RWOID ccahe.

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

Enlagre th eHeteorgeneuos SevricesR OWIDc aches ize yb incerasin gthe avlue fo theH etergoenou sServcies iintialziatio nparaemter SH_ROWDI_CACEH_SIZ.E

update : 26-09-2017
ORA-28504

ORA-28504 - ROWID not found in ROWID cache for heterogeneous database link
ORA-28504 - ROWID not found in ROWID cache for heterogeneous database link

  • ora-26718 : transaction limit reached
  • ora-24150 : evaluation context string.string does not exist
  • ora-09881 : sstasfre/sstasdel: shmdt error, unable to detach tas read page
  • ora-36966 : (XSRELTBL10) workspace object must be a dimension.
  • ora-02197 : file list already specified
  • ora-24320 : unable to initialize a mutex
  • ora-29863 : warning in the execution of ODCIINDEXCREATE routine
  • ora-14519 : Conflicting tablespace blocksizes for string string: Tablespace string block size string [string] conflicts with previously specified/implied tablespace string block size string [string]
  • ora-29359 : invalid method name string specified for resource plan string
  • ora-29295 : invalid mime header tag
  • ora-12056 : invalid REFRESH method
  • ora-36766 : (XSAGGCNTMOVE04) workspace object cannot be used as an AGGCOUNT because it has an AGGCOUNT.
  • ora-31218 : DBMS_LDAP: PL/SQL - Invalid LDAP deleteoldrdn.
  • ora-32842 : value for property string cannot be altered
  • ora-24321 : inconsistent parameters passed
  • ora-01299 : dictionary string corresponds to a different database incarnation
  • ora-27074 : unable to determine limit for open files
  • ora-36168 : (XSMXAGGR10) COUNTVAR variable workspace object must have the same dimensionality as workspace object
  • ora-24418 : Cannot open further sessions.
  • ora-01279 : db_files too large
  • ora-16219 : This database is not preparing to switch over.
  • ora-13901 : Object string was not found.
  • ora-40286 : remote operations not permitted on mining models
  • ora-01035 : ORACLE only available to users with RESTRICTED SESSION privilege
  • ora-14259 : table is not partitioned by Hash method
  • ora-01149 : cannot shutdown - file string has online backup set
  • ora-13338 : failure in reversing LRS polygon/collection geometry
  • ora-01424 : missing or illegal character following the escape character
  • ora-32154 : Anydata context not specified
  • ora-30625 : method dispatch on NULL SELF argument is disallowed
  • 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.