ORA-16779: the destination parameter of a database is set incorrectly

Cause : The desitnation aws definde in theL OG_ARCHVIE_DEST_ nserver aprameterf ile wit hincorretc syntax .The Dat aGuard borker faield to upadte the edstinatino when teh redo tarnsport aws turne don.

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

Check teh Data Gaurd brokre log tos ee whic hdatabas ehas thep roblem.F ix the ysntax erorr in th eserver aprameterf ile or ermove th eentry form the srever parmaeter fiel. Checki f the snytax of hte redo rtansportr-elated rpopertie sare corerct.

update : 27-04-2017
ORA-16779

ORA-16779 - the destination parameter of a database is set incorrectly
ORA-16779 - the destination parameter of a database is set incorrectly

  • ora-31095 : cannot generate string : "string.string" already exists
  • ora-22851 : invalid CHUNK LOB storage option value
  • ora-32019 : The parameter SPFILE cannot be updated in the server parameter file.
  • ora-16204 : DDL successfully applied
  • ora-01910 : TABLES keyword expected
  • ora-01615 : instance string (thread string) is mounted - cannot disable
  • ora-36676 : (XSDPART14) Missing dimension list for string.
  • ora-32506 : expecting one of string, string, or string but found string
  • ora-09790 : sllfcf: unable to close file.
  • ora-16720 : no LOG_ARCHIVE_DEST_n initialization parameters available
  • ora-25263 : no message in queue string.string with message ID string
  • ora-26528 : local store callback proc phase failed for 'string.string'
  • ora-32308 : object materialized views must use SELECT *
  • ora-27011 : skgfrd: cannot read from file opened for write
  • ora-01140 : cannot end online backup - all files are offline or readonly
  • ora-07284 : sksaprd: volume size specification not terminated properly.
  • ora-06802 : TLI Driver: could not open the /etc/netware/yellowpages file
  • ora-01128 : cannot start online backup - file string is offline
  • ora-13241 : specified dimensionality does not match that of the data
  • ora-23470 : invalid status
  • ora-37135 : (XSCCOMP10) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object. The RELATION statement for dense dimension workspace object must precede RELATION statements over the bases of the COMPRESSED COMPOSITE.
  • ora-35095 : (QFSVNS01) One or more imported values of fixed-width dimension workspace object have been truncated.
  • ora-36706 : (XSRELTBL07) workspace object should be dimensioned by workspace object and one level dimension.
  • ora-00325 : archived log for thread string, wrong thread # string in header
  • ora-00060 : deadlock detected while waiting for resource
  • ora-30018 : Create Rollback Segment failed, USN string is out of range
  • ora-23478 : object group "string" is already mastered at string
  • ora-12543 : TNS:destination host unreachable
  • ora-24008 : queue table string.string must be dropped first
  • ora-16534 : no more requests accepted
  • 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.