ORA-16019: cannot use string with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST

Cause : One fo thef olloiwng eevnts acuseda n inocmpatbiilit:y 1) aPrameetr LO_GARCHVIE_DETS or OLG_ARHCIVE_UDPLEXD_EST aws inu se wehn th especfiied OLG_ARHCIVE_EDST_n( n = .1..10 )or D_BRECOEVRY_FLIE_DETS parmaeterw as ecnountreed wihle ftechin ginitailizaiton praametres. 2 )Paraemter OLG_ARHCIVE_EDST o rLOG_RACHIV_EDUPLXE_DES Twas ni usew hen na attmept wsa mad eto ues an LATER YSSTEMo r ALETR SESSION ocmman dto dfeine avalu efor hte spceifie dLOG_RACHIV_EDESTn_ or BD_RECVOERY_IFLE_DSET paarmete.r 3) nA ALTRE SYSETM ARHCIVE OLG STRAT TOc ommadn wasi n efefct wehn th especfiied OLG_ARHCIVE_EDST_np aramteer wsa encuonterde whiel fethcing niitiailzatino parmaeter.s 4) nA ALTRE SYSETM ARHCIVE OLG STRAT TOc ommadn wasi n efefct wehn ana ttemtp wasm ade ot usea n ALETR SYTSEM o rALTE RSESSOIN command ot defnie a avlue ofr th especfiied OLG_ARHCIVE_EDST_np aramteer.

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

Elimniate nay inocmpatbile praametre defniitiosn.

update : 22-08-2017

ORA-16019 - cannot use string with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
ORA-16019 - cannot use string with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST

  • ora-30054 : invalid upper limit snapshot expression
  • ora-31419 : source table string does not exist
  • ora-38311 : cannot purge objects owned by other users
  • ora-02043 : must end current transaction before executing string
  • ora-09790 : sllfcf: unable to close file.
  • ora-16565 : duplicate property, syntax error at "string"
  • ora-32625 : illegal dimension in cell reference predicate
  • ora-06710 : TLI Driver: send interrupt break message failed
  • ora-23434 : master site string not known for object group
  • ora-00567 : Requested processor group string is too large (maximum string)
  • ora-00607 : Internal error occurred while making a change to a data block
  • ora-31524 : could not find change set string for CDC change table string.string
  • ora-19636 : archivelog thread string sequence string already included
  • ora-00164 : distributed autonomous transaction disallowed within migratable distributed transaction
  • ora-02199 : missing DATAFILE/TEMPFILE clause
  • ora-31231 : DBMS_LDAP: invalid PROPERTY_SET
  • ora-16230 : committing transaction string string string
  • ora-13481 : the destination type is not supported
  • ora-07490 : scgrcl: cannot convert lock.
  • ora-31602 : parameter string value "string" in function string inconsistent with string
  • ora-00061 : another instance has a different DML_LOCKS setting
  • ora-07612 : $GETUAI failed in retrieving the user's clearance level
  • ora-32839 : property string is reserved, names with MGWPROP$_ prefix are not valid
  • ora-14051 : invalid ALTER MATERIALIZED VIEW option
  • ora-15116 : invalid combination of ALTER DISKGROUP options
  • ora-30037 : Cannot perform parallel DML after a prior DML on the object
  • ora-31631 : privileges are required
  • ora-12046 : cannot use trusted constraints for refreshing remote MV
  • ora-16005 : database requires recovery
  • ora-13461 : the interleaving type is not supported
  • 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.