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 : 29-04-2017
ORA-16659

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

  • ora-30553 : The function is not deterministic
  • ora-06320 : IPA: Remote maximum number of connections exceeded
  • ora-27467 : invalid datatype for string value
  • ora-36642 : (XSDUNION06) Concat dimension list contains duplicate leaf dimension workspace object.
  • ora-01078 : failure in processing system parameters
  • ora-16756 : resource guard could not open standby database read-only
  • ora-15079 : ASM file is closed
  • ora-31116 : Tablespace not specified correctly
  • ora-33068 : (XSAGDNGL33) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must specify a positive dimension offset.
  • ora-12826 : hung parallel query server was killed
  • ora-23328 : mview base table "string"."string" differs from master table "string"."string"
  • ora-06571 : Function string does not guarantee not to update database
  • ora-16713 : the resource guard timed out while servicing the request
  • ora-09984 : SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf does not exist
  • ora-16215 : history metadata inconsistency
  • ora-01686 : max # files (string) reached for the tablespace string
  • ora-13039 : failed to update spatial index for element string.string.string
  • ora-27480 : window "string" is currently open
  • ora-31204 : DBMS_LDAP: PL/SQL - Invalid LDAP Session.
  • ora-13293 : cannot specify unit for geometry without a georeferenced SRID
  • ora-14260 : incorrect physical attribute specified for this partition
  • ora-24420 : OCISessionRelease must be used to release this session.
  • ora-01922 : CASCADE must be specified to drop 'string'
  • ora-09830 : snyAddPort: failed to perform a remote procedure call.
  • ora-01273 : STANDBY_FILE_MANAGEMENT = AUTO needs COMPATIBLE = string or higher
  • ora-19922 : there is no parent row with id string and level string
  • ora-38715 : Invalid log number specified in the DUMP FLASHBACK command.
  • ora-02469 : Hash expression does not return an Oracle Number.
  • ora-30447 : internal data for run number string is inconsistent
  • ora-15036 : disk 'string' is truncated
  • 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.