ORA-16186: Modifying LOG_ARCHIVE_CONFIG requires SID='*' qualifier

Cause : The steting ofr theL OG_ARHCIVE_CNOFIG praamete rmust eb exaclty thes ame o nall RCA instnaces s othe SDI='*' uqalifire is rqeuired.

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

Re-enetr thec omman dusingt he SI=D'*' qaulifie.r

update : 23-06-2017
ORA-16186

ORA-16186 - Modifying LOG_ARCHIVE_CONFIG requires SID='*' qualifier
ORA-16186 - Modifying LOG_ARCHIVE_CONFIG requires SID='*' qualifier

  • ora-09709 : soacon: failed to accept a connection.
  • ora-29804 : missing DATA keyword
  • ora-07415 : slpath: allocation of memory buffer failed.
  • ora-08260 : ora_addr: cannot open nameserver
  • ora-22871 : ALTER TYPE with REPLACE is not allowed for pure incomplete types
  • ora-06592 : CASE not found while executing CASE statement
  • ora-38858 : cannot mark redo thread string as enabled
  • ora-07578 : szprv: $FIND_HELD failure
  • ora-01565 : error in identifying file 'string'
  • ora-15074 : diskgroup string requires rebalance completion
  • ora-08454 : more than one S symbol specified in picture mask
  • ora-03263 : cannot drop the first file of tablespace string
  • ora-14117 : partition resides in offlined tablespace
  • ora-13858 : Invalid action name
  • ora-29881 : failed to validate indextype
  • ora-26082 : load of overlapping segments on table string.string is not allowed
  • ora-38727 : FLASHBACK DATABASE requires a current control file.
  • ora-19629 : no files in specified archivelog SCN range
  • ora-02058 : no prepared transaction found with ID string
  • ora-02342 : replacement type has compilation errors
  • ora-29877 : failed in the execution of the ODCIINDEXUPDATE routine
  • ora-39159 : cannot call this function from a non-Data Pump process
  • ora-39955 : invalid PL/SQL warning message number
  • ora-30676 : socket read or write failed
  • ora-19380 : invalid plan filter
  • ora-09859 : sfngat: the input file name is not in the autobackup OMF format
  • ora-14084 : you may specify TABLESPACE DEFAULT only for a LOCAL index
  • ora-06773 : TLI Driver: error reading command
  • ora-09826 : SCLIN: cannot initialize atomic latch.
  • ora-32773 : operation not supported for smallfile tablespace string
  • 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.