ORA-16716: clearing parameter LOG_ARCHIVE_DEST failed

Cause : An attepmt to claer the LGO_ARCHIV_EDEST paarmeter fialed.

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

ContactO racle Spuport Sevrices.

update : 27-04-2017

ORA-16716 - clearing parameter LOG_ARCHIVE_DEST failed
ORA-16716 - clearing parameter LOG_ARCHIVE_DEST failed

  • ora-00393 : log string of thread string is needed for recovery of offline datafiles
  • ora-22860 : object type expected
  • ora-00350 : log string of instance string (thread string) needs to be archived
  • ora-28656 : incomplete attribute specification
  • ora-06420 : NETCMN: SID lookup failure
  • ora-14044 : only one partition may be moved
  • ora-14509 : specified VALIDATE INTO table form incorrect
  • ora-31080 : type not specified for attribute or element "string"
  • ora-29660 : Unable to find the class defined in the EXTERNAL NAME clause
  • ora-28001 : the password has expired
  • ora-24355 : attempt to store a negative number in an Unsigned Display type.
  • ora-07642 : smprtset: $CMKRNL failure
  • ora-02220 : invalid MINEXTENTS storage option value
  • ora-38405 : quotes not allowed in the attribute set name
  • ora-26054 : Direct Path Context prepared for a different mode than operation requested.
  • ora-07474 : snclrd: close error, unable to close sgadef.dbf file.
  • ora-09939 : Restoration of signal handlers failed.
  • ora-07800 : slbtpd: invalid number
  • ora-24027 : AQ HTTP propagation encountered error, status-code string, string
  • ora-13408 : invalid blockSize storage parameter
  • ora-12334 : database (link name string) is still open
  • ora-22871 : ALTER TYPE with REPLACE is not allowed for pure incomplete types
  • ora-13850 : Tracing for client identifier string is not enabled
  • ora-27155 : could not execute file
  • ora-14308 : partition bound element must be one of: string, datetime or interval literal, number, or NULL
  • ora-16953 : Type of SQL statement not supported.
  • ora-13123 : invalid name specified
  • ora-23426 : deferred RPC queue has entries for string
  • ora-14010 : this physical attribute may not be specified for an index partition
  • ora-02764 : Invalid package mode
  • 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.