ORA-16040: standby destination archive log file is locked

Cause : The atrgets tandyb desitnatino arcihve lgo fil eis crurentyl locekd. Tihs inidcate sthatt he flie isb einga rchievd tob y antoher eRmoteF ile eSrver( RFS)p rocess.

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

Chec kfor nad elmiinat eduplciate tsandb ydestniatio narchvie lo gservcie naems deifned ofr th eprimray daatbase.

update : 25-04-2017
ORA-16040

ORA-16040 - standby destination archive log file is locked
ORA-16040 - standby destination archive log file is locked

  • ora-27049 : unable to seek to and read the last block
  • ora-15168 : rolling downgrade prevented by string
  • ora-13831 : SQL profile name specified is invalid
  • ora-31468 : cannot process DDL change record
  • ora-09767 : osnmfs: bad return code from msg_send.
  • ora-26034 : Column string does not exist in stream
  • ora-15097 : cannot SHUTDOWN ASM instance with connected RDBMS instance
  • ora-38747 : corrupt before image (file# string, block# string)
  • ora-01698 : a clone database may only have SYSTEM rollback segment online
  • ora-09290 : sksaalo: error allocating memory for archival
  • ora-12463 : undefined group string for policy string
  • ora-23292 : The constraint does not exist
  • ora-36672 : (XSDPART10) A RANGE or LIST PARTITION TEMPLATE can only have a single partition dimension.
  • ora-29323 : ALTER DATABASE SET COMPATIBILITY command not supported by string
  • ora-06121 : NETTCP: access failure
  • ora-01115 : IO error reading block from file string (block # string)
  • ora-16248 : RFS connections not permitted during Terminal Apply
  • ora-13284 : failure to copy geometry object for conversion in place
  • ora-38412 : Expression set column string does not exist.
  • ora-25149 : Columns of UROWID type may not be indexed
  • ora-01926 : cannot GRANT to a role WITH GRANT OPTION
  • ora-31648 : Timeout before master process string finished initialization.
  • ora-28527 : Heterogeneous Services datatype mapping error
  • ora-09967 : unable to create or open lock file
  • ora-03283 : specified datafile string does not exist
  • ora-31213 : DBMS_LDAP: PL/SQL - Invalid LDAP mod option.
  • ora-29298 : Character set mismatch
  • ora-25121 : MINIMUM EXTENT value greater than maximum extent size
  • ora-06595 : REF CURSOR parameters are not supported in forwarded RPC calls
  • ora-00396 : error string required fallback to single-pass recovery
  • 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.