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 : 28-04-2017
ORA-16003

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

  • ora-29955 : error occurred in the execution of ODCIINDEXEXCHANGEPARTITION routine
  • ora-00983 : cannot audit or noaudit SYS user actions
  • ora-24359 : OCIDefineObject not invoked for a Object type or Reference
  • ora-24816 : Expanded non LONG bind data supplied after actual LONG or LOB column
  • ora-19113 : trace function called during evaluation: string
  • ora-08464 : input raw decimal data contains more than 42 digits
  • ora-00396 : error string required fallback to single-pass recovery
  • ora-03211 : The segment does not exist or is not in a valid state
  • ora-30655 : cannot select FOR UPDATE from external organized table
  • ora-31160 : max substitution group size string exceeded by "string" (string) for head element "string" (string)
  • ora-15001 : diskgroup "string" does not exist or is not mounted
  • ora-10269 : Don't do coalesces of free space in SMON
  • ora-09320 : szrfc: unable to obtain the list of valid OS roles
  • ora-38305 : object not in RECYCLE BIN
  • ora-24019 : identifier for string too long, should not be greater than string characters
  • ora-07507 : scgcm: unexpected lock status condition
  • ora-38772 : cannot add datafile 'string' - file could not be created
  • ora-28357 : password required to open the wallet
  • ora-16194 : Modifying DB_UNIQUE_NAME requires SID='*' qualifier
  • ora-12470 : NULL or invalid user label: string
  • ora-22892 : scoped table "string" does not exist in schema "string"
  • ora-32139 : Cannot write to the stream
  • ora-25185 : index column other than last can not be specified for INCLUDE clause
  • ora-12203 : TNS:unable to connect to destination
  • ora-30431 : refresh method must be ANY or INCREMENTAL or FORCE_FULL, not string
  • ora-32810 : foreign queue string is not registered
  • ora-19665 : size string in file header does not match actual file size of string
  • ora-07623 : smscre: $CRMPSC failure
  • ora-07221 : slspool: exec error, unable to start spooler program.
  • ora-10566 : Test recovery has used all the memory it can use
  • 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.