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 : 20-08-2017
ORA-16186

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

  • ora-16205 : DDL skipped due to skip setting
  • ora-01372 : Insufficient processes for specified LogMiner operation
  • ora-01478 : array bind may not include any LONG columns
  • ora-12318 : database (link name string) is already mounted
  • ora-06402 : NETCMN: error receiving break message
  • ora-00027 : cannot kill current session
  • ora-12001 : cannot create log: table 'string' already has a trigger
  • ora-01632 : max # extents (string) reached in index string.string
  • ora-16232 : adding Logical Standby skip entry for table string.string
  • ora-00404 : Convert file not found: 'string'
  • ora-12529 : TNS:connect request rejected based on current filtering rules
  • ora-38706 : Cannot turn on FLASHBACK DATABASE logging.
  • ora-02446 : CREATE TABLE ... AS SELECT failed - check constraint violated
  • ora-38428 : too many attributes selected for indexing
  • ora-02211 : invalid value for PCTFREE or PCTUSED
  • ora-10706 : Print out information about global enqueue manipulation
  • ora-10244 : make tranids in error msgs print as 0.0.0 (for testing)
  • ora-12224 : TNS:no listener
  • ora-14603 : [SUBPARTITIONS | SUBPARTITION TEMPLATE] subpartition_count syntax is valid only for range-hash tables
  • ora-31083 : error while creating SQL type "string"."string"
  • ora-28347 : encryption properties mismatch
  • ora-32136 : Cannot perform operation on an invalid stream
  • ora-16958 : DML statements running parallel are not supported for test execute.
  • ora-08208 : ora_addr: cannot read from address file
  • ora-26521 : rpc initialization error
  • ora-02255 : obsolete 7.1.5
  • ora-07249 : slsget: open error, unable to open /proc/pid.
  • ora-13784 : cannot accept SQL profiles for all statements in the "SQL Tuning Set"
  • ora-29865 : indextype is invalid
  • ora-10924 : import storage parse error ignore event
  • 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.