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 : 17-08-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-33076 : (XSAGDNGL37) In AGGMAP workspace object, the value 'number' is not a valid value of dimension workspace object.
  • ora-09767 : osnmfs: bad return code from msg_send.
  • ora-25146 : EXTENT MANAGEMENT option already specified
  • ora-29533 : attempt to overwrite class or resource string while defining or compiling string.string
  • ora-06107 : NETTCP: ORACLE network server not found
  • ora-04022 : nowait requested, but had to wait to lock dictionary object
  • ora-16208 : Logical standby dictionary build failed to start.
  • ora-30933 : Element 'string' may not appear at this point within parent 'string'
  • ora-29382 : validation of pending area failed
  • ora-26051 : internal error parsing packed decimal format string
  • ora-06042 : NETDNT: message receive failure
  • ora-31652 : command response message was invalid type - detaching job
  • ora-09937 : Chmod of ORACLE password file failed.
  • ora-12735 : Instant Client Light: unsupported client character set string
  • ora-14120 : incompletely specified partition bound for a DATE column
  • ora-06447 : ssvpstp: Incorrect parameter passed to function call
  • ora-38777 : database must not be started in any other instance.
  • ora-24195 : attemp to retrieve the name list of a map message with size exceeding 1024
  • ora-19614 : archivelog thread string sequence string not found in backup set
  • ora-13047 : unable to determine ordinate count from table _SDOLAYER
  • ora-16137 : No terminal recovery is required
  • ora-12653 : Authentication control function failed
  • ora-19110 : unsupported XQuery expression
  • ora-12703 : this character set conversion is not supported
  • ora-14299 : total number of partitions/subpartitions exceeds the maximum limit
  • ora-28501 : communication error on heterogeneous database link
  • ora-29816 : object being disassociated is not present
  • ora-00343 : too many errors, log member closed
  • ora-39143 : dump file "string" may be an original export dump file
  • ora-39174 : Encryption password must be supplied.
  • 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.