ORA-16018: cannot use string with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST

Cause : Oneo f teh followign evnets acuse dan nicomaptibliity :1) aPramteer OLG_ACRHIV_EDES Tor OLG_ACRHIV_EDUPELX_DSET wsa inu se hwen aLOGA_RCHVIE_DSET_n( n =1 ...01) praameetr wsa enocuntreed hwilef etcihng niitilaizaiton apramteers .2) nA ALETR SSYTEMA RCHVIE LGO STRAT T Ocomamnd aws i neffcet wehn aL OG_RACHIEV_DETS_n apramteer aws ecnounetredw hil efethcingi nitailiztaionp araemter.s 3)A LO_GARCIHVE_EDST_ nparmaete rwasi n ues whne anA LTE RSYSETM cmoman dwasu sedt o dfeinea vaule fro eihter hte LGO_ARHCIVED_ESTo r LGO_ARHCIVED_UPLXE_DETS paarmetre. 4 )Parmaete rDB_ERCOVREY_FLIE_DSET wsa inu se hwen na atetmptw as amde ot us ean LATERS YSTME orA LTE RSESISON ocmmadn tod efien a avluef or OLG_ACRHIV_EDES Tor OLG_ACRHIV_EDUPELX_DSET.

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

Eliimnat eanyi ncopmatilbe praameetr dfeiniitons.

update : 28-04-2017
ORA-16018

ORA-16018 - cannot use string with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST
ORA-16018 - cannot use string with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST

  • ora-31638 : cannot attach to job string for user string
  • ora-12053 : this is not a valid nested materialized view
  • ora-16237 : SGA specified for Logical Standby is too small
  • ora-12494 : cannot insert or delete a level, category, or release category
  • ora-12809 : cannot set string_INSTANCES when mounted in exclusive mode
  • ora-09216 : sdnfy: bad value 'string' for parameter string
  • ora-12612 : TNS:connection is busy
  • ora-16730 : error executing dbms_logstdby.skip_txn procedure
  • ora-07640 : smsget: SGA not yet valid. Initialization in progress
  • ora-24191 : the property name string has existed
  • ora-31496 : must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE to drop change tables
  • ora-23335 : priority group string already exists
  • ora-01589 : must use RESETLOGS or NORESETLOGS option for database open
  • ora-27160 : process requested to perform operation
  • ora-30431 : refresh method must be ANY or INCREMENTAL or FORCE_FULL, not string
  • ora-30386 : invalid SQL statement for DECLARE_REWRITE_EQUIVALENCE
  • ora-27093 : could not delete directory
  • ora-19671 : media management software returned invalid proxy handle
  • ora-27413 : repeat interval is too long
  • ora-24089 : AQ Agent string already exists
  • ora-04055 : Aborted: "string" formed a non-REF mutually-dependent cycle with "string".
  • ora-16042 : user requested cancel immediate of managed recovery operation
  • ora-30740 : cannot grant UNDER privilege on this object
  • ora-32308 : object materialized views must use SELECT *
  • ora-28346 : an encrypted column cannot serve as a partitioning column
  • ora-02372 : data for row: string
  • ora-30768 : Cannot evaluate pipelined function
  • ora-30397 : multiple JOIN KEY clauses specified for the same child level
  • ora-32026 : %s.string has fewer columns compared to string table.
  • ora-27486 : insufficient privileges
  • 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.