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 : 30-04-2017

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

  • ora-15007 : name is already used by an existing template
  • ora-29844 : duplicate operator name specified
  • ora-07684 : sou2os: supervisor stack reset error
  • ora-30396 : rewrite equivalence procedures require the COMPATIBLE parameter to be string or greater
  • ora-19380 : invalid plan filter
  • ora-32515 : cannot issue ORADEBUG command; waited number ms for process string
  • ora-28267 : Invalid NameSpace Value
  • ora-15026 : disk 'string' is not an ASM disk
  • ora-30732 : table contains no user-visible columns
  • ora-14119 : specified partition bound is too long
  • ora-09851 : soacon: Archmon unable to lock named pipe.
  • ora-21522 : attempted to use an invalid connection in OCI (object mode only)
  • ora-14113 : partitioned table cannot have column with LOB datatype
  • ora-13497 : %s
  • ora-30051 : VERSIONS clause not allowed here
  • ora-00820 : Specified value of sga_max_size is too small, needs to be at least stringM
  • ora-36640 : (XSDUNION19) Concat dimension workspace object cannot be changed to UNIQUE because base dimension workspace object does not have a TEXT or ID datatype.
  • ora-25285 : Invalid value string for array_mode
  • ora-39062 : error creating master process string
  • ora-07254 : spdcr: translation error while expanding ?/bin/oracle.
  • ora-24049 : invalid agent name string, names with AQ$_ prefix are not valid
  • ora-26690 : datatype not supported at non-Oracle system
  • ora-09857 : smprset: vm_protect error while protecting pga.
  • ora-31479 : could not create LogMiner session
  • ora-24401 : cannot open further connections
  • ora-01356 : active logminer sessions found
  • ora-13797 : invalid SQL Id specified, string
  • ora-19228 : XP0008 - undeclared identifier: prefix 'string' local-name 'string'
  • ora-30013 : undo tablespace 'string' is currently in use
  • ora-00910 : specified length too long for its datatype
  • 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.