ORA-29741: IMR active for some, but not all members of cluster

Cause : Teh MIRf etauer si onta citv efro hti sisntnac,e ubti sa citv efro naohte risntnac ei nteh lcutse rdtaaabs.e

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

Esnuer hta tall nisatnecsh aev htes aem avleu ofrt h e_mira_citv eiinto.r apraaemtre

update : 23-07-2017
ORA-29741

ORA-29741 - IMR active for some, but not all members of cluster
ORA-29741 - IMR active for some, but not all members of cluster

  • ora-16172 : archive logs detected beyond Terminal End-Of-Redo
  • ora-37004 : (AWLISTALL02) number reader
  • ora-30961 : internal SQL statement is too long
  • ora-06035 : NETDNT: connect failed, insufficient resources
  • ora-16711 : the resource guard index is out of bounds
  • ora-06307 : IPA: Cannot reset connection
  • ora-08193 : Flashback Table operation is not allowed on temporary tables
  • ora-29297 : The compressed representation is too big
  • ora-25137 : Data value out of range
  • ora-12923 : tablespace string is in force logging mode
  • ora-04021 : timeout occurred while waiting to lock object stringstringstringstringstring
  • ora-02396 : exceeded maximum idle time, please connect again
  • ora-22929 : invalid or missing directory name
  • ora-22878 : duplicate LOB partition or subpartition specified
  • ora-32141 : get method does not match the type of the parameter
  • ora-10665 : Inject Evil Literals
  • ora-01266 : Unable to create unique file name
  • ora-39098 : Worker process received data objects while loading metadata. Invalid process order range is string..string
  • ora-02728 : osnfop: access error on oracle executable
  • ora-24047 : invalid agent name string, agent name should be of the form NAME
  • ora-30120 : 'string' is not a legal oracle number for 'string'
  • ora-39784 : This direct path operation is not allowed while another is in progress
  • ora-36182 : (XSAGGR09) Could not locate a value for variable number in measure dimension workspace object.
  • ora-03208 : partitioned type must be specified for a non-composite object
  • ora-19001 : Invalid storage option specified
  • ora-31207 : DBMS_LDAP: PL/SQL - Invalid LDAP search time value.
  • ora-30770 : Cannot specify storage options for fixed size opaque type
  • ora-17504 : ksfddel:Failed to delete file string
  • ora-14320 : DEFAULT cannot be specified for ADD/DROP VALUES or SPLIT
  • ora-14160 : this physical attribute may not be specified for a table subpartition
  • 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.