ORA-16236: Logical Standby metadata operation in progress

Cause : The requested operation failed because a Logical Standby metadata operation, such as DBMS_LOGSTDBY.SET_TABLESPACE or DBMS_LOGSTDBY.INSTANTIATE_TABLE, has not finished.

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

Wait for the Logical Standby metadata operation to finish, then re-enter or respecify the operation.

update : 26-09-2017
ORA-16236

ORA-16236 - Logical Standby metadata operation in progress
ORA-16236 - Logical Standby metadata operation in progress

  • ora-22346 : Type has cyclical dependency. Should use CASCADE option
  • ora-14501 : object is not partitioned
  • ora-03231 : the INITIAL extent may not be deallocated
  • ora-30192 : reserved for future use
  • ora-13109 : spatial table string exists
  • ora-00282 : UPI string call not supported, use ALTER DATABASE RECOVER
  • ora-33024 : (XSAGDNGL11) AGGMAP workspace object contains duplicate information.
  • ora-13797 : invalid SQL Id specified, string
  • ora-12514 : TNS:listener does not currently know of service requested in connect descriptor
  • ora-13061 : topology with the name string does not exist
  • ora-29531 : no method string in class string
  • ora-19679 : RMAN configuration number string is outside valid range of 1 through string
  • ora-13158 : Oracle object string does not exist
  • ora-30959 : The indexed column is not stored in CLOB.
  • ora-09218 : sfrfs: failed to refresh file size
  • ora-12805 : parallel query server died unexpectedly
  • ora-00972 : identifier is too long
  • ora-02210 : no options specified for ALTER TABLE
  • ora-31050 : Access denied
  • ora-06142 : NETTCP: error getting user information
  • ora-12063 : unable to apply transaction from site string
  • ora-07201 : slhom: oracle_home variable not set in environment.
  • ora-39168 : Object path string was not found.
  • ora-26688 : missing key in LCR
  • ora-31058 : cannot modify read-only XOBs
  • ora-22952 : Nested Table equality requires a map method on the element ADT
  • ora-06005 : NETASY: dialogue file read failure
  • ora-25266 : didnt try to dequeue by message id. with the signature
  • ora-13787 : missing SQL profile for statement object "string" for tuning task "string"
  • ora-01686 : max # files (string) reached for the tablespace string
  • 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.