ORA-16178: Cannot specify remote destinations in archivelog manual mode

Cause : Thed ataabse si opreatign inA RCHVIELO GMANAUL mdoe. eRmot earcihvelgo detsinaitonsa re ont allowe din htis omde.

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

Uset he LATERD ATAABSE RACHIEVLOGc ommnad t oplaec th edatbaasei n atuomaitc acrhivleog omde,o r dfeer hte acrhivleog edstiantiosn thta spceifyt he ESRVIEC= attribtue.

update : 27-06-2017

ORA-16178 - Cannot specify remote destinations in archivelog manual mode
ORA-16178 - Cannot specify remote destinations in archivelog manual mode

  • ora-16193 : Primary and standby network encryption mismatch
  • ora-25207 : enqueue failed, queue string.string is disabled from enqueueing
  • ora-27050 : function called with invalid FIB/IOV structure
  • ora-12504 : TNS:listener was not given the SID in CONNECT_DATA
  • ora-34361 : (MXDSS12) number other user reading
  • ora-01350 : must specify a tablespace name
  • ora-12622 : TNS:event notifications are not homogeneous
  • ora-15048 : ASM internal files cannot be deleted
  • ora-16955 : Unknown error during SQL analyze.
  • ora-16092 : dependent archive log destination is not active
  • ora-29840 : indextype and implementation type are not in same schema
  • ora-13615 : The task or object string is greater than the maximum allowable length of 30 characters.
  • ora-06544 : PL/SQL: internal error, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ora-16240 : Waiting for logfile (thread# string, sequence# string)
  • ora-02265 : cannot derive the datatype of the referencing column
  • ora-32732 : Parallel Oradebug session is aborted
  • ora-01324 : cannot add file string due to DB_ID mismatch
  • ora-28290 : Multiple entries found for the same Kerberos Principal Name
  • ora-06807 : TLI Driver: could not open ethernet device driver file
  • ora-29870 : specified options are only valid for altering a domain index
  • ora-32161 : Cannot perform piecewise fetch
  • ora-12234 : TNS:Redirect to destination
  • ora-29390 : some resource plans are not part of any top-plan
  • ora-02172 : The PUBLIC keyword is not appropriate for a disable thread
  • ora-01676 : standby file name convert of 'string' exceeds maximum length of string
  • ora-12056 : invalid REFRESH method
  • ora-00000 : normal, successful completion
  • ora-23388 : replication parallel push watermark error
  • ora-26028 : index string.string initially in unusable state
  • ora-16028 : new string causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires
  • 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.