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 : 30-04-2017
ORA-16769

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

  • ora-36850 : (XSLMGEN20) View token string is not correct
  • ora-22328 : object "string"."string" has errors. string
  • ora-31524 : could not find change set string for CDC change table string.string
  • ora-38862 : FLASHBACK DATABASE in progress
  • ora-36312 : (PHYS00) workspace object must be a dimension or dimensioned variable.
  • ora-16595 : NetSlave process string failed to terminate
  • ora-32641 : invalid expression in MODEL rule ORDER BY clause
  • ora-30102 : 'string' is not in the legal range for 'string'
  • ora-30682 : improper value for argument OPTION_FLAGS
  • ora-02773 : Invalid maximum client wait time
  • ora-19588 : %s recid string stamp string is no longer valid
  • ora-12817 : parallel query option must be enabled
  • ora-07605 : szprv: $ASCTOID failure
  • ora-26098 : direct path context is not prepared
  • ora-36710 : (XSMXALLOC01) TARGETLOG variable workspace object must be dimensioned identically to TARGET variable workspace object.
  • ora-09844 : soacon: Archmon unable to open named pipe.
  • ora-19881 : Corrupted space bitmap for datafile string, block string backup aborted
  • ora-16622 : two or more broker database objects resolve to one physical database
  • ora-06301 : IPA: Cannot allocate driver context
  • ora-12345 : user string lacks CREATE SESSION privilege in database link (linkname string)
  • ora-39062 : error creating master process string
  • ora-23467 : flavor lacks object "string"."string"
  • ora-01755 : Must specify an extent number or block number
  • ora-06922 : CMX: bad write length
  • ora-01595 : error freeing extent (string) of rollback segment (string))
  • ora-13841 : SQL profile named string already exists for a different signature/category pair
  • ora-14400 : inserted partition key does not map to any partition
  • ora-14041 : partition bound may not be specified for resulting partitions
  • ora-13917 : Posting system alert with reason_id string failed with code [string] [string]
  • ora-30029 : no active undo tablespace assigned to instance
  • 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.