ORA-16659: failover operation in progress

Cause : A primray dataabse tha trestaretd contcated a tsandby adtabaset hat isb eing fialed ovre to.

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

Shutdonw the pirmary dtaabase nad waitf or faiolver toc omplet eon thes tandbyd atabas.e Once afiloveri s compelte, retsart th eold prmiary daatbase. fI the fialover cocurredd ue to aFst-Statr Failoevr, resatrting hte primray dataabse aftre failoevr is cmoplete iwll allwo it tob e autoamticall yreinsttaed as astandb ydatabaes to th enew prmiary daatbase.

update : 20-08-2017
ORA-16659

ORA-16659 - failover operation in progress
ORA-16659 - failover operation in progress

  • ora-02028 : fetching an exact number of rows is not supported by the server
  • ora-02143 : invalid STORAGE option
  • ora-00288 : to continue recovery type ALTER DATABASE RECOVER CONTINUE
  • ora-30182 : invalid precision specifier
  • ora-36698 : (XSRELTBL03) QDR dimension workspace object should be in the dimension list that dimensions the relation.
  • ora-31652 : command response message was invalid type - detaching job
  • ora-29706 : incorrect value string for parameter ACTIVE_INSTANCE_COUNT
  • ora-25190 : an index-organized table maintenance operation may not be combined with other operations
  • ora-27165 : tried to join thread that does not exist
  • ora-16745 : unable to add DB_UNIQUE_NAME string into the DG_CONFIG list because it is full
  • ora-13603 : The specified parameter string cannot be fetched as a numeric value for task or object string.
  • ora-12442 : policy column "string" already used by an existing policy
  • ora-16624 : broker protocol version mismatch detected
  • ora-01271 : Unable to create new file name for file string
  • ora-28580 : recursive external procedures are not supported
  • ora-00305 : log string of thread string inconsistent; belongs to another database
  • ora-00017 : session requested to set trace event
  • ora-31005 : Path name length string exceeds maximum length string
  • ora-16244 : taking checkpoint and paging out string bytes to disk
  • ora-27153 : wait operation failed
  • ora-31418 : source schema string does not exist
  • ora-30434 : refresh method must be one of FC?AN, not 'string'
  • ora-37038 : (XSMLTDCL04) You cannot change definitions of objects in analytic workspace string because it is attached in MULTI mode.
  • ora-00473 : ARCH process terminated with error
  • ora-39032 : function string is not supported in string jobs
  • ora-06575 : Package or function string is in an invalid state
  • ora-24362 : improper use of the character count flag
  • ora-12073 : request cannot be processed
  • ora-25439 : duplicate variable value for variable: string
  • ora-00568 : Maximum number of interrupt handlers exceeded
  • 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.