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 : 26-06-2017
ORA-16108

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

  • ora-34871 : (PERMIT06) Session-only value 'value' of workspace object has been deleted because a PERMIT change has revealed a duplicate value.
  • ora-06263 : NETNTT: out of memory in pi_connect
  • ora-07860 : osnsoi: error setting up interrupt handler
  • ora-28514 : heterogeneous database link initialization could not convert system date
  • ora-30563 : outer join operator (+) not allowed in select-list
  • ora-31193 : This versioning feature isn't supported for resource string
  • ora-01291 : missing logfile
  • ora-30351 : query rewrite does not currently support this expression
  • ora-19500 : device block size string is invalid
  • ora-29340 : export file appears to be corrupted: [string] [string] [string]
  • ora-36848 : (XSLMGEN18) Dimension string.string!string is missing a COLUMNNAME property value
  • ora-14123 : duplicate NOREVERSE clause
  • ora-01755 : Must specify an extent number or block number
  • ora-00398 : abort thread recovery due to reconfiguration
  • ora-34360 : (MXDSS15) number other users writing
  • ora-09793 : szguns: length of user name is greater than buffer.
  • ora-19707 : invalid record block number - string
  • ora-02020 : too many database links in use
  • ora-12152 : TNS:unable to send break message
  • ora-19238 : XP0018 - focus not defined
  • ora-01536 : space quota exceeded for tablespace 'string'
  • ora-30179 : invalid argument index used in a format code
  • ora-31627 : API call succeeded but more information is available
  • ora-14256 : invalid resulting partition description(s)
  • ora-37003 : (AWLISTALL01) number readers
  • ora-28561 : unable to set date format on non-Oracle system
  • ora-14458 : attempt was made to create a temporary table with INDEX organization
  • ora-02484 : Invalid _trace_buffers parameter specification (string)
  • ora-06903 : CMX: cannot read transport address of remote application
  • ora-19683 : real and backup blocksize of file string are unequal
  • 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.