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 : 22-07-2017
ORA-16074

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

  • ora-22323 : error table "string"."string" does not exist
  • ora-07481 : snlmatt: cannot attach to lock manager instance.
  • ora-28515 : cannot get external object definitions from string
  • ora-13276 : internal error [string] in coordinate transformation
  • ora-14329 : domain index [sub]partitions cannot be renamed in this clause
  • ora-06775 : TLI Driver: error reading break mode
  • ora-02721 : osnseminit: cannot create semaphore set
  • ora-12728 : invalid range in regular expression
  • ora-12446 : Insufficient authorization for administration of policy string
  • ora-31700 : Very long string supplied for AUDIT_SYSLOG_LEVEL parameter
  • ora-23318 : a ddl failure has occurred
  • ora-32602 : FREEPOOLS and FREELIST GROUPS cannot be used together
  • ora-27003 : cannot open file on device allocated with NOIO option
  • ora-30456 : 'string.string' cannot be refreshed because of insufficient privilege
  • ora-16784 : the database name in Dependency property is incorrect
  • ora-29804 : missing DATA keyword
  • ora-39962 : invalid parameter for PLSQL_CCFLAGS
  • ora-06255 : NETNTT: cannot read pid of remote process
  • ora-32761 : Turn off Temp LOB Ref Count Feature
  • ora-16538 : no match on requested item
  • ora-02372 : data for row: string
  • ora-19256 : XQ0036 - missing type definitions in imported module
  • ora-22875 : cannot drop primary key of an object table whose object identifier is primary key based
  • ora-16660 : FSFO operation attempted in absence of a broker configuration
  • ora-01327 : failed to exclusively lock system dictionary as required by build
  • ora-29851 : cannot build a domain index on more than one column
  • ora-12628 : TNS:no event callbacks
  • ora-29518 : name string resolved to an object in schema string that is not a Java class
  • ora-25205 : the QUEUE string.string does not exist
  • ora-29824 : operator is invalid
  • 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.