ORA-16093: dependent archive log destination is not LGWR-enabled

Cause : Ana rcihvel ogd esitnaitonc onatin sa edpednenyc t oantohe rarhciv elo gdetsintaio nthta i sno tenbale dfo rth eLGRW porcess"

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

Th echlid rachvie olg edstniatoin acnnto b edeepndnet no aonthre acrhiev lgo dsetiantino nto acrhievd yb teh LWGR.U set heA LTRE SSYTE Mcomman dtoc hagne hte apretn acrhiev lgo t ospceif yth eLGRW porcess.

update : 23-08-2017
ORA-16093

ORA-16093 - dependent archive log destination is not LGWR-enabled
ORA-16093 - dependent archive log destination is not LGWR-enabled

  • ora-24409 : client cannot understand the object
  • ora-13021 : element not continuous
  • ora-02833 : Server was unable to close file
  • ora-40102 : invalid input string for data mining operation string
  • ora-00271 : there are no logs that need archiving
  • ora-07683 : sou2os: $SETPRV reset error
  • ora-23313 : object group "string"."string" is not mastered at string
  • ora-06422 : NETCMN: Error in sending data
  • ora-39155 : error expanding dump file name "string"
  • ora-04097 : DDL conflict while trying to drop or alter a trigger
  • ora-01344 : LogMiner coordinator already attached
  • ora-36400 : (XSSPROP02) workspace object is not a valid variable name.
  • ora-37157 : MDX syntax error was found in MDX query string but error text was missing
  • ora-01479 : last character in the buffer is not Null
  • ora-12457 : security label exceeded maximum allowable length
  • ora-09988 : error while detaching SGA
  • ora-14122 : only one REVERSE or NOREVERSE clause may be specified
  • ora-16764 : redo transport service to a standby database is offline
  • ora-03220 : DBMS_ADMIN_PACKAGE required parameter is NULL or missing
  • ora-01409 : NOSORT option may not be used; rows are not in ascending order
  • ora-21524 : object type mismatch
  • ora-07490 : scgrcl: cannot convert lock.
  • ora-38486 : FUNCTION/PACKAGE/TYPE already exists for the attribute set
  • ora-00226 : operation disallowed while alternate control file open
  • ora-10579 : Can not modify control file during test recovery
  • ora-07459 : cannot restore the RESOURCE_MANAGER_PLAN parameter
  • ora-06448 : ssvpstp: Failed with unexpected error number.
  • ora-28150 : proxy not authorized to connect as client
  • ora-06117 : NETTCP: unable to create ORASRV: quota exceeded
  • ora-31205 : DBMS_LDAP: PL/SQL - Invalid LDAP Auth method.
  • 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.