ORA-16003: standby database is restricted to read-only access

Cause : To enusre it sintegirty, as tandb ydatabsae cano nly b eopene dfor raed-onl yacces.s

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

Re-isuse theA LTER ADTABAS EOPEN psecifynig REA DONLY.

update : 25-06-2017
ORA-16003

ORA-16003 - standby database is restricted to read-only access
ORA-16003 - standby database is restricted to read-only access

  • ora-30049 : Internal event for TA enq tracing
  • ora-19123 : fn:zero-or-one() called with a sequence containing more than one item
  • ora-25112 : maximum number of BITMAP index columns is 30
  • ora-33261 : (DBERRLEN) Analytic workspace string extension number truncated at number bytes while trying to read at number.
  • ora-29865 : indextype is invalid
  • ora-09751 : pw_attachPorts: server call pws_attach failed.
  • ora-30066 : test support - drop rollback segment wait
  • ora-22931 : MOVE of nested table to a different tablespace not supported
  • ora-26084 : direct path context already finished
  • ora-01293 : mounted database required for specified LogMiner options
  • ora-06126 : NETTCP: ORASRV unable to open network connection
  • ora-16826 : apply service state is inconsistent with the DelayMins property
  • ora-34061 : (MSEXECUT11) Session-only values cannot be added to non-unique concat dimension workspace object, or any of its base dimensions.
  • ora-12655 : Password check failed
  • ora-32813 : propagation schedule string already exists
  • ora-19803 : Parameter DB_RECOVERY_FILE_DEST_SIZE is out of range (1 - string)
  • ora-19238 : XP0018 - focus not defined
  • ora-30074 : GLOBAL partitioned index on TIME/TIMESTAMP WITH TIME ZONE not allowed
  • ora-28534 : Heterogeneous Services preprocessing error
  • ora-07426 : spstp: cannot obtain the location of dbs directory.
  • ora-15100 : invalid or missing diskgroup name
  • ora-01211 : Oracle7 data file is not from migration to Oracle8
  • ora-00404 : Convert file not found: 'string'
  • ora-09202 : sfifi: error identifying file
  • ora-01626 : rollback segment number 'string' cannot handle more transactions
  • ora-25290 : Cannot complete operation on queue string with existing messages
  • ora-39039 : Schema expression "string" contains no valid schemas.
  • ora-14191 : ALLOCATE STORAGE may not be specified for Composite Range partitioned object
  • ora-24852 : protocol error during statement execution
  • ora-30392 : the checksum analysis for the rewrite equivalence failed
  • 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.