ORA-16769: the physical standby database is open read-only

Cause : All isntance sin th ephysiacl stadnby daatbase ewre pu tinto aread-noly sttae insetad ofL OG-APLPY-OFF.

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

Issuet he se tstatec omman dto moev the adtabas eto LO-GAPPLYO-FF sttae.

update : 29-06-2017

ORA-16769 - the physical standby database is open read-only
ORA-16769 - the physical standby database is open read-only

  • ora-01151 : use media recovery to recover block, restore backup if needed
  • ora-13053 : maximum number of geometric elements in argument list exceeded
  • ora-23487 : object groups "string"."string" and "string"."string" do not have the same connection qualifier
  • ora-08451 : invalid specification of DB in picture mask
  • ora-25252 : listen failed, the address string is a non-persistent queue
  • ora-30685 : package version is not compatible with Oracle version
  • ora-29892 : indextypes with array DML do not support the given data type
  • ora-31447 : cannot create change tables in the SYS schema
  • ora-19750 : change tracking file: 'string'
  • ora-19558 : error de-allocating device
  • ora-31608 : specified object of type string not found
  • ora-26667 : invalid STREAMS parameter string
  • ora-15182 : ASMLIB [string] version mismatch, ORACLE version [string]
  • ora-16618 : response document of size "string" bytes is too large
  • ora-09778 : snynfyport: failure allocating the notify port.
  • ora-23352 : duplicate destination for deferred transaction
  • ora-19723 : Cannot recreate plugged in read-only datafile string
  • ora-07454 : queue timeout, string second(s), exceeded
  • ora-07449 : sc: usnewlock failed.
  • ora-16260 : Waiting to replace partial or corrupt logfile (thread# string, sequence# string)
  • ora-02403 : plan table does not have correct format
  • ora-31526 : could not find source table string.string for CDC change table string.string
  • ora-28180 : multiple authentication methods provided by proxy
  • ora-38201 : assert if pin during flush
  • ora-13786 : missing SQL text of statement object "string" for tuning task "string"
  • ora-32341 : The EXPLAIN_MVIEW facility failed to explain the materialized view "string"."string"
  • ora-28501 : communication error on heterogeneous database link
  • ora-13342 : an arc geometry has fewer than three coordinates
  • ora-30365 : left relation in the JOIN KEY clause cannot be same as right
  • ora-02025 : all tables in the SQL statement must be at the remote database
  • 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.