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 : 23-07-2017

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

  • ora-06774 : TLI Driver: error sending break mode
  • ora-32604 : invalid REBUILD option
  • ora-07616 : $CHANGE_CLASS failed in retrieving the specified device label
  • ora-16180 : number processes specified for MAX_PARALLEL_SERVERS is too small
  • ora-40104 : invalid training data for model build
  • ora-19720 : Error occurred when converting an OCI number into an SCN
  • ora-12233 : TNS:Failure to accept a connection
  • ora-13382 : geometry metadata (table:string column:string) not found in spatial network:string
  • ora-19234 : XQ0014 - invalid or unsupported must-understand extension
  • ora-13771 : cannot obtain exclusive lock string on "SQL Tuning Set" "string" owned by user "string"
  • ora-24015 : cannot create QUEUE_TABLE, QUEUE_PAYLOAD_TYPE string.string does not exist
  • ora-24330 : internal OCI error
  • ora-36861 : (XSTFRC01) SQL Cache ID parameter is invalid or missing.
  • ora-12677 : Authentication service not supported by database link
  • ora-01118 : cannot add any more database files: limit of string exceeded
  • ora-09975 : kxfspini: Error Initializing SDI Process
  • ora-29367 : object string does not exist
  • ora-13014 : a topology identifier outside the range of 1 to 8 was specified
  • ora-16083 : LogMiner session has not been created
  • ora-16530 : invalid buffer or length
  • ora-19576 : datafile string not defined in control file
  • ora-10917 : TABLESPACE GROUP cannot be specified
  • ora-30737 : cannot create subtable of a type which is not a subtype of the type of the supertable
  • ora-01327 : failed to exclusively lock system dictionary as required by build
  • ora-07488 : scgrcl: lock manager not initialized.
  • ora-23400 : invalid materialized view name "string"
  • ora-07228 : rtecho: unable to restore terminal to echo mode.
  • ora-00212 : block size string below minimum required size of string bytes
  • ora-37104 : (XSVPART04) A partitioned variable must be dimensioned by a single partition template only.
  • ora-00383 : DEFAULT cache for blocksize string cannot be reduced to zero
  • 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.