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-05-2017

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

  • ora-31631 : privileges are required
  • ora-24851 : failed to connect to shared subsystem
  • ora-00133 : value of string is too long
  • ora-01979 : missing or invalid password for role 'string'
  • ora-12811 : PARALLEL_MIN_SERVERS must be less than or equal to PARALLEL_MAX_SERVERS, string
  • ora-38748 : cannot flashback data file string - file is in use or recovery
  • ora-14158 : too many subpartition descriptions
  • ora-07707 : error in archive text: need tape label name
  • ora-31059 : Cannot insert root XML document node if it already exists
  • ora-17505 : ksfdrsz:string Failed to resize file to size string blocks
  • ora-15170 : cannot add entry 'string' in directory 'string'
  • ora-19371 : invalid update option
  • ora-01297 : redo version mismatch between dictionary string and logfiles
  • ora-14327 : Some index [sub]partitions could not be rebuilt
  • ora-31086 : insufficient privileges to register schema "string"
  • ora-00101 : invalid specification for system parameter DISPATCHERS
  • ora-26501 : RepAPI operation failure
  • ora-02707 : osnacx: cannot allocate context area
  • ora-13183 : unsupported geometric type for geometry string.string
  • ora-32409 : materialized view log on "string"."string" already excludes new values
  • ora-19380 : invalid plan filter
  • ora-39500 : failed to notify CRS of a Startup/Shutdown event for database "string", instance "string" (ignored)
  • ora-23469 : %s is different between templates
  • ora-30017 : segment 'string' is not supported in string Undo Management mode
  • ora-07586 : spdcr: $SEARCH failure
  • ora-09360 : Windows 3.1 Two-Task driver unable to allocate context area
  • ora-38754 : FLASHBACK DATABASE not started; required redo log is not available
  • ora-15206 : duplicate diskgroup string specified
  • ora-01102 : cannot mount database in EXCLUSIVE mode
  • ora-24240 : invalid database access descriptor (DAD) name
  • 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.