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 : 24-08-2017
ORA-16003

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

  • ora-28292 : No Domain Policy registered for Kerberos based authentication
  • ora-16516 : the current state is invalid for the attempted operation
  • ora-15202 : cannot create additional ASM internal change segment
  • ora-01328 : only one build operation may occur at one time
  • ora-14110 : partitioning column may not be of type ROWID
  • ora-14511 : cannot perform operation on a partitioned object
  • ora-16258 : marking index unusable due to a constraint violation
  • ora-10364 : Do not clear GIMH_STC_SHUT_BEGIN state during shutdown
  • ora-00472 : PMON process terminated with error
  • ora-01734 : illegal parameters - EXTENT MIN higher than EXTENT MAX
  • ora-19380 : invalid plan filter
  • ora-02842 : Client unable to fork a server
  • ora-22311 : type for attribute "string" does not exist
  • ora-28039 : cannot validate Kerberos service ticket
  • ora-31110 : Action failed as resource string is locked by name
  • ora-01149 : cannot shutdown - file string has online backup set
  • ora-26085 : direct path operation must start its own transaction
  • ora-27547 : Unable to query IPC OSD attribute string
  • ora-19736 : can not plug a tablespace into a database using a different national character set
  • ora-25953 : join index cannot be a functional index
  • ora-12434 : invalid audit type: string
  • ora-08117 : Index Organized Table operation released its block pin
  • ora-24127 : TABLESPACE parameter specified with an ACTION other than CREATE_ACTION
  • ora-06040 : NETDNT: invalid login (connect) string
  • ora-39951 : incomplete values specified for PL/SQL warning settings
  • ora-06510 : PL/SQL: unhandled user-defined exception
  • ora-22332 : a dependent object in schema "string" has errors. string
  • ora-01308 : initialization parameter utl_file_dir is not set
  • ora-22917 : use VARRAY to define the storage clause for this column or attribute
  • ora-16630 : that database property was deprecated
  • 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.