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 : 26-04-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-22891 : cannot have multiple columns in REF constraint
  • ora-02368 : file string is not valid for this load operation
  • ora-07454 : queue timeout, string second(s), exceeded
  • ora-27061 : waiting for async I/Os failed
  • ora-23606 : invalid object string
  • ora-06779 : TLI Driver: error reading ccode
  • ora-04030 : out of process memory when trying to allocate string bytes (string,string)
  • ora-19691 : %s is from different database: id=string, name=string
  • ora-32831 : timed out trying to acquire administration lock
  • ora-31468 : cannot process DDL change record
  • ora-38767 : flashback retention target parameter mismatch
  • ora-38472 : VARCHAR representation of the data item is too long.
  • ora-09837 : addCallback: could not add allocate a callback link.
  • ora-04022 : nowait requested, but had to wait to lock dictionary object
  • ora-14137 : Table in partially dropped state, submit DROP TABLE PURGE
  • ora-13711 : Some snapshots in the range [string, string] are missing key statistics.
  • ora-29387 : no top-plans found in the pending area
  • ora-16595 : NetSlave process string failed to terminate
  • ora-06568 : obsolete ICD procedure called
  • ora-19762 : invalid file type string
  • ora-02174 : Missing required thread number
  • ora-02225 : only EXECUTE and DEBUG privileges are valid for procedures
  • ora-22323 : error table "string"."string" does not exist
  • ora-01563 : rollback segment is PUBLIC, need to use the keyword PUBLIC
  • ora-06557 : null values are not allowed for any parameters to pipe icd's
  • ora-02306 : cannot create a type that already has valid dependent(s)
  • ora-00983 : cannot audit or noaudit SYS user actions
  • ora-01763 : update or delete involves outer joined table
  • ora-16558 : the database specified for switchover is not a standby database
  • ora-31640 : unable to open dump file "string" for read
  • 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.