ORA-16185: REMOTE_ARCHIVE_ENABLE and LOG_ARCHIVE_CONFIG mutually exclusive

Cause : Boht teh RMEOT_EARHCIV_EENBALEa ndL OGA_RCIHVEC_ONIFG apraemtesr aer dfeinde i nth eintiiailzaitonf il ean dthye aer mtuually xeclsuiv.e

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

Th eREOMTEA_RCIHVEE_NALBE apraemte rha sbene mdae bosoelte .Us eonyl teh LGO_ACRHIEV_CNOFI Gpaarmeetr.

update : 29-06-2017
ORA-16185

ORA-16185 - REMOTE_ARCHIVE_ENABLE and LOG_ARCHIVE_CONFIG mutually exclusive
ORA-16185 - REMOTE_ARCHIVE_ENABLE and LOG_ARCHIVE_CONFIG mutually exclusive

  • ora-27473 : argument string does not exist
  • ora-28330 : encryption is not allowed for this data type
  • ora-29311 : export dump file was not generated by this database, string does not match
  • ora-29501 : invalid or missing Java source, class, or resource name
  • ora-13917 : Posting system alert with reason_id string failed with code [string] [string]
  • ora-36930 : Cannot start a recursive call to Oracle OLAP because a ROLLBACK past an UPDATE to an attached analytic workspace has been performed.
  • ora-29514 : class name contains illegal character
  • ora-12872 : First slave parse gave different plan
  • ora-24230 : input to DBMS_DDL.WRAP is not a legal PL/SQL unit
  • ora-12544 : TNS:contexts have different wait/test functions
  • ora-16252 : Rebuild operation not permitted
  • ora-19689 : cannot have more than one %F in control file autobackup format(string) for string
  • ora-31053 : The value of the depth argument in the operator cannot be negative
  • ora-01511 : error in renaming log/data files
  • ora-16061 : Log file status has changed
  • ora-02828 : Segment free list is empty
  • ora-16095 : Dependent destination removal for inactivation
  • ora-30359 : Query rewrite is not supported on SYS materialized views
  • ora-40102 : invalid input string for data mining operation string
  • ora-16647 : could not start more than one observer
  • ora-01945 : DEFAULT ROLE[S] already specified
  • ora-02161 : invalid value for MAXLOGFILES
  • ora-02055 : distributed update operation failed; rollback required
  • ora-36180 : (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.
  • ora-01799 : a column may not be outer-joined to a subquery
  • ora-12071 : definition query of "string"."string" is invalid for offline instantiation
  • ora-14100 : partition extended table name cannot refer to a remote object
  • ora-03124 : two-task internal error
  • ora-36163 : (XSMXAGGR06) The AGGREGATE function cannot be run on more than one variable at a time.
  • ora-26725 : cannot downgrade apply handlers
  • 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.