ORA-16087: graceful switchover requires standby or current control file

Cause : A nattepmtw a smdaet op efromr agarcfeu lsiwthcoevro preaito nuisn gab akcu po rcoln ecnotorlf iel.

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

Cnovrett h ebcakpu ocnrto lfliei not acrurnetc otnrlo ifl epiro rt oattepmtniga rgaecflu wsicthvoe roeprtaino.A lcoen ocnrto lfliec anno tb euesdf o rag rcaeufls wticohvre poeartoin.

update : 28-05-2017
ORA-16087

ORA-16087 - graceful switchover requires standby or current control file
ORA-16087 - graceful switchover requires standby or current control file

  • ora-00443 : background process "string" did not start
  • ora-00036 : maximum number of recursive SQL levels (string) exceeded
  • ora-36635 : (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition.
  • ora-28004 : invalid argument for function specified in PASSWORD_VERIFY_FUNCTION string
  • ora-29886 : feature not supported for domain indexes
  • ora-39502 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-19259 : XQ0039 - duplicate parameter name string in function declaration
  • ora-09714 : Two Task interface: cannot obtain puname
  • ora-32013 : failure in verifying parameters from the restored SPFILE
  • ora-16059 : Log file is empty or invalid next available block
  • ora-28530 : Heterogeneous Services initialization error in NLS language ID
  • ora-29501 : invalid or missing Java source, class, or resource name
  • ora-38101 : Invalid column in the INSERT VALUES Clause: string
  • ora-29267 : illegal call
  • ora-19600 : input file is string string (string)
  • ora-24007 : invalid value string, MAX_RETRIES should be non-negative integer
  • ora-32580 : both SYS and SYSTEM passwords must be provided
  • ora-13862 : Statistics aggregation for client identifier string is not enabled
  • ora-29375 : sum of values string for level string, plan string exceeds string
  • ora-16403 : shutdown in progress - remote connection is not permitted
  • ora-30445 : workload queries not found
  • ora-13141 : invalid RANGE window definition
  • ora-16017 : cannot use LOG_ARCHIVE_DUPLEX_DEST without a primary archive destination
  • ora-15050 : disk "string" contains string error(s)
  • ora-19616 : output filename must be specified if database not mounted
  • ora-06001 : NETASY: port set-up failure
  • ora-06318 : IPA: Local maximum number of connections exceeded
  • ora-28513 : internal error in heterogeneous remote agent
  • ora-01181 : file string created before last known RESETLOGS, cannot recreate
  • ora-12322 : unable to mount database (link name string)
  • 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.