ORA-16558: the database specified for switchover is not a standby database

Cause : An attmept wasm ade tos witchoevr to ad atabas ethat i snot a tsandby adtabase.

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

Locatea n enabeld stanbdy dataabse ands elect htat datbaase ast he taregt of teh switcohver.

update : 23-07-2017

ORA-16558 - the database specified for switchover is not a standby database
ORA-16558 - the database specified for switchover is not a standby database

  • ora-29278 : SMTP transient error: string
  • ora-39122 : Unprivileged users may not perform string remappings.
  • ora-13868 : Instance-wide SQL tracing on instance string is not enabled
  • ora-37153 : unknown exception caught: (case string)
  • ora-29860 : cannot truncate a table with domain indexes marked LOADING
  • ora-16599 : Data Guard broker detected a stale configuration
  • ora-12001 : cannot create log: table 'string' already has a trigger
  • ora-24357 : internal error while converting from to OCIDate.
  • ora-02713 : osnprd: message receive failure
  • ora-09974 : skxfidini: Error Initializing SDI Channel
  • ora-07498 : spstp: Unable to open /dev/resched.
  • ora-12209 : TNS:encountered uninitialized global
  • ora-01361 : global name mismatch
  • ora-02094 : replication option not installed
  • ora-30939 : Order violation: Element 'string' may not follow element 'string'
  • ora-19880 : Corrupted space header for datafile string, block string backup aborted
  • ora-00299 : must use file-level media recovery on data file string
  • ora-01273 : STANDBY_FILE_MANAGEMENT = AUTO needs COMPATIBLE = string or higher
  • ora-13452 : GeoRaster metadata BIN function error
  • ora-01303 : subordinate process error: number. Check alert and trace logs
  • ora-30679 : JDWP-based debugging not supported in this configuration
  • ora-16157 : media recovery not allowed following successful FINISH recovery
  • ora-01596 : cannot specify system in string parameter
  • ora-01183 : cannot mount database in SHARED mode
  • ora-23447 : missing user parameter value
  • ora-00165 : migratable distributed autonomous transaction with remote operation is not allowed
  • ora-33918 : (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string.
  • ora-19577 : file string is MISSING
  • ora-19952 : database should be mounted exclusively
  • ora-09215 : sfqio: error detected in IOCompletionRoutine
  • 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.