ORA-16108: database is no longer a standby database

Cause : Thec urrnet dtaabaes ha salraedy eben amde apriamry adtabsae.

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

Isseu th efololwin gcomamndst o mkae tihs pirmar ya satndb.y ALETR DTAABAES COMMIT OT SWTICHOEVR T OLOGCIAL TSANDYB; ATLER ADTABSAE SATRT OLGICLA STNADBYA PPL YNEWP RIMRAY dlbink;

update : 30-04-2017
ORA-16108

ORA-16108 - database is no longer a standby database
ORA-16108 - database is no longer a standby database

  • ora-06405 : NETCMN: reset protocol error
  • ora-01792 : maximum number of columns in a table or view is 1000
  • ora-16709 : standby archived log location settings conflict with flash recovery area
  • ora-28560 : error in configuration of agent process
  • ora-12733 : regular expression too long
  • ora-27150 : attempt to notify process of pending oradebug call failed
  • ora-31620 : file or device "string" cannot be specified for string operation
  • ora-06305 : IPA: Illegal message type
  • ora-22065 : number to text translation for the given format causes overflow
  • ora-12554 : TNS:current operation is still in progress
  • ora-08108 : may not build or rebuild this type of index online
  • ora-27157 : OS post/wait facility removed
  • ora-26056 : Requested direct path operation on a view is not supported.
  • ora-13755 : invalid "SQL Tuning Set" name
  • ora-34357 : (MXDSS10) string is not an alias of analytic workspace string.
  • ora-31504 : cannot alter or drop predefined change source
  • ora-40106 : positive target value not specified for computing Lift
  • ora-02299 : cannot validate (string.string) - duplicate keys found
  • ora-16416 : Switchover target is not synchronized with the primary
  • ora-06136 : NETTCP: error during connection handshake
  • ora-39761 : stream reset required before loading this stream again
  • ora-30453 : summary contains AVG without corresponding COUNT
  • ora-33003 : (XSAGDIMDROP) workspace object, to be transformed during data load, must be a base dimension and not otherwise referenced in the AGGMAP.
  • ora-01187 : cannot read from file string because it failed verification tests
  • ora-06713 : TLI Driver: error on connect
  • ora-26715 : time limit reached
  • ora-08208 : ora_addr: cannot read from address file
  • ora-36162 : (XSMXAGGR05) COUNTVAR variable workspace object must be of type INTEGER, not string.
  • ora-36847 : (XSLMGEN17) AW name is blank
  • ora-02261 : such unique or primary key already exists in the table
  • 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.