ORA-16074: ARCH processes must be active

Cause : There are no active ARCH processes.

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

It is required that at least one ARCH process be active.

update : 26-04-2017

ORA-16074 - ARCH processes must be active
ORA-16074 - ARCH processes must be active

  • ora-13353 : ELEM_INFO_ARRAY not grouped in threes
  • ora-24780 : cannot recover a transaction while in an existing transaction
  • ora-09367 : Windows 3.1 Two-Task driver unable to deallocate shared memory
  • ora-30042 : Cannot offline the undo tablespace
  • ora-07443 : function string not found
  • ora-00122 : cannot initialize network configuration
  • ora-16632 : instance being added to database profile
  • ora-29963 : missing BINDING keyword
  • ora-13129 : HHCODE column string not found
  • ora-24750 : incorrect size of attribute
  • ora-07716 : sksachk: invalid device specification for ARCHIVE
  • ora-16223 : DDL skipped, unsupported in current version
  • ora-23409 : could not find an unused refresh group number
  • ora-25001 : cannot create this trigger type on views
  • ora-31092 : invalid SQL name "string"
  • ora-07263 : sptpa: kill error.
  • ora-30395 : dimension options require the COMPATIBLE parameter to be string or greater
  • ora-12461 : undefined level string for policy string
  • ora-14634 : Subpartition descriptions cannot be specified during the SPLIT/MERGE of a partition of a Range-List partitioned table
  • ora-06592 : CASE not found while executing CASE statement
  • ora-28581 : protocol error while executing recursive external procedure
  • ora-01113 : file string needs media recovery
  • ora-13191 : failed to read SDO_ORDCNT value
  • ora-02479 : error while translating file name for parallel load
  • ora-25004 : WHEN clause is not allowed in INSTEAD OF triggers
  • ora-06548 : no more rows needed
  • ora-09292 : sksabln: unable to build archive file name
  • ora-06536 : IN bind variable bound to an OUT position
  • ora-01121 : cannot rename database file string - file is in use or recovery
  • ora-16021 : session string destination cannot be the same as session string destination
  • 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.