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 : 27-05-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-14185 : incorrect physical attribute specified for this index partition
  • ora-13411 : subset results in null data set
  • ora-13147 : failed to generate MBR
  • ora-32135 : Cannot assign FILEs
  • ora-03298 : cannot shrink datafile - file string is under hot backup
  • ora-36290 : (EIFMAKEF14) You cannot export object workspace object, because EIFVERSION is set to number. That version does not support dimensions of type NUMBER.
  • ora-02701 : osnoraenv: error translating oracle image name
  • ora-01902 : SEGMENT keyword expected
  • ora-28545 : error diagnosed by Net8 when connecting to an agent
  • ora-32592 : all columns in log group can not be no log columns
  • ora-29392 : cpu parameters for level string for plan string must be zero
  • ora-02445 : Exceptions table not found
  • ora-16559 : out of memory at string
  • ora-31186 : Document contains too many nodes
  • ora-00484 : LMS* process terminated with error
  • ora-12464 : invalid characters in label component string
  • ora-16583 : bad Data Guard Connection Process DRCX state
  • ora-15170 : cannot add entry 'string' in directory 'string'
  • ora-06029 : NETASY: port assignment failure
  • ora-24357 : internal error while converting from to OCIDate.
  • ora-23291 : Only base table columns may be renamed
  • ora-30753 : column or table string is substitutable
  • ora-32159 : Cannot set prefetch options for a null Type
  • ora-30106 : reserved for future use
  • ora-22610 : error while adding a scalar to the image handle
  • ora-00447 : fatal error in background process
  • ora-23362 : invalid user
  • ora-00071 : process number must be between 1 and string
  • ora-16124 : transaction string string string is waiting on another transaction
  • ora-22298 : length of directory alias name or file name too long
  • 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.