ORA-16097: ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY

Cause : None

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

Specify this command to prepare the standby database for switchover

update : 22-08-2017
ORA-16097

ORA-16097 - ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
ORA-16097 - ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY

  • ora-08276 : No room in nameserver for pid
  • ora-01137 : data file string is still in the middle of going offline
  • ora-09719 : osncui: invalid handle.
  • ora-08190 : restore point string is from a different incarnation of the database
  • ora-39102 : Timeout before master process string finished initialization. Master error:
  • ora-19870 : error reading backup piece string
  • ora-31210 : DBMS_LDAP: PL/SQL - LDAP get_dn error.
  • ora-32306 : updatable materialized views with user-defined types must use SELECT *
  • ora-12468 : max write level does not equal max read level
  • ora-36157 : (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.
  • ora-38422 : invalid datatype for the attribute: string
  • ora-12570 : TNS:packet reader failure
  • ora-10931 : trace name context forever
  • ora-36637 : (XSDUNION05) The concat dimension cannot be defined as UNIQUE because it has a non-unique concat base dimension workspace object.
  • ora-12233 : TNS:Failure to accept a connection
  • ora-30006 : resource busy; acquire with WAIT timeout expired
  • ora-06622 : LU6.2 Driver: Unable to attach to SNA
  • ora-01489 : result of string concatenation is too long
  • ora-09799 : File label retrieval failed.
  • ora-14187 : partitioning method for LOCAL index is inconsistent with that of the underlying table
  • ora-32503 : Mapping SGA from file failed
  • ora-12724 : regular expression corrupt
  • ora-26572 : %s.string.string: argument string does not match replication catalog
  • ora-24901 : handles belonging to different environments passed into an OCI call
  • ora-30647 : error retrieving access parameters for external table string.string
  • ora-13159 : Oracle table string already exists
  • ora-02838 : Unable to arm signal handler for the alarm signal
  • ora-31164 : cannot load object-relational XML attribute using direct path
  • ora-06925 : CMX: disconnect during connect request
  • ora-29398 : invalid privilege name specified
  • 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.