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 : 30-04-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-03203 : concurrent update activity makes space analysis impossible
  • ora-13049 : unable to determine tolerance value from table _SDODIM
  • ora-19569 : no device is allocated to this session
  • ora-00397 : instance recovery process terminated with error
  • ora-02230 : invalid ALTER CLUSTER option
  • ora-19321 : Could not open HTTP connection to host (string): port (string)
  • ora-19232 : XQ0012 - imported schemas violate validity rules
  • ora-32762 : Turn on Temp LOB Ref Count Tracing
  • ora-29853 : keyword UNIQUE may not be used in creating domain indexes
  • ora-24129 : table name string does not start with string prefix
  • ora-22628 : OCIAnyData already constructed
  • ora-30078 : partition bound must be TIME/TIMESTAMP WITH TIME ZONE literals
  • ora-12805 : parallel query server died unexpectedly
  • ora-39958 : invalid warning category qualifier
  • ora-07577 : no such user in authorization file
  • ora-26740 : cannot downgrade because there are file groups
  • ora-27141 : invalid process ID
  • ora-39211 : unable to retrieve dumpfile information as specified
  • ora-00117 : PROTOCOL, ADDRESS or DESCRIPTION must be specified
  • ora-15080 : synchronous I/O operation to a disk failed
  • ora-25469 : data not specified for alias: string column name: string
  • ora-12670 : Incorrect role password
  • ora-22807 : cannot resolve to a scalar type or a collection type
  • ora-01344 : LogMiner coordinator already attached
  • ora-31688 : Worker process string failed during startup.
  • ora-38440 : attribute set string does not exist
  • ora-36682 : (XSDPART20) Partition name string appears twice.
  • ora-12223 : TNS:internal limit restriction exceeded
  • ora-36665 : (XSDPART03) workspace object is not in the dimension list of the PARTITION TEMPLATE.
  • ora-01109 : database not open
  • 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.