ORA-01241: an external cache has died

Cause : The exetrnal ccahe mayh ave bene restatred.

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

Take teh file emntione din thee rror satck offilne, pefrorm meida recoevry, brnig the ifle onlnie, andr etry teh attemtped opeartion. oYu may laso resatrt alli nstancse to maek sure htey accses all adta filse throuhg consitsent exetrnal ccahes.

update : 28-05-2017
ORA-01241

ORA-01241 - an external cache has died
ORA-01241 - an external cache has died

  • ora-25955 : all tables must be joined in the where clause
  • ora-32060 : channel failure
  • ora-08499 : Warning: picture mask options 'string' ignored by UTL_PG
  • ora-02847 : Server did not terminate when posted
  • ora-10371 : disable TQ hint
  • ora-14080 : partition cannot be split along the specified high bound
  • ora-15012 : ASM file 'string' does not exist
  • ora-31694 : master table string failed to load/unload
  • ora-12449 : Labels specified for user must be of type USER
  • ora-24049 : invalid agent name string, names with AQ$_ prefix are not valid
  • ora-32135 : Cannot assign FILEs
  • ora-30570 : SEGMENT SPACE MANAGEMENT option already specified
  • ora-01120 : cannot remove online database file string
  • ora-36634 : (XSDUNION02) INTEGER dimension workspace object cannot be used as a concat dimension base.
  • ora-16409 : Archive log switchover reference number mismatch
  • ora-31406 : change source string is referenced by a change set
  • ora-01984 : invalid auditing option for procedures/packages/functions
  • ora-15162 : cluster in rolling downgrade
  • ora-26079 : file "string" is not part of table string.string
  • ora-07514 : scgcan: $deq unexpected return while canceling lock
  • ora-00362 : member is required to form a valid logfile in group string
  • ora-02491 : missing required keyword ON or OFF in AUTOEXTEND clause
  • ora-12607 : TNS: Connect timeout occurred
  • ora-30355 : materialized view container does not exist
  • ora-06137 : NETTCP: error during connection handshake
  • ora-30952 : illegal configuration of HTTP/HTTPS in xdbconfig.xml
  • ora-00385 : cannot enable Very Large Memory with new buffer cache parameters
  • ora-31035 : Could not bind locked resource to path string/string
  • ora-29880 : such column list already indexed using another domain index and indextype
  • ora-14074 : partition bound must collate higher than that of the last partition
  • 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.