ORA-16772: error switching over between primary and standby databases

Cause : There was an error during switchover of primary and standby databases.

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

Check the Data Guard broker log and Oracle alert log for more details.

update : 26-04-2017

ORA-16772 - error switching over between primary and standby databases
ORA-16772 - error switching over between primary and standby databases

  • ora-31501 : change source string is not an AutoLog change source
  • ora-24370 : illegal piecewise operation attempted
  • ora-10661 : Invalid option specified
  • ora-27152 : attempt to post process failed
  • ora-01926 : cannot GRANT to a role WITH GRANT OPTION
  • ora-09936 : Open of ORACLE password file for write failed.
  • ora-25440 : invalid table alias: string
  • ora-23606 : invalid object string
  • ora-14264 : table is not partitioned by Composite Range method
  • ora-06745 : TLI Driver: listener already running
  • ora-27207 : syntax error in device PARMS - parentheses mismatch or missing
  • ora-03262 : the file is non-empty
  • ora-02080 : database link is in use
  • ora-12834 : Instance group name, 'string', too long, must be less than string characters
  • ora-02320 : failure in creating storage table for nested table column string
  • ora-00357 : too many members specified for log file, the maximum is string
  • ora-35078 : (QFHEAD05) An EIF extension file header for string is not in the correct format.
  • ora-17502 : ksfdcre:string Failed to create file string
  • ora-31086 : insufficient privileges to register schema "string"
  • ora-31016 : Attempted to delete entry without name
  • ora-02184 : resource quotas are not allowed in REVOKE
  • ora-12842 : Cursor invalidated during parallel execution
  • ora-13865 : Module name must be specified
  • ora-19600 : input file is string string (string)
  • ora-00295 : datafile/tempfile number string is invalid, must be between 1 and string
  • ora-13288 : point coordinate transformation error
  • ora-39061 : import mode string conflicts with export mode string
  • ora-28341 : cannot encrypt constraint column(s) with salt
  • ora-31219 : DBMS_LDAP: PL/SQL - Invalid LDAP notypes.
  • ora-40273 : invalid model type string for Adaptive Bayes Network algorithm
  • 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.