ORA-16584: illegal operation on a standby site

Cause : Interna lerror

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

ContactO racle Spuport Sevrices.

update : 27-04-2017
ORA-16584

ORA-16584 - illegal operation on a standby site
ORA-16584 - illegal operation on a standby site

  • ora-14630 : subpartition resides in offlined tablespace
  • ora-35810 : (XSINPUTERR) The command has requested more input than was supplied in the command string.
  • ora-31433 : subscriber view does not exist
  • ora-03002 : operator not implemented
  • ora-24807 : LOB form mismatch
  • ora-39952 : only numbers can be specified as range values
  • ora-24317 : define handle used in a different position
  • ora-29807 : specified operator does not exist
  • ora-32406 : cannot alter partitioning for existing materialized view log
  • ora-25006 : cannot specify this column in UPDATE OF clause
  • ora-32101 : cannot create OCI Environment
  • ora-06261 : NETNTT: nrange() failed
  • ora-31514 : change set string disabled due to capture error
  • ora-30348 : ADD and DROP cannot both be specified
  • ora-24759 : invalid transaction start flags
  • ora-19568 : a device is already allocated to this session
  • ora-02188 : Cannot enable instance publicly
  • ora-32834 : Messaging Gateway agent user has not been set
  • ora-29958 : fatal error occurred in the execution of ODCIINDEXCREATE routine
  • ora-13142 : invalid PROXIMITY window definition
  • ora-00254 : error in archive control string 'string'
  • ora-02164 : DATAFILE clause specified more than once
  • ora-12533 : TNS:illegal ADDRESS parameters
  • ora-24172 : rule set string.string has errors
  • ora-31505 : cannot alter or drop predefined change set
  • ora-08342 : sropen: failed to open a redo server connection
  • ora-19322 : An error occurred while reading from host (string): port (string)
  • ora-33429 : (EIFMAKEF17) CAUTION: NTEXT expression will be exported with type TEXT.
  • ora-24093 : AQ agent string not granted privileges of database user string
  • ora-37050 : (XSMLTDCL06) You cannot use the RELATION command with workspace object because analytic workspace string is attached in MULTI mode.
  • 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.