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 : 29-05-2017

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

  • ora-09321 : slzdtb: unable to convert zoned decimal to binary
  • ora-06561 : given statement is not supported by package DBMS_SQL
  • ora-00301 : error in adding log file 'string' - file cannot be created
  • ora-13379 : invalid index for sub-element to be extracted
  • ora-19592 : wrong string conversation type
  • ora-23617 : Block string for script string has already been executed
  • ora-01927 : cannot REVOKE privileges you did not grant
  • ora-01166 : file number string is larger than string (string)
  • ora-00125 : connection refused; invalid presentation
  • ora-12335 : database (link name string) is not open
  • ora-06257 : NETNTT: cannot send command line to shadow process
  • ora-14276 : EXCHANGE SUBPARTITION requires a non-partitioned, non-clustered table
  • ora-02246 : missing EVENTS text
  • ora-01267 : Failure getting date/time
  • ora-00372 : file string cannot be modified at this time
  • ora-31640 : unable to open dump file "string" for read
  • ora-29968 : No primary operator bindings found for ancillary binding #string
  • ora-00352 : all logs for thread string need to be archived - cannot enable
  • ora-09959 : IMON: deletion of a process failed.
  • ora-02791 : Unable to open file for use with asynchronous I/O
  • ora-25139 : invalid option for CREATE TEMPORARY TABLESPACE
  • ora-24234 : unable to get source of string "string"."string", insufficient privileges or does not exist
  • ora-04077 : WHEN clause cannot be used with table level triggers
  • ora-07339 : spcre: maximum number of semaphore sets exceeded.
  • ora-31093 : null or invalid value specified for parameter : string
  • ora-04021 : timeout occurred while waiting to lock object stringstringstringstringstring
  • ora-22850 : duplicate LOB storage option specificed
  • ora-26744 : STREAMS capture process "string" does not support "string"."string" because of the following reason: string
  • ora-24784 : Transaction exists
  • ora-14076 : submitted alter index partition/subpartition operation is not valid for local partitioned index
  • 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.