ORA-16719: unable to query V$ARCHIVE_DEST fixed view

Cause : The broker failed to query the V$ARCHIVE_DEST fixed view."

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

Test and clear the problem using SQL*Plus.

update : 27-06-2017

ORA-16719 - unable to query V$ARCHIVE_DEST fixed view
ORA-16719 - unable to query V$ARCHIVE_DEST fixed view

  • ora-06031 : NETDNT: connect failed, unrecognized object name
  • ora-30967 : operation directly on the Path Table is disallowed
  • ora-03127 : no new operations allowed until the active operation ends
  • ora-01105 : mount is incompatible with mounts by other instances
  • ora-16629 : database reports a different protection level from the protection mode
  • ora-01716 : NOSORT may not be used with a cluster index
  • ora-29513 : referenced class name too long
  • ora-23540 : Redefinition not defined or initiated
  • ora-01967 : invalid option for CREATE CONTROLFILE
  • ora-35066 : (QFGET03) Extension number number is missing for EIF file string.
  • ora-00363 : log is not the archived version
  • ora-38411 : invalid datatype for the column storing expressions
  • ora-15171 : invalid syntax in the alias path after 'string'
  • ora-02285 : duplicate START WITH specifications
  • ora-16045 : circular archive log destination dependency chain
  • ora-07627 : smsfre: $CRETVA failure
  • ora-25206 : enqueue failed, enqueue to exception queue string.string not permitted
  • ora-02804 : Allocation of memory failed for log file name
  • ora-00382 : %s not a valid block size, valid range [string..string]
  • ora-32609 : missing REFERENCE keyword in MODEL clause
  • ora-12168 : TNS:Unable to contact LDAP Directory Server
  • ora-16570 : operation requires restart of database "string"
  • ora-13012 : an invalid window type was specified
  • ora-14455 : attempt to create referential integrity constraint on temporary table
  • ora-30477 : The input select_clause is incorrectly specified
  • ora-25470 : duplicate attribute value for variable: string
  • ora-01522 : file 'string' to be renamed does not exist
  • ora-29804 : missing DATA keyword
  • ora-26529 : local store callback term phase failed for 'string.string'
  • ora-14111 : creation of a GLOBAL partitioned index on clustered tables is not supported
  • 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.